HI Jon:
Coincidentally, I am trying to solve a similar problem. I am in Windows2003.
The help instructions in the program are really direct.
1. Click the data series you want to plot along a secondary value axis.
2. On the Format menu, click Selected Data Series, and then click the Axis
tab.
3. Click Secondary axis.
Yet, I am not finding this format menu with a data series option. Also what
I am trying to do is to have a stacked bar as the primary and a line graph on
the secondary. I am assuming this is possible, though it's not visible in the
chart options.
I appreciate your advice.
Many thanks,
Jen
"Jon Peltier" wrote:
Did you add the data in column Q as a second series in the chart? If there
is only one series in the chart, as I stated in my first reply to your post,
you cannot have a secondary axis. The position of the data in the worksheet
has NOTHING to do with it.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"dsteven" wrote in message
...
I had a scater chart with the following data series A1:A20 (Date) the next
data series was in E1:E20 (Value $). A1:A20 is the horizontal axis and
E1:E20
is the vertical axis on the left side of the chart. When I attempted to
add a
secondary axis, that is, a secondary vertical axis on the right side of
the
chart, for data series Q1:Q20, the formatting tools were not available. So
I
inserted a column at column F and moved column Q data to column F. By
doing
this, I could click on the existing chart, reveal the data series
associated
with the chart, and then click on teh blue outline and drag it to the
right
to include the data series in column F.
My efforts to include the secondary data series while in column Q were
unsuccesful. Even fiddling with the control key and trying various ways to
see if that would help. Hope this hlps.
"Christopher Scott [MSFT]" wrote:
I'm curious about the problem/solution you found. I tried one
column/series
of data in one part of the sheet (A1:A5) and another column/series of
data in
a non-adjacent part of the sheet (F12:F17) and was able to move the
second
series to a secondary axis.
Could you elaborate? The description of your solution sounds like you are
trying to add more data to the chart by dragging the blue outlines on the
cells when the chart is selected.
--
Thanks,
Christopher
This posting is provided "AS IS" with no warranties, and confers no
rights.
"dsteven" wrote:
Answer to my own question. When you explore long enough maybe you can
find
ananswer. This didn't come from Micro Soft.
When adding a secondary axis data series it matters that the column of
data
containing the secondary axis data series be adjacent to the column
containing the primary data series. When this is the case, clicking on
the
chart will outline the coulmn data series and the outline can be
clicked on
and dragged to include the column containin the secondary data series.
At
this point, the data points will be representd on the chart and the
format
window will provide the opportunity to select secondary data series.
I just can't find the words to thank Micro Soft for being so clear in
their
help screens. Its a great product with strong capibilty but the help
screens
are inferiior in their content. Work on it Micro Soft.
"dsteven" wrote:
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.