How Major unit is generated?

Aspose.Cells Product Family
1

How major unit is generated for Value axis?


Is there any pattern for generating?

Mithun
2

Hi,

Please use this formula to get the MajorUnits based on your scale and maximum value.

=(ROUND((MaxValue/Scale),0)+1)*Scale

Suppose, your MaxValue = 990 and your Scale = 200, then you will get Maximum Unit as 1200

This means, your steps will be 0, 200, 400, 600, 800, 1000 and 1200.

3

Hi,

This formula is quite helpful. But since in our development involves getting Major Unit where scale is dynamic; it becomes very diffcult to calculate Major Unit.

Do you have any other ideas for this?

Mithun