Brilliant Excel Add Another Axis
In this example it is the data from the growth column which needs to be displayed with a line chart.
Excel add another axis. First off you have to click the chart and click the plus icon on the upper-right side. 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. Add the secondary vertical axis to any of the data series see How to create two vertical axes on the same side.
Then check the tickbox for Axis Titles. Select Secondary Axis for the data series you want to show. However well want to scale the acceleration data so that it fills the chart area.
If I remove regionthe checkbox is gone. Select the series you want to add a secondary axis for 2. Create a chart with your data.
Right-click two-finger tap on the series 3. Excel allows us to add a second axis to a scatter chart well use this for velocity and acceleration. For example I can use select data to include the airport codes as well.
Select the chart and then under Chart Design click the Add Chart Element button and then click Axis Titles. For this scenario use the title Units Sold. To change chart type go to Design tab and click on Change Chart Type.
To add a secondary horizontal axis do the following. Adding a TrendLine to a Time Series Line Chart in Excel 2010. If I try to use the control key.