5 Replies Latest reply: Mar 15, 2016 11:46 AM by Thomas Rogers RSS

    Conditional Formatting on Combo Charts

    Thomas Rogers

      Hi,

       

      I currently have a combo chart that measures the sales against the target for each year (with year going along the x axis, volume along the y axis, and both sales and targets have individual bars). When I go to change the colour, I have three options: Single Colored, Multicolored and By Expression. What I want, is the Multicolored option, but with more control over the colours of the bars.

       

      I tried the following expression:

       

      IF ( Type = SUM (Target), RGB (255, 0, 0),  RGB (0, 0, 255) )

       

      However this tells me that 'Type' is a Bad Field Name, and so the formula doesn't work. Does anyone have any suggestions on how to write this particular bit of code?

       

      Thanks.

       

      EDIT: I've attached an example of the table that I've currently got. I basically need to be able to change the colour of the Target and Sales bars independently.