Horizontal axis in middle of chart

S

steve

Hi, I have a line graph where the vertical axis goes from -15 to 30.
The horizontal labels then appear in the middle of the chart where the
zero line is, how can I get the labels to be below the chart on the
-15 line? I am using excel 2007.

Thank You
Stephen
 
E

Earl Kiosterud

Steve,

This answer for Excel 2002, but I doubt it's changed in 2007.

First right-click the Y axis, most easily done by right-clicking one of its
labels. Select Format Axis. In the "Category axis crosses axis at" box put
a very negative number, more negative than any you'd ever expect.
 
Top