Impressive Add Secondary Axis
Select the radio button for Secondary Axis.
Add secondary axis. Select Combo Cluster Column - Line on Secondary Axis. The first step is to select the graph type directly from Insert Combo and select the Clustered column-Line on secondary axis as shown below. A secondary axis is required when you have to compare two distinct types of series on the same charts mostly whole values and percentages.
To add a secondary horizontal axis do the following. In Excel 2013 in the Change Chart Type dialog click Combo section and go to the series with secondary axis in the Choose the chart type and axis for your data series section click the following Chart type box and select Line chart from the drop down list. 1 In this way at first select all the data or select a cell in the data.
There are some steps to add a secondary axis. Open the file in Excel and get the quarterly GDP growth by dividing the first difference of quarterly GDP with the previous quarters GDP. The legend is an indicator that helps distinguish the data series.
Add the secondary vertical axis to any of the data series see How to create two vertical axes on the same side. The second method is using a column chart. All secondary axes must be based on a one-to-one transformation of the primary axes.
Select Secondary Axis for the data series you want to show. Adding a secondary axis in Excel is very easy. Without any delay lets start with practical use.
In this post we saw how to add a secondary axis. This immediately displays the line on a secondary axis. We also saw how to change the chart type of the secondary axis.