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" <[email protected]> wrote in
message news:[email protected]...
>
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
> message news:[email protected]...
>>
>> 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
>>
>
>