Secondary Axis

D

dsteven

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top