View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Graphing question

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