I am trying to make labels look nicely use friendly on a combo chart.
I have set the Y-axis like this
Where the full Max expression is
= ceil (
Count( distinct Asset) * 1.1 ,
num ( '1' & repeat ( 0 , if ( len(Count( distinct Asset) ) = 1 , 1 ,len(Count( distinct Asset) ) -1 ) ) )
)
This generally works quite nicely, but when (Count( distinct Asset) ) resolves to 62 then the labels show at non uniform intervals as 0, 20 , 40 & 70.
Ideally I would like the labels at uniform intervals, as in 0, 20 , 40, 60 & 80.
Anybody got any cunning suggestions ?