Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how excel calculates the major units on an axis when MajorUnitIsAuto property set to true | Charts and Charting in Excel | |||
how excel calculates the major units on an axis when MajorUnitIsAuto property set to true | Excel Discussion (Misc queries) | |||
defining major units on chart axis | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |