Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |