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

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
kim
gave this guide
03/09/2014 06:13:50
its work ?

Attached link:
http://kokonami.drupalgardens.com/blog

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.


Add comment

Missing a guide in ComAround Free?

Please specify your request here:
?
Request guide

Most helpful in Excel 2010

Excel 2010
By ComAround
9034 31 3
Excel 2010
By ComAround
26311 14 1
Excel 2010
By ComAround
3444 10 3
Excel 2010
By Caroline
5978 10 4
Excel 2010
By ComAround
32671 8 6


Most viewed in Excel 2010

Excel 2010
By ComAround
38899 1 2
Excel 2010
By ComAround
32671 8 6
Excel 2010
By Caroline
28056 0 1
Excel 2010
By ComAround
26311 14 1
Excel 2010
By Caroline
21420 7 4