Sorting PivotChart data
 

Hi,
In excel 2007 I want to sort data in the chart I made from pivot. I want
them to be sort in descending order. The reason is, I need bar Pivotchart
diagram to use as Pareto chart.
I'm also using this new function in excel 2007 , "drill-down" or
"drop-down" to multiple levels/layers in PivotChart. I want also those
sub-level data to be arranged in descending order.
I'm doing stratification(sequence of Paretos) of data in my plant so I need
it desperately. It would make my life easier.

Thanks in advance,
Slobodan