Thread: Secondary Axis
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Secondary Axis

See my response in the charting group.

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


"dsteven" wrote in message
...
Ofice Standard 2007. To add a secondary vertical axis Excel Help says at
instruction 1.2 On the Format tab, in the Current Selection group, click
the
arrow next to the Chart Elements box, and then click the data series that
you
want to plot along a secondary vertical axis.

The Current Selection group doesn't have a Chart Elements to select from,
but the illustration does show Chart Area with the arrow next to it. It
would
be nice and very helpful if the terminaolgy were consistent.

Insturction 2. goes on to direct more or less accurately. When I click on
Format Selection it brings up a dialogue box titled Format Axis. Again, it
would be nice and very helpful if the terminaolgy were consistent.

Instruction 3. directs = Click Series Options if it's not selected, and
then under Plot Series On, click Secondary Axis and then click Close.

Here I could not find the function Series Options, there is an Axis
Options,
which I would presume is what might be referred too, however, there is no
function available titled Plot Series On or Secondary Axis.

This is where the problem lies. If I can't get Series Options to bring up
the functions plot Series On or Secondary Axis, I can't get the secondary
axis on the chart.

Sorry this is so lengthy but I think and I'm hoping explaining the problem
in detail might attract an accurate response from MicroSoft support
people.
Any one else who has a suggestion, I'd be glad to hear from you.