software

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: www.excelforum.com/member.php...oamp;userid=30647
View this thread: www.excelforum.com/showthread...hreadid=509455Right 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

quot;Boon8888quot; gt; wrote in
message ...
gt;
gt; Hi, pretty self explanatory, and probably a quick fix. Basically my
gt; data in my chart varies between -5 and -15 on the y axis. As a result
gt; the X axis labels appear at the top of the chart, and not the
gt; traditional way at the bottom. I would like them to be at the bottom,
gt; and i'm sure it must be a quick fix. Any one know how to do it?
gt;
gt; Thanks,
gt;
gt; Joel
gt;
gt;
gt; --
gt; Boon8888
gt; ------------------------------------------------------------------------
gt; Boon8888's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30647
gt; View this thread: www.excelforum.com/showthread...hreadid=509455
gt;
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
PeltierTech.com/
_______

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