Excel diagram: insert 2 Y-axes

In this practical tip, you will learn how to insert 2 Y-axes in an Excel diagram. This is not possible with every diagram, but for the most common shapes, such as column and line diagrams, you can insert a second Y-axis. In our video you can see how it works.

Insert two Y axes in Excel chart

1. Open Excel and mark your diagram.
2. Click on "Insert" on "Column" and select, for example, a 2D column type.
3. A diagram will be created for you. Click a bar value in the bar chart. After you have marked the red columns, for example, right-click on the marking. Select "Change Series Chart Type ...".
4. In the window that opens, select "Line", for example, to display the red columns as a line.
5. Mark the red line and right click on it again. Now select "Format data series ..."
6. Under "Row options" you now place a checkmark next to "Secondary axis". Your diagram now has two Y axes.

Another practical tip tells you how to create pivot tables in Excel.

Latest videos

Select your diagram and choose a column type.

For example, mark the red bar in the diagram and change its diagram type.

Select a "Line" as the diagram type.

Now format the data series.

Select under "Row options" -> "Secondary axis".

"" Secondary axis ".>

"Secondary axis". "/>

"Secondary axis". "/>

You get a diagram with 2 Y axes.