![excel 2016 chart axis labels angle excel 2016 chart axis labels angle](http://cameron.econ.ucdavis.edu/excel/linechart6.gif)
EXCEL 2016 CHART AXIS LABELS ANGLE SERIES
From the menu, select Combo and set both the chart types to “line” and set the GDP growth data series to the secondary axis.ħ. Right-click on the chart and choose “Change Chart Type.” The following menu should appear:Ħ. The chart should look like the one below:ĥ. Use the quarterly observation date column (first column) as the horizontal axis, i.e., as the axis labels for the GDP growth. Add the GDP growth column (fourth column) to the chart by right-clicking on the chart and clicking on select data and then adding a new data series. It can be done by changing the number format in the right-hand side formatting pane to yyyy.Ĥ. Change the format of the axis labels to show year only. Use the quarterly observation date column (first column) as the horizontal axis, i.e., the axis label for the GDP. Select the GDP column (second column) and create a line chart.
![excel 2016 chart axis labels angle excel 2016 chart axis labels angle](https://jasonfischman270.files.wordpress.com/2016/02/2-70-pup3-axis-apportionment-error.png)
Open the file in Excel, and get the quarterly GDP growth by dividing the first difference of quarterly GDP with the previous quarter’s GDP.ģ. Download the sample US quarterly GDP data here.Ģ.
EXCEL 2016 CHART AXIS LABELS ANGLE HOW TO
The next section will provide a step-by-step guide on how to recreate the exact chart.Īdding a Secondary Axis in Excel – Step-by-Step Guideġ. The left-hand side vertical axis measures the GDP in levels, whereas the right-hand side vertical axis measures the growth in GDP. The chart below is made from US quarterly GDP data. We can either standardize the data, i.e., use an index for the data, or use a secondary axis. For example, it is impossible to compare aggregate GDP with the unemployment rate using the same scale. The feature is especially useful when we want to compare data series that are measured in different units or with different scales of comparison. A secondary vertical axis gives us more versatility with regards to data visualization and also provides us with the ability to plot multiple data series on the same chart.Ī secondary axis allows us to represent and visualize multiple data series without the need to use additional charts.
![excel 2016 chart axis labels angle excel 2016 chart axis labels angle](http://cs.cheggcdn.com/covers2/imagenalarge.gif)
The article below provides a step-by-step guide on how to add a secondary axis to charts in Microsoft Excel. Updated JHow to Add a Secondary Axis in Excel?