set x-y crossing on graph automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

widman - 26 Oct 2006 14:24 GMT

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?

Reply to this Message

Jon Peltier - 26 Oct 2006 21:17 GMT

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
_______

> Maybe this is a better place to have posted the question.
>
[quoted text clipped - 10 lines]
>
> How can I set it so the x axis scale starts at the value selected?

Reply to this Message