Hi Nick Turner,

I think Excel uses a small squirrel rolling dice to determine axis limits,
but
you can look here for a better explanation...
http://support.microsoft.com/default...;EN-US;Q214075

Ed Ferrero
http://edferrero.m6.net/


Hi All

Does anybody know the formula that excel uses to create chart axis
parameters? I need to know how it defines the major unit and the maximum.
Any Ideas?

Thanks in advance

Nick