Hi,
Thank you for the details! I will print this page and
try your directions. From the looks of the directions, I
think this may work. It took me a while to get back to
this project, and I do appreciate your help!


-----Original Message-----
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


.



.