Move Axis to Bottom of Graph

**tejvan** · 02-23-2011, 05:53 AM

I have a graph (enclosed). I just want to put the x axis (the dates) at the bottom of the graph (rather than at value 0 in the middle)

**DonkeyOte** · 02-23-2011, 05:58 AM

Please choose the appropriate forum for your question.

Thread moved from Tips & Tutorials (not Q & A Forum) to Charting.

**teylyn** · 02-23-2011, 07:31 AM

Hello,

select the X axis (Category axis), open the Format Axis dialog and set "Tick mark labels" to "Low".

This will move the X axis labels below the graph.

These instructions are for Excel 2003, which is the version you indicate in you profile as the one you are using. If you are using a different Excel version please update your profile and call back.

**tejvan** · 02-24-2011, 05:52 AM

Thanks for help. Sorry, I had wrong excel in my profile. I updated to Excel 2008 (mac)

I opened format axis dialogue but couldn't see how to set as low.

**teylyn** · 02-24-2011, 07:44 AM

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. Click the drop down for the Axis Labels and select Low.

cheers,

**tejvan** · 02-25-2011, 03:14 PM

Thanks for help.

I have trouble finding what you show on screen shot.

I have tried formatting Chart Area and have the formatting palette open. But can't see that option

**teylyn** · 02-25-2011, 10:14 PM

Hello,

the screenshot show the format dialog for the Chart Area. With that dialog open, click the X axis on your chart, and it should switch to the Format Axis dialog (at least it does so for XL for Windows).

Or, close the dialog, select the X axis and then open the format dialog.

Now you should see something like the screenshot I attached earlier.

**gistangjing** · 10-31-2011, 05:32 AM

I have the same problem, but I find it..
If you check the 'layout'-'axis'-'more horizontal properties' And then you will find the 'low' for x-axis setting.

Good luck..

Jing