Folks
A colleague has created a chart but needs to swap the X & Y axes. I know
this isn't as easy as it sounds, as I've been reading through lots of entries
in this forum. I have found Jon Peltier's fantastic little .zip file
(SwitchXYAxes.xls) however, when I try and run the "Active Chart - Switch X
Y Axes" option I get a run time error "1004 unable to gt the
MinimumScaleISAuto property of the Axis class". I'm now stuck as I know next
to nothing about VBA.

I would be really, really grateful if someone could come back with either an
answer to swapping axes, or to get Jon's little macro running.

Thanks a lot
Janet