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

    Colour coding a Block Chart

    John Wood

      Hi

       

      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"

       

      =class(aggr(avg(Price),Description),50,'Rate')

       

      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?!