PivotChart - Sort

[BoRacho]

I have a pivotchart based off a pivot table. The pivot table is sorted in ascending order but the pivotchart is sorted in descending order. I've gone through the pivot chart tool bar, selected advanced, and made sure the radio button under the AutoSort options was selected. This is happening on all my pivotcharts in different files. (I just figured out how to set pivotcharts up yesterday). Any suggestions as to how to fix the charts?

 

[Dan Waterloo]

Do you mean that the values on the x-axis are in descending order or that the values on the y-axis are in descending order?

Possible solution: Right click the x-axis, select /Format Axis/Scale, and then tick the Categories in Reverse Order box.