How to create Excel 2007 Chart with 2 Y-axis or X-axis

In this video tutorial we will show you how to create Excel chart with 2 y-axis or x-axis.


In order to create an Excel chart with 2 y-axis or x-axis, open your Excel document. Select the data in your document.

Select the data

Go to the “insert” tab. Click on “Column” and choose “2-D column”.

Choose 2-D column

Select columns in chart with a mouse click. Go to the “Format” tab and choose “Format selection”.

Choose Format section

In the appeared window, choose “Secondary Axis” in “series Options”. After that, right-click on columns and choose “change series chart type”.

Choose change series chart type

Select “Line” chart.

Select Line chart

Now you know how to create a chart with 2 y-axis or x-axis in Excel.