Forum Discussion
Excel Mac Pivot Charts - Can you switch rows and columns without changing the pivot table?
Hi, I love the new Pivot Chart feature on Excel 2016 for Mac. However sometimes I would like to Switch Rows and Columns on the chart without affecting the pivot table. For instance, in a piv...
I'm having the same issue. Very annoying.
If your pivot table has time across columns, (ex: Jan, Feb, Mar - most common in finance) the pivot chart automatically uses that data for the y axis (instead of x).
How can this be switched?
Hi Tom,
Pivot Chart is always has the same layout as connected Pivot Table. You may create and hide another Pivot Table to which your Pivot Chart will be connected; or create Power Chart only from data model with Power View (for Windows, not sure how it is on Mac)