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

    Conditional Formatting on Combo Charts



      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?




      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.