Click the format tab. Select secondary axis for the data series you want to show.
Here are the simple steps you need to follow to create a dual axis.
How to add secondary horizontal axis in excel 2010.
1 select the data series that you want to add to the secondary axis.
Double click the line you want to graph on a second axis.
This is a contextual tab and appears only when you select a chart.
Select a chart to open chart tools.
Select combo cluster column line on secondary axis.
Heres how you add axis titles.
Can you see the secondary axis now.
In the current selection group select the series for which.
Clicking the line once highlights each individual data point on the line.
Select design change chart type.
Double clicking it displays the format data point menu to the right.
Right click on it and go to format data series series option activate secondary axis.
After you create a chart you can add axis titles to the horizontal and vertical axes in charts that have axesyou cant add them to charts that dont have axes such as pie and doughnut charts.
In the dialog box select secondary axes.
This will also make visible the chart tools tab.
Lets change the chart type of the secondary axis.
Now you have two scales in your chart.
Lets do one more thing.
Select the data series for which you want to add a secondary axis.
To select a data series just click on any data point of the data series.
Much like a chart title you can add axis titles help the people who view the chart understand what the data is about.
Switch to the design tab under the charts tool.
Select the drop down arrow and choose line.
Adding the secondary axis manually excel 2010 select the data and insert the chart.
After selecting the column click on format selection.
Here are the steps of adding a secondary axis to this chart.
Here are the steps.
Make sure the column is selected from the format tab.
Select the column that you want to put on a secondary axes.
I choose the average sales price data series as i want to show this data series on the secondary axis.
You can also add a second axis to a line graph or a bar graph.
Add or remove a secondary axis in a chart in excel.
No comments:
Post a Comment