Fantastic Add Second Series To Excel Chart
Ask a Question.
Add second series to excel chart. Yeah youll need to add a second series and change the chart type for that series to XYScatter. In excel 2016 by default Excel will suggest you use a chart with a secondary axis. Excel use primary axis in charts to change which axis - primary or secondary - can uses for the data series do the following.
Active 5 days ago. In the Insert Chart dialog box choose the All Charts tab. To make the chart easier to read Excel allows us to add a secondary axis for the chart heres how you add a secondary axis for the combination chart in Excel.
On the right side you will find the data Series Names 2 drop-down menus under the Chart Type heading and 2 checkboxes under the Secondary Axis title. I am having trouble adding another series to a chart. So right click the plot area of the chart.
Select the chart area of a chart click in the Formula Bar or not Excel will assume youre typing a SERIES formula and start typing. You can also add a new series to a chart by entering a new SERIES formula. Select the data in the spreadsheet for exampl D1 to D6 and copy.
Its even quicker if you copy another series formula select the chart area click in the formula bar paste and edit. Right-click the chart and then choose Select Data. Right-click the series you just added to the plot area in your chart select chart type and change the graph to XYScatter.
Use Paste Special for fine tuning. In the Charts group click on the Insert Columns or Bar chart option. Click the chart and paste.