Right axis instead of left axis in chart

[saturnin02]

Win XP HE, XL 2002
Hi, How can I have a chart where the y axis is on the right instead of the
left, with the chart having only one data series?
Tx,
S

 

[Myrna Larson]

You can add the series again, so you have 2 series with identical source data.
Plot the one of them on the secondary axis. Then select the left axis and
change the line to none, no labels, no tick marks, etc.

Depending on the type of chart, you may need to change the pattern and line
for one of the series to "none" or white. (When I tried this with a column
chart, the 2nd series completely overlapped the 1st, so I didn't need to do
that.)

 

[saturnin02]

I thought of doing that but perhaps there is a more conventional way of
doing so (w/out adding a second imginary or duplicate datas series)?
S

 

[Myrna Larson]

Ignore my previous response. Excel does have the means do do this without
"tricks".

Right-click on the category (X) axis and select Format Axis. At the bottom of
the dialog box, check the box that says Y Axis Crosses at Maximum Category.

 

[saturnin02]

That's it!!
Tx,
S

Ignore my previous response. Excel does have the means do do this without
"tricks".

Right-click on the category (X) axis and select Format Axis. At the
bottom of the dialog box, check the box that says Y Axis Crosses at
Maximum Category.