how to switch the primary and secondary Y axis to opposite chart s

[alski_13]

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.

 

[Jon Peltier]

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

 

[alski_13]

Hi Jon,

Thanks for your reply, it reminded me of another post I read (which was
written by you also). I didn't quite understand it until I read this post and
searched for Value (Y) Axis Crosses, which is an option button in Excel 2007.
I did as you suggested, the secondary Y axis did not move on it's own, so I
then applied the solution from your other post, I temporary put in an
secondary X axis, selected Format axis for it and selected Value (Y) Axis
Crosses at maximum category. This moved the secondary Y axis to the right
side of the chart. But when I removed the secondary X axis, my secondary Y
axis bars were charted upside down! To fix this, I charted them onto my
primary Y axis then back to the secondary Y axis and they plotted right side
up again. After re-adding the secondary Y axis title, I was done and back to
my original chart.

The Value (X) Axis Crosses helped me with another issue I had, knowing how
this worked fixed it. Thanks again.

Unfortunately, I need to go through this anytime a new y-axis data item
appears after a refresh of my pivot table, I hope this is soon fixed in Excel
2007.