Simple Excel Line Chart Add Secondary Axis

The only way this can happen is if the smallest and biggest number for both data series are the same.

Excel line chart add secondary axis. Following are the steps you should follow to add a secondary axis to your Excel chart. In this example it is the data from the growth column which needs to be displayed with a line chart. Select the data series for which you want to add a secondary axis.

I select a column chart and this is how it looks. Lets change the chart type of the secondary axis. Add a second line to graph in Excel in under one minute.

Click on that dropdown and click on your secondary axis name which in this case is Percent of Nike Shoes Sold Under the Axis drop-down change the Left option to Right This will make your secondary axis appear clearly. Select the drop-down arrow and choose Line. Navigate to Insert - Charts-Combo-Clustered Column-Line on Secondary Axis Below is the chart Microsoft Excel inserted by Default.

Click on change chart type and select the chart of your choice. Make sure the column is selected from the format Tab. Brought to you by the PPC Ex.

Select Secondary Axis for the data series you want to show. Add the secondary vertical axis to any of the data series see How to create two vertical axes on the same side. Create a common scale for the Primary and Secondary axis The trick is to create a common scale so that the primary and secondary axis start and end at the same point.

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. In excel 2016 by default Excel will suggest you use a chart with a secondary axis. 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.