TipsMake

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

It would be helpful if you knew how to add multiple data lines to an Excel chart. However, with data with many units, you may find it difficult to create the graph you need. Don't worry, not only can you do it, you can do it very easily!

★ Modify the axis of the chart in Excel
★ How to Add a Second Y Axis to a Graph in Microsoft Excel

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.

Discover more

Marvin Fry

Share by

Marvin Fry
Update 10 November 2023

You should read it