Open the file in Excel and get the quarterly GDP growth by dividing the first difference of quarterly GDP with the previous quarters GDP. Click on it and it is done. But what if we need two axes ie. Add your second data series. Gather your data into a spreadsheet in Excel. Go to the INSERT tab in the Ribbon and click on the Combo Chart icon to see the pie chart types then select Create Custom Combo Chart The Insert Chart dialog will show you a preview of the available chart types. The first step to create advanced Excel charts is to learn how to add a secondary axis in a chart. Gather your data into a spreadsheet in Excel. Combo -- Click on second Clustered column - line on the secondary axis. For the purposes of this process well create three rows of data.

Add your second data series. Click on the recommended chart. How to Add Secondary Axis in Excel. In the Charts group click the Recommended Charts option. Excel Add Secondary Axis Table of Contents Example of Secondary Axis in Excel. Then choose the Combo option from the left menu. Steps to Add Secondary Axis in Excel. Select the chart that you want to add axis label. Navigate to Chart Tools Layout tab and then click Axis Titles see screenshot. Adding a secondary axis in Excel is very easy.

How to Add Secondary Axis in Excel. Select Combo from the list and then check the checkbox of the data you want to add a secondary axis for. You should now have an axis title to the right hand side secondary axis. Following are the steps you should follow to add a secondary axis to your Excel chart. Click in the plot area. Gather your data into a spreadsheet in Excel. How to Add Secondary Axis in Excel Charts. Create a chart with your data. Adding a TrendLine to a Time Series Line Chart in Excel 2010. 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.

Select Combo from the list and then check the checkbox of the data you want to add a secondary axis for. And it is done. Here is how I made it by browsing the Help function in Excel. If you look at the below two charts in the first chart you have two different data column series but the axis is the same. In excel 2016 by default Excel will suggest you use a chart with a secondary axis. How to Add Secondary Axis in Excel. Gather your data into a spreadsheet in Excel. Select the entire data by having an active cell within data range and hitting CTRLA shortcut. 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. Following are the steps you should follow to add a secondary axis to your Excel chart.

On a Mac Computer Using Excel 2016 1. Select a chart to open Chart Tools. Excel Add Secondary Axis Table of Contents Example of Secondary Axis in Excel. Add your second data series. Click the Insert tab. To change chart type go to Design tab and click on Change Chart Type. Gather your data into a spreadsheet in Excel. Gather your data into a spreadsheet in Excel. Adding a second data set on the. Click the green plus appearing to the right.