How to Add a Second Y Axis to a Microsoft Excel Chart

Add a second Y axis

How to Add a Second Y Axis to a Microsoft Excel Chart Picture 1

Create a chart in excel, assuming that all have the same units.

How to Add a Second Y Axis to a Microsoft Excel Chart Picture 2

Go to the chart and right-click on the line of the data system to which you want to add a Y axis. In this example, if you want to add a Y axis for percentages, right click on the red line.

How to Add a Second Y Axis to a Microsoft Excel Chart Picture 3

Select "Format Data Series".

How to Add a Second Y Axis to a Microsoft Excel Chart Picture 4

Under "Axis," select the radio button next to "Secondary Axis."

How to Add a Second Y Axis to a Microsoft Excel Chart Picture 5

Select OK, you will see the second Y axis appear on the graph.

Change the chart type of the second dataset

How to Add a Second Y Axis to a Microsoft Excel Chart Picture 6

Back on the chart, right-click on the line of the data system to which you want to add a Y axis. In this example, if you want to add a Y axis for percentages, right click on the red line.

How to Add a Second Y Axis to a Microsoft Excel Chart Picture 7

Select "Change Series Chart Type" (Change series chart type)

How to Add a Second Y Axis to a Microsoft Excel Chart Picture 8

Select the chart type for which you want to add the second data series. In this example it is a column graph.

Marvin Fry

Update 10 November 2023