This is just how Excel calculates the minimum and maximum scale. They have
an article about this, which explains how it calculates the min and max, but
not the major unit.

http://support.microsoft.com/?kbid=214075

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"FBI" wrote in message
...
When using the automatic scale for graphs sometimes it defaults to zero
even
when the data spread is fairly narrow - why ?