View Single Post
  #5   Report Post  
 
Posts: n/a
Default

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.