I am really quick stuck on a chart...

 

I have a database with 32+ weeks sales in it for various depts for over 70+ sites. I need to compare one week sales of selected depts to the previous week. I have set up a paramater so the users inputs the weeks required. (week1 and week2) . I have a formula that then only selects that weeks data (based on the parameters) and the depts required (by report selection ) and groups it by site. I have then created running totals (week1 and week2) and then a formula to calculate difference and then a formula for the % inc dec by site

I would now like to either chart or 'rank' the sites so I can easily show which site has had the best increase but keep the branches in the orignal numeric order.

 

A chart would be prefered but it not possible then rank.

 

Thank you for your help.

 

Jude