Jon Peltier wrote:
If you always want it to cross at the minimum, enter a number that
will
always be less than the minimum, like -100000000000. Excel won't
really
cross the axis at -100000000000 if the actual minimum on the axis is
-150.
Okay. I was afraid Excel might extend the range.
I shoulda tried it first.
An alternative, keep tha axis crossing where Excel wants to, but
double
click the Y axis, and on the Patterns tab, select Low for axis label
position, rather than Next to Axis.
Perfect! Intuitive. Thanks.
|