I have created a Pivot Table from my Microsoft Excel Worksheet Table. From this Pivot Table I have created a Pivot Chart.
The table and chart I created are shown on the attached PDF file.
The problem I am having is I would like the sort order for the Row Labels on the Pivot Table to match the sort order for the Pivot Chart Clustered Bar Chart Vertical Axis.
Current Sort Order
Row Label Sort - Blank, 10 thru 9
Chart Vertical Axis ? 9 thru 10, Blank
This sort order is the complete opposite of each other.
The Table and Chart are linked together and if I try and change the order on Row Label Sort it changes the sort order of the Chart Vertical Axis.
How can I make the two sort orders the same?
I would like the sort order to be the same as the current sort order the Row Label Sort.
This has been really frustrating trying to figure out how to this !!!!.
Bookmarks