Share via

Pivot Table / Pivot Chart Sorting

Anonymous
2010-09-27T17:42:13+00:00

I have a pivot table that displays names in descending order.  The corresponding pivot chart displays the names in ascending order.  Whenever I change one, the other sorts in revrese order.  How do I get both to display in the same order?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2010-09-28T08:02:14+00:00

I assume the chart type is a bar chart with category labels running vertically.

Format the category axis to be in reverse order with x-axis crossing at maximum


Cheers,

Andy (www.andypope.info)

Was this answer helpful?

20+ people found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful