The min and max are fairly well characterized in terms of the major tick
spacing:

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

I have found no published information about how Excel determines the major
tick spacing.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"M Chin" <M wrote in message
...
Where may I find the formula used by Excel in deterining the interval for
y-axis when converting data to chart