Thread: X axis automatically defaults to zero

When using the automatic scale for graphs sometimes it defaults to zero even
when the data spread is fairly narrow - why ?

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" <FBI@discussions.microsoft.com> wrote in message
news:8239CCC8-26F8-4CAC-BEEF-D0EB4450F584@microsoft.com...
> When using the automatic scale for graphs sometimes it defaults to zero
> even
> when the data spread is fairly narrow - why ?