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

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
Sherri Castillo
14/04/2015 20:46:40
I really appreciate this site. I have been looking everywhere for this!

Attached link:
https://www.facebook.com/pages/Fibroids-Miracle-Review-Download-PDF-Ebook-Video/792067454179740

REPORT ABUSE
Sherri Castillo
14/04/2015 20:45:43
It has relevant information. Thanks for posting this. Your blog is so interesting and very informative.

Attached link:
https://www.linkedin.com/groups/Skinnylicious-Cooking-Review-Is-it-8263627.S.5977835848706637828

REPORT ABUSE
Sherri Castillo
14/04/2015 20:06:19
Pretty impressive work you've performed here. I truly enjoyed reading most of your posts and I consider your blog great. Please, keep on producing such a quality content. Thank you!

Attached link:
https://www.linkedin.com/groups/Revolutionary-Sex-Review-Is-it-8262451.S.5976640277673242627


Add comment

Missing a guide in ComAround Free?

Please specify your request here:
?
Request guide

Most helpful in Excel 2010

Excel 2010
By ComAround
9346 31 3
Excel 2010
By ComAround
29253 14 4
Excel 2010
By ComAround
3671 10 3
Excel 2010
By Caroline
6243 10 4
Excel 2010
By ComAround
47438 8 9


Most viewed in Excel 2010

Excel 2010
By ComAround
47438 8 9
Excel 2010
By ComAround
43349 1 11
Excel 2010
By Caroline
29379 0 1
Excel 2010
By ComAround
29253 14 4
Excel 2010
By Caroline
25713 7 5