Cool Add 2nd Axis To Excel Chart

Select Secondary Axis for the data series you want to show.

Add 2nd axis to excel chart. Brought to you by the PPC Ex. See below screen shot. In the combination chart click the line chart and right click or double click then choose Format Data Series from the text menu see screenshot.

In out example we set line chart for. Add a second line to graph in Excel in under one minute. Gather your data into a spreadsheet in Excel.

Create a chart with your data. And the plotted columns of each series overlap each other instead of being on next to the other. Add your second data series.

The simplest way to Add Secondary Axis to Chart in Excel is to make use of the Recommended Charts feature as available in Excel 2013 and later versions. To add a secondary horizontal axis do the following. Select the source data and then click the Insert Column Chart or Column Column on the Insert tab.

Select the data series for which you want to add a secondary axis. As soon as I add a 2nd axis excel 2016 converts the chart type to combo. We quickly show you how to add a secondary axis line in an Excel graph.

How do I make the 2axis variant look like the 1axis variant except the scaling. Select the data set Click the Insert tab. In the Charts group click on the Insert Columns or Bar chart option.