Switching Rows and Columns in a PivotChart

Finding the hidden option

Switching between rows and columns in a normal chart is easy via a button on the Design tab. But how do you do it with a PivotChart?

By switching between rows and column in a normal Excel chart you can discover a different, and sometimes a better way, to display the data.

The button on the Design ribbon tab works for normal charts but is not available for PivotCharts.

PivotCharts don’t have a Design tab. So how do you do it?

Right click the PivotChart and choose Select Data.

The Switch Row/Column button is hiding in there. Click OK once you have clicked it.

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.

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

One thought on “Switching Rows and Columns in a PivotChart

  1. Note that the chart doesn’t start plotting with series in rows. The pivot table itself pivots its rows and columns, and the chart still plots the pivot layout by columns.