So that seems to mean that I cannot change the order of left and right with
respect to each others.
Thanks for the info.
Bryan


"Jon Peltier" wrote in message
...
Bryan -

You can flip the chart so the primary is on the right and secondary on the
left.

1. Chart menu - Chart Options - Axes tab: check the Secondary Category
Axis (if it isn't already present).

2. Double click primary category axis (bottom), Scale tab, check Value
Axis Crosses at Maximum Category.

3. Double click secondary category axis (top), Scale tab, uncheck Value
Axis Crosses at Maximum Category.

4. Chart menu - Chart Options - Axes tab: uncheck the Secondary Category
Axis (if it wasn't initially present before step 1).

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


Bryan wrote:
I have some macros that build a series of charts. Some of the charts
have series with the Y axis rendered on both sides of the chart. The
right side, secondary axis, always seems to be "after" the left side,
meaning that when the chart lines are in the same area the right side
ocludes the left. How can I change the order such that the right side is
before or behind the left side?

Thank you,
Bryan