Office XP - "help" doesn't . I want to make a second Value axis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gordon158 - 15 Oct 2007 20:41 GMT

"Make a second value axis". I don't get an expected choice in the Format
menu. Help tells me to use "Selected data series" on the "Format" menu. It
is not there. Is it just me?

Baffled.

Reply to this Message

Jon Peltier - 15 Oct 2007 20:54 GMT

Select a series, use Format menu > Selected Data Series. On the Axis tab,
select Secondary.

Note, you must have at least two series, one each for primary and secondary
axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

> "Make a second value axis". I don't get an expected choice in the Format
> menu. Help tells me to use "Selected data series" on the "Format" menu.
> It
> is not there. Is it just me?
>
> Baffled.

Reply to this Message

David Biddulph - 15 Oct 2007 20:58 GMT

You need to select one of the series in the graph before that entry appears
in the Format menu. If you right-click on the series you can go directly
from the context-sensitive menu.

Signature

David Biddulph

> "Make a second value axis". I don't get an expected choice in the Format
> menu. Help tells me to use "Selected data series" on the "Format" menu.
> It
> is not there. Is it just me?
>
> Baffled.

Reply to this Message