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.

Click anywhere on the second chart to select the chart. Press "Ctrl" and "V" to paste the copied data to this chart. Excel will add all of the data series from the first chart into the second one.

Learn how to create a Combination Chart in Microsoft Excel. We also show you how to to combine bar and line graph & create Custom Combo Chart.