Excel chart: 2 Y-axes of the insert

You will learn in this tip how to insert a Excel chart 2 Y-axes. This is not any chart, but for the most common shapes, such as column and line chart, you can use a second Y-Ache insert. In our Video you can see how it works exactly.

Two Y-axes in Excel chart insert

Open Excel and mark your chart.
Click on "Insert" to "column" and select, for example, a 2D-type of column.
A chart will be created for you. Click the column chart to a bar value. After you have marked out, for example, the red columns, click with the right mouse button on the marker. Select the rows of the "data change chart type...".
In the opened window, select e.g. "line", the red columns as a line.
Select the red line and click again by right-clicking on it. Now select "format data series..."
Under "series options" put a tick "secondary axis". Your chart has two Y-axes.

In a further practical tip you will learn how to Pivot tables in Excel.