how excel calculates the major units on an axis when MajorUnitIsAuto property set to true
 

I need to know, how excel calculates the major units on an axis when
MajorUnitIsAuto property set to true.
We are porting an existing excel chart application to .net with help
of a third party tool for charting.
If MajorUnitIsAuto property set to true, excel automatically
calculates the major unit.Need to know what algorithm excel uses to
calculate the Major Units.

Thanks in advance,
Mathew

how excel calculates the major units on an axis when MajorUnitIsAuto property set to true
 

Microsoft has posted an article which tells how the minimum and maximum
scale values are determined, in terms of this mysterious major unit, but I
have seen nothing about how this major unit is calculated. The article only
says:

"The major unit used by the y-axis is automatically determined by Microsoft
Excel, based on all of the data included in the chart. The following
scenarios use this default major unit."

The article is at http://support.microsoft.com/kb/214075

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


wrote in message
ups.com...
I need to know, how excel calculates the major units on an axis when
MajorUnitIsAuto property set to true.
We are porting an existing excel chart application to .net with help
of a third party tool for charting.
If MajorUnitIsAuto property set to true, excel automatically
calculates the major unit.Need to know what algorithm excel uses to
calculate the Major Units.

Thanks in advance,
Mathew