Pivot Table/Pivot Chart Sorting

[PivotMeThis]

My pivot table has a column label of performance (good, fair and poor). A row label of year (2011, 2012, 2013) and values (this is a calculated field, percent of row total). This all looks great.

Then I created a pivot chart and used a stacked row chart. It looks great but the PROBLEM is that it is sorted the opposite of the pivot table. These are being displayed on the same sheet and need to be sorted the same way. If I try to change one it flips the other. The table is sorted 2011, 2012, 2013. The chart has 3 stacked rows, the top one is 2013, then 2012, 2011.

What can I do to make these the same???
thanks!

 

[Jerry Sullivan]

Hi Rhonda,

Right-click the Y-Axis of the Bar Chart (the years)
Format axis.... > Axis Options > Check "Categories in reverse order"

You changed your screen name since we last shared a thread - I like it!

 

[PivotMeThis]

Hi Jerry

I tried that but it moved the X axis (percentages) above the chart. Hoping to keep them at the bottom but will see if upper management can live with it

Thanks my friend. Always good to see you on the board
Rhonda

 

[Jerry Sullivan]

Hi Rhonda, In your PM to me on another topic, you mentioned that you figured out that you just needed to change the Axis Labels option to "High" and it resolved your problem with the X axis (percentages) moving above the chart.

Glad you were able to solve that.

 

[chicken noodle]

Hi, i know im late, today is 2021 but maybe someone will come and search the same thing like you, so ill drop a link for that problem,

watch carefully, dont give up!?

 

[ExcelKnut]

Hi Rhonda,

Right-click the Y-Axis of the Bar Chart (the years)
Format axis.... > Axis Options > Check "Categories in reverse order"

You changed your screen name since we last shared a thread - I like it!

I couldn't figure it out, but that solution worked like a charm (14 years later)! Thanks Jerry!!!