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?

set x-y crossing on graph automatically
 

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?