ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Graphing question (https://www.excelbanter.com/excel-discussion-misc-queries/111599-graphing-question.html)

Kim

Graphing question
 
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

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


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com