How major unit is generated for Value axis?
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,