How To Add Secondary Axis In Excel 2010

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Notation:The following process applies to Role 2013 and newer versions. Looking for Office 2010 steps?

Select a chart to open up Nautical chart Tools.
Select Design > Alter Nautical chart Type.
Select Philharmonic > Cluster Cavalcade - Line on Secondary Axis.
Select Secondary Axis for the information series you want to show.
Select the drop-downwardly pointer and choose Line.
Select OK.

Add or remove a secondary centrality in a chart in Office 2010

When the values in a 2-D chart vary widely from data series to data series, or when you have mixed types of information (for case, toll and book), you can plot one or more than data serial on a secondary vertical (value) axis. The scale of the secondary vertical axis reflects the values for the associated data series.

Afterwards yous add a secondary vertical axis to a two-D chart, yous can also add a secondary horizontal (category) centrality, which may be useful in an xy (scatter) chart or chimera chart.

To aid distinguish the data series that are plotted on the secondary axis, you can change their chart type. For instance, in a column chart, yous could alter the data series on the secondary axis to a line chart.

Important:To complete the following procedures, you must have an existing ii-D chart. Secondary axes are not supported in 3-D charts.

You can plot data on a secondary vertical axis one data series at a time. To plot more than one information series on the secondary vertical axis, repeat this procedure for each data series that you want to display on the secondary vertical axis.

In a chart, click the data series that you desire to plot on a secondary vertical axis, or do the following to select the data serial from a listing of chart elements:
1. Click the nautical chart.
  
  This displays the Chart Tools, calculation the Design, Layout, and Format tabs.
2. On the Format tab, in the Current Option group, click the arrow in the Chart Elements box, and and so click the data series that you desire to plot forth a secondary vertical centrality.
On the Format tab, in the Current Choice group, click Format Selection.

The Format Data Serial dialog box is displayed.

Note:If a unlike dialog box is displayed, repeat pace ane and brand sure that you select a data series in the chart.
On the Serial Options tab, nether Plot Series On, click Secondary Axis and then click Close.

A secondary vertical centrality is displayed in the chart.
To change the display of the secondary vertical axis, do the following:
1. On the Layout tab, in the Axes group, click Axes.
2. Click Secondary Vertical Centrality, and so click the display option that you want.
To alter the axis options of the secondary vertical centrality, exercise the following:
1. Right-click the secondary vertical axis, and then click Format Centrality.
2. Under Axis Options, select the options that yous want to apply.

To complete this procedure, you must have a chart that displays a secondary vertical centrality. To add a secondary vertical axis, see Add a secondary vertical axis.

Click a chart that displays a secondary vertical axis.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.
On the Layout tab, in the Axes group, click Axes.
Click Secondary Horizontal Axis, and then click the display option that you want.

In a chart, click the data series that you desire to change.

This displays the Chart Tools, calculation the Pattern, Layout, and Format tabs.

Tip:You tin besides correct-click the data serial, click Modify Series Nautical chart Blazon, and then continue with step 3.
On the Design tab, in the Blazon group, click Modify Chart Type.
In the Change Nautical chart Type dialog box, click a chart type that you lot want to employ.

The first box shows a listing of chart type categories, and the 2nd box shows the available chart types for each chart type category. For more than information about the nautical chart types that you can use, come across Bachelor chart types.

Note:You can change the chart type of only one data series at a time. To change the chart type of more than 1 data series in the chart, repeat the steps of this procedure for each information series that yous want to change.

Click the chart that displays the secondary axis that y'all want to remove.

This displays the Nautical chart Tools, adding the Design, Layout, and Format tabs.
On the Layout tab, in the Axes group, click Axes, click Secondary Vertical Centrality or Secondary Horizontal Axis, and so click None.

Tips:

You can besides click the secondary axis that you want to delete, then press DELETE, or right-click the secondary axis, and then click Delete.
To remove secondary axes immediately later you add them, click Undo on the Quick Access Toolbar, or press CTRL+Z.

When the values in a nautical chart vary widely from data series to information series, you lot tin plot one or more data series on a secondary axis. A secondary axis can also be used as function of a combination chart when y'all have mixed types of data (for case, price and volume) in the same nautical chart.

In this chart, the primary vertical axis on the left is used for sales volumes, whereas the secondary vertical centrality on the correct side is for cost figures.

Practice whatsoever of the following:

Add a secondary centrality

This step applies to Word for Mac only: On the View menu, click Print Layout.
In the chart, select the data series that you desire to plot on a secondary axis, and then click Chart Design tab on the ribbon.

For example, in a line chart, click i of the lines in the chart, and all the information marker of that data series become selected.
Click Add Chart Chemical element > Axes > and select betwixt Secondary Horizontal or 2nd Vertical.

Add together an axis championship for a secondary centrality

This step applies to Give-and-take for Mac only: On the View bill of fare, click Print Layout.
In the chart, select the data series that you desire to plot on a secondary axis, and and then click Chart Blueprint tab on the ribbon.

For instance, in a line chart, click ane of the lines in the nautical chart, and all the data mark of that data series get selected.
Click Add Chart Chemical element > Axis Titles > and select between Secondary Horizontal or 2d Vertical.