Thread: Simple question- how to make X axis on bottom of chart

Hi, pretty self explanatory, and probably a quick fix. Basically my data in my chart varies between -5 and -15 on the y axis. As a result the X axis labels appear at the top of the chart, and not the traditional way at the bottom. I would like them to be at the bottom, and i'm sure it must be a quick fix. Any one know how to do it?

Thanks,

Joel

Right click y-axis; format
open Scale tab and set Crosses X axis at -15 (or -20 if you prefer)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Boon8888" <Boon8888.22vgob_1139337309.888@excelforum-nospam.com> wrote in
message news:Boon8888.22vgob_1139337309.888@excelforum-nospam.com...
>
> Hi, pretty self explanatory, and probably a quick fix. Basically my
> data in my chart varies between -5 and -15 on the y axis. As a result
> the X axis labels appear at the top of the chart, and not the
> traditional way at the bottom. I would like them to be at the bottom,
> and i'm sure it must be a quick fix. Any one know how to do it?
>
> Thanks,
>
> Joel
>
>
> --
> Boon8888
> ------------------------------------------------------------------------
> Boon8888's Profile:
> http://www.excelforum.com/member.php...o&userid=30647
> View this thread: http://www.excelforum.com/showthread...hreadid=509455
>

An alternative leaves the axis line and ticks at zero but moves the labels
out of the way. Right click the X axis, select Format, and on the Patterns
tab, choose the Low option for Tick Labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:OM3JIaBLGHA.1288@TK2MSFTNGP09.phx.gbl...
> Right click y-axis; format
> open Scale tab and set Crosses X axis at -15 (or -20 if you prefer)
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Boon8888" <Boon8888.22vgob_1139337309.888@excelforum-nospam.com> wrote in
> message news:Boon8888.22vgob_1139337309.888@excelforum-nospam.com...
>>
>> Hi, pretty self explanatory, and probably a quick fix. Basically my
>> data in my chart varies between -5 and -15 on the y axis. As a result
>> the X axis labels appear at the top of the chart, and not the
>> traditional way at the bottom. I would like them to be at the bottom,
>> and i'm sure it must be a quick fix. Any one know how to do it?
>>
>> Thanks,
>>
>> Joel
>>
>>
>> --
>> Boon8888
>> ------------------------------------------------------------------------
>> Boon8888's Profile:
>> http://www.excelforum.com/member.php...o&userid=30647
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=509455
>>
>
>