Favorite Adding Secondary Axis In Excel
Switch this data series from your primary Y axis to your secondary Y axis.
Adding secondary axis in excel. Use the quarterly observation date column first column as the horizontal axis ie the axis label for the GDP. In this article were going to show you how to add a secondary axis in Excel. Select Combo Cluster Column - Line on Secondary Axis.
Adding a secondary axis in Excel is very easy. I see some documents on. Below are the steps to add a secondary axis to the chart manually.
In the Charts group click on the Insert Columns or Bar chart option. Create a chart with your data. Select the data set Click the Insert tab.
Select the series you want to add a secondary axis for. The second method is. Combination Chart Basics Sections.
When you add the secondary horizontal axis Excel adds it to the top of the plot area shown as blue in the above example. Select a chart to open Chart Tools. We also saw how to change the chart type of the secondary axis.
I can not find the correct menu to add that. Following are the steps you should follow to add a secondary axis to your Excel chart. Under the Format tab click on the drop-down list in excel of Current Selection and select Series Target Achieved This will select the Target Achieved column bars.