1 Reply Latest reply: Jun 2, 2015 10:54 AM by John Wood RSS

    Colour coding a Block Chart

    John Wood



      I am looking at different ways to present a block chart and I'm experimenting with constant colours.


      So I have 2 dimensions   - L1 Rate Band*,

                                              L2 Description


      then an expression sum(clients)


      *I am using a class and aggr function to calc rate band in other words it is dynamic and output for a row might be  "£30<=Rate<£35"




      I would like the L1's in the same band to be the same colour. I would like to loop round the 18 colour settings for the chart using the color(x) function.


      Anyone got a slick way of doing this? Id also like to exclude having to use L1 and only L2 with the colour being the L1 but block charts do not have a sort option?!