Start Page / Office applications / MS Excel / Excel 2010 / Charts with two value axes
ComAround published this guide
29 February 2012
Microsoft® Translator
35731 50 % 1

If you have a chart in which you want to display two column values that differ significantly, i.e. the scale of the value axis must not display the column values together, you must add a secondary value axis.

This is what you do:

1. Click the chart.

2. Click the Layout tab.

3. Click the list arrow to the right of the top pane in the Current Selection sub-tab.

4. Click the series for which you want to add a secondary axis.

5. Click Format Selection in the Current Selection sub-tab.

6. Select Secondary Axis.

7. Click Close.

8. Right-click the secondary bar series.

9. Click Change Series Chart Type in the shortcut menu.

10. Double click a line chart type.

https://support.comaround.se/accounts/1/guides/75373/images/sekundäraxel5.gif


Share this guide
Helpful guide?
No Yes

Add comment

Comments

REPORT ABUSE
Diane Harrel
03/04/2013 00:26:36
This does not work when you are using 3D charts...at least I could not get it to work.


Missing a guide in ComAround Free?

Please specify your request here:
?
Request guide

Most helpful in Excel 2010

Excel 2010
By ComAround
8907 31 3
Excel 2010
By ComAround
24937 14 1
Excel 2010
By ComAround
3358 10 3
Excel 2010
By Caroline
5886 10 4
Excel 2010
By ComAround
4175 7 0


Most viewed in Excel 2010

Excel 2010
By ComAround
35731 1 1
Excel 2010
By ComAround
29076 7 2
Excel 2010
By Caroline
26470 0 1
Excel 2010
By ComAround
24937 14 1
Excel 2010
By Caroline
19984 7 3