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.

Open the Excel 2010 spreadsheet that holds the two charts you want to make into one. Click on the first chart to activate it, then click on any of the data series that make up the chart.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

You can insert a chart in Excel by selecting your dataset, heading over to the Insert tab, and clicking the chart type you want in the Charts group of the ribbon. Then, you can customize them by ...