Prev: how can I plot a curve with variable x, y, z in excel
Next: Charting the Sum of Two, or More, Series of Data
From: DogEatDog World on 20 Apr 2010 11:41
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.

Thanks in advance,

From: Luke M on 20 Apr 2010 14:35
Under Field Settings (right click on the data block) you can change sort
order.

--
Best Regards,

Luke M
"DogEatDog World" <DogEatDogWorld(a)discussions.microsoft.com> wrote in
message news:AC752DAD-CC24-4CD5-8FB2-8CBB658889C5(a)microsoft.com...
> 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.
>
> Thanks in advance,
>


 | 
Pages: 1
Prev: how can I plot a curve with variable x, y, z in excel
Next: Charting the Sum of Two, or More, Series of Data