View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?