This post will guide you how to add secondary Axis to an existing Pivot Chart in your worksheet in Excel 2013/2016. How do I add a secondary axis to a chart in Excel.
Add Secondary Axis to Pivot Chart
Assuming that you have a list of data in range A1:C5, and you want to create a pivot table based on those data, and then create a pivot chart based on this pivot table. I also need to add secondary axis to the created pivot chart in your worksheet. How to do it. You just need to do the following steps:
#1 select the range of cells that you want to use to create pivot table.
#2 go to INSERT tab, click PivotTable command under Tables group. And the Create PivotTable dialog will open.
#3 choose Existing Worksheet option, and select one cell to place the pivot table. Click Ok button. And the PivotTable Fields pane will appear.
#4 choose all fields under the Choose fields to add to report section. And close the PivotTable Fields pane. You would notice that the pivot table is created in your worksheet.
#5 select pivot table you created in the above steps.
#6 go to INSERT tab, click Insert Column Chart command under Charts group. And select Clustered Column. And the pivot chart is created.
#7 right click Sum of Sales series, and select Format Data Series from the popup menu list. And the Format Data Series pane will appear.
#8 select Secondary Axis option under SERIES OPTIONS section. And the close the Format Data Series pane.
#9 you would notice that the secondary axis has been added into your pivot chart.
#10 right click on the Sum of Sales series again, and select Change Series Chart Type from the popup menu list. And the Change Chart Type dialog will open.
#11 click Combo, and select a Line Chart type for Sum of Sales series. And click OK button.
#12 let’s see the current pivot chart with secondary axis.