0 Replies Latest reply: Sep 29, 2017 7:46 AM by Bill Markham RSS

    Make label values nice on combo chart

    Bill Markham

      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 ?