Order of stacked bar chart values in Excel

[PeteG]

Hi,

I have a pivot chart and I am trying to find a way of ordering each individual stacked bar by value with the largest value at the bottom. Is this possible?

Another quick question on the subject of pivot charts if I may. Along the horizontal axis, I have the names of the field that I have chosen to display there...but I am wondering if I can give them each a custom name rather than the names that automatically appear form the pivot table data I am using?

 

[PeteG]

I have found an answer to the second question of mine. I can just over-type the row labels in the pivot table that my chart is based on and call them whatever I like. I guess that is likely to be a problem if the order of my pivot table changes or the number of rows in the pivot table grows or shrinks but, for what I am doing, I think that is going to be static so I should be OK there.

 

[SkipVought]

The associated PivotTABLE dictates what is displayed in the Pivot Chart.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]