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.