You need to have at least one series for each axis. To assign a series
to primary or secondary axis, double click on it, and on the Axis tab,
select the desired axis.

If you've done this, and the desired axis does not show up, right click
the chart, select Chart Options from the pop up menu, click on the Axes
tab, and make sure all the desired axes are checked.

If the secondary Y axis still doesn't show up, Excel is trying to put it
and the primary axis in the same place. Repeat the last step to
(temporarily) add a secondary X axis, then format this axis so the
corresponding Y axis crosses where the primary Y axis isn't in the way.
By default, secondary axes are formatted so the axis crosses at the
maximum, so you can uncheck this box, and both Y axes should be visible.
Now you can uncheck the secondary X axis in the Chart Options/Axes dialog.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

jw wrote:
Thank you! You have correctly restated my problem. I
think I need details though. I selected the lower x axis
and adjusted the scale from "Value (y) axix crosses
between categories" to "Value (y) axis crosses at maximum
category" or "Categories in reverse order". The y axes
flipped! However, on the left side of the chart only a
title appeared, with no actual y axis. I tried to find
this y axis but it appears to be missing.

What should I try next?


I think we may have a misunderstanding here. I think

the basis of the

misunderstanding is the assumption that the secondary

axes are on the

right/top of the screen, which is not necessarily true.

Allow me to restate

the problem so you can correct me if I have it wrong.

You want one x-axis, preferably at the bottom of the

screen. The x-axis

data for all series is the same and it is uniformly

spaced so that a value

and category axis looks the same. You want two y-axes,

the left y-axis

being percent cover and the right y-axis being

precipitation.

Did I get that right? If so, you can move the primary y-

axis to the right

and the secondary y-axis to the left side of your chart

(sort of a

flipflop). You can also flipflop the x-axes. The basic

idea is to select

an axis, Format | Selected axis | Scale tab, change the

value next to "(X or

Y) axis crosses at:." More details if you need it.

Dave
dvt at psu dot edu


.