Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

changing axis locations

Posted by sean on January 29, 2002 9:23 AM

hi again,

Fom eariler post I know how to switch x-axis to y and vise versa...now I have a new query....

How do I move the Y axis to the right hand side of the chart and AT THE SAME TIME have the x-axis on the top of the chart?

I did a reverse of data and it puts x axis up top but y axis remains on left.....is there a better way?

thanks

sean

Re: changing axis locations

Posted by Mark W. on January 29, 2002 12:12 PM

If I understand your request...

1. Right click the X-axis, choose Format Axis...
from the popup menu, and check the "Value (Y) axis
crosses at maximum category" box on the Scale tab.

2. Right click the Y-axis, choose Format Axis...
from the popup menu, and check the "Category (X)
axis crosses at maximum category" box on the
Scale tab.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.