Format the primary category (X) axis, and uncheck Value (Y) Axis Crosses at
Maximum. This moves the primary value axis to the left, and the secondary
should then be smart enough to move to the right of the chart.

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


"alski_13" wrote in message
...
Using Excel 2007, evertyime I refresh pivot table data, my charts lose
almost
all of the formatting (ex. axis will disappear and chart type will revert
from lines to columns).
Most annoying problem I have when this happens is the primary Y axis moves
from the left side to the right side of the chart, and when I re-introduce
the secondary Y axis, it will appear on the left. How can I easily move
the
primary Y axis back to the left side of the chart or switch the two axes?
I've tried choosing Layout - Axes to hide and re-display the axes but this
did not work.