How major unit is generated for Value axis?
Is there any pattern for generating?
Mithun
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.
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