set x-y crossing on graph automatically

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?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"widman" > wrote in message
...
> 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?