1. Open your Excel workbook and locate the graph you want to add your second set of data. 2. Right-click on the graph and select ‘Select Data.’ 3. A ‘Select Data Source’ window will appear on the ...

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.

These instructions work in Excel in Microsoft 365, Excel 2021, Excel 2019, Excel 2016, and Excel 2013. How to Add a Secondary Axis to an Excel Chart Excel charts offer a variety of ways to ...

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.

Bar Chart . In an Excel bar chart, each data point is represented by a rectangular, horizontal bar. The length of each bar is determined by the size of its corresponding value in the data set.