Top 5 reports with PivotTable and PivotCharts

Switch the order of the Axis

When you create a top 5 sorted report with a PivotTable, the Pivot Chart isn’t always what you expect, there is an easy solution.

You can download the example file using the button at the bottom of the post.

The image below has the data layout.

When you create the filter the top 5 PivotTable report and then sort it Largest to Smallest, it looks like this.

Then when you add the PivotChart it looks like this.

Not quite what we were expecting – its showing smallest to largest.

We need to switch the order of the vertical axis. Luckily there is a setting you can change to get the chart displaying correctly – largest to smallest.

Click the left axis and press Ctrl + 1 ( use the 1 on the keyboard).

In the task pane that opens on the right select Categories in reverse order.

Problem solved.

Download example file

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.