Now close the dialog/pane, you can see the secondary axis has been added to the pivot chart.Ĥ. In Excel 2013, check the Secondary Axis option under the Series Options in the Format Data Series pane.ģ.
In the Format Data Series dialog, check Secondary Axis option in the Series Options section. Right click at the Sum of Profit series, and select Format Data Series from the context menu.
Now I am talking about adding a secondary axis to a pivot chart in Excel to solve this problem.įor instance, I want to add a secondary axis to show Legend series of Sum of Profit.ġ. A pivot chart can help us to quickly analyze base data, but sometimes, if there is a great values’ difference between the series, the chart will be shown not beautiful and exact enough as below screenshot shown.
