Re: Move Axis to Bottom of Graph Excel 2008 for Mac should be similar to 2007 for Windows (which I'm not in front of right now). If you open the Format dialog, you should see something similar to the screenshot attached. How to quickly add secondary axis in Excel charts, a quick and handy way to create an attractive and informative graph.
![Axis Axis](/uploads/1/2/5/4/125462584/623082218.jpg)
Yes, you can switch them, but you'll have to temporarily introduce the secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis.
![Word Word](/uploads/1/2/5/4/125462584/144903076.gif)
Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category. Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above. Yes, you can switch them, but you'll have to temporarily introduce the secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis. Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category.
Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above. Jon - Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions. Yes, you can switch them, but you'll have to temporarily introduce the secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis.
Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category. Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above.