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.