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

[mathewrg]

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

 

[Jon Peltier]

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

 

[kiki-1994]

Hi , Mathew
Recently, our project also needs to study the algorithm excel uses to calculate the Major Units and I found you have asked this question
, so do you have any research results in the end?
Can you share the algorithm with me?
Thanks!
kiki

 

[kiki-1994]

Hi , Mathew
Recently, our project also needs to study the algorithm excel uses to calculate the Major Units and I found you have asked this question
, so do you have any research results in the end?
Can you share the algorithm with me?
Thanks!
kiki