Prev: Excel 2007 - How can I switch the data on vertical and horizontal
Next: Anchoring Phase Change Lines
From: DogEatDog World on 27 Mar 2010 05:55 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 |