Select the data series for which you want to add a secondary axis. A secondary axis in excel is a marker on the right edge of the chart that measures a different value on the chart.
Now you have two scales in your chart.
How to add secondary axis in excel 2007.
An axis title at the bottom of the graph should appear just overwrite axis title with the text that youd like to see.
On the format tab in the current selection group click format selection.
Here are the simple steps you need to follow to create a dual axis.
How to add a second y axis to a graph in microsoft excel.
Select the data and insert the chart.
On the series options tab under plot series on click secondary axis and then click.
2 now right click on the data series and choose format data series option from the menu.
A secondary axis is required when you have to compare two distinct types of series on the same charts mostly whole values and percentages.
Steps for adding a secondary axis in your chart.
Click the format tab.
Now if you want to add axis titles select the chart and a layout tab should appear in the toolbar at the top of the screen.
4 though we have placed.
If the text you want for your axis title is already in your worksheet you can link.
In the current selection group select the series for which you want to add a.
Then select axis titles primary horizontal axis title title below axis.
In case youre using excel 2010 you can follow the below steps to add a secondary axis.
Adding secondary axis to this chart 1 select the data series that you want to add to the secondary axis.
Create a spreadsheet with the data you want to graph.
Click the line graph and bar graph icon.
Select all the cells and labels you want to graph.
Click on the layout tab.
Right click on it and go to format data series series option activate secondary axis.
This will also make visible the chart tools tab.
Double click the line you want to graph on a secondary axis.
3 format data series task pane appears on the right side of the worksheet.
Excel 2007 doesnt have a dialog box that allows you to edit chart and axis titles you need to insert them.
Add a secondary vertical axis office 2010 in a chart click the data series that you want to plot on a secondary vertical axis.
No comments:
Post a Comment