LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default Secondary Axis

Office 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Excel Discussion (Misc queries) 3 May 4th 06 01:58 AM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Charts and Charting in Excel 2 May 4th 06 01:58 AM
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another John Smith Charts and Charting in Excel 7 December 21st 04 08:26 PM


All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"