set x-y crossing on graph automatically

[widman]

Maybe this is a better place to have posted the question.

I have a graph set up where an input starts the range you want to look at. I
always want the "Y" to start at 0, and the scale nicely goes as high as
necesary for the numbers in the table (viscosity). If I want to look at the
100 degree temperature range starting at 0, the x axis works fine. but if I
choose to look at 50 and above, the "x" axis still starts with 0, leaving a
blank graph between 0 and 50 and still stopping at 100.

How can I set it so the x axis scale starts at the value selected?

 

[Jon Peltier]

Unfortunately Excel's algorithm for axis minimum nearly always gives you
zero as one endpoint. Only if the minimum and maximum differ by less than
about 1/6 of the full scale will Excel move away from zero. There's no
setting to undo this.

- Jon