Hi,
Double click the series that is currently on the secondary (right) axis
and set it back to the primary axis.
The double click the other series and set it to the secondary axis.
You must have at least 1 series on the primary axis.
Cheers
Andy
Kim wrote:
Hi there,
I have a graph with two sets of data on two axis.
Can anyone tell me how you swap the axis scales from the left to the
right and right to the left?
What I mean is that I have dollars on the left X verticle axis and
quantity on the right X verticle axis and I just want the quantity axis
on the left and dollars on the right.
Any help would be greatly appreciated.
Thanks
Kim
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info