How to Add a Second Y-Axis on Excel & Make a Second Series at the End of the Chart. Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet.

If you use a line chart with two columns of data, each column will represent the Y axis of a separate line. More For You How to Change Columns Into Rows in Excel 2007 ...

How to create a Line Chart in Excel. To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12).