How to Add Secondary Axis to Pivot Chart in Excel

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.

add secondary axis to pivot chart1

#2 go to INSERT tab, click PivotTable command under Tables group. And the Create PivotTable dialog will open.

add secondary axis to pivot chart2

#3 choose Existing Worksheet option, and select one cell to place the pivot table. Click Ok button. And the PivotTable Fields pane will appear.

add secondary axis to pivot chart3

#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.

add secondary axis to pivot chart4

add secondary axis to pivot chart5

#5 select pivot table you created in the above steps.

add secondary axis to pivot chart6

#6 go to INSERT tab, click Insert Column Chart command under Charts group. And select Clustered Column. And the pivot chart is created.

add secondary axis to pivot chart7 add secondary axis to pivot chart8

#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.

add secondary axis to pivot chart9

#8 select Secondary Axis option under SERIES OPTIONS section. And the close the Format Data Series pane.

add secondary axis to pivot chart10

#9 you would notice that the secondary axis has been added into your pivot chart.

add secondary axis to pivot chart11

#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.

add secondary axis to pivot chart12

#11 click Combo, and select a Line Chart type for Sum of Sales series. And click OK button.

add secondary axis to pivot chart13

#12 let’s see the current pivot chart with secondary axis.

add secondary axis to pivot chart14

 

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar