Hi Jon,

I'd like to switch the legend entries. As it is now, the legend entry,
which I've place on top of the chart, has "% of Entries" on the left and "#
of Entries" on the right; but the % axis is on the right, which, of course,
means the # axis on the left--which is the way I want them. I just wish I
could force the legend entries to swap sides.

You have a great website, by the way.

Thanks for any help,

Mark

"Jon Peltier" wrote:

Switch the legend entries? Or switch the axis titles?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rutabaga" wrote in message
...
This worked perfectly for my situation, but now I'd like to reverse the
order
of the legend entries so that the legend reference on the left corresponds
with the left axis (and, consequently, the right reference matches the
right
axis). How? I'm getting a headache.


"Jon Peltier" wrote:

Yes, you can switch them, but you'll have to temporarily introduce the
secondary X axis (which Excel doesn't add by default).

Go to Chart menu Chart Options Axes tab, check the same option of
Secondary Category (X) Axis that is checked for Primary Category (X)
Axis.

Double click the primary X axis (bottom of the chart) and on the Scale
tab,
check Value (Y) Axis Crosses at Maximum Category.

Double click the secondary X axis (top of the chart) and on the Scale
tab,
UN-check Value (Y) Axis Crosses at Maximum Category.

Go to Chart menu Chart Options Axes tab, UN-check the option of
Secondary Category (X) Axis that you selected above.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Raph" wrote in message
...
I have a chart that has two Y-axes, the primary on the left and the
secondary
on the right. Is there a way to flip these axes without recreating the
chart? In other words, get the secondary axis to be on the left and
the
primary on the right?

Much appreciated!

Raph