defining major units on chart axis

[Nick Turner]

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

 

[Ed Ferrero]

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.aspx?scid=kb;EN-US;Q214075

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

 

[Jon Peltier]

If you read this article carefully, you'll see that they explain how
Excel determines the max and min in terms of the major unit, but they
leave out any information about how the major unit is determined. That's
where Ed's squirrel comes in.

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