2 Replies Latest reply: Sep 18, 2012 12:07 PM by Rebecca Molstad RSS

    Conditionally colouring Bars in a Chart/Reference Lines

      Hello.

       

      I have a bar chart detailing sales for my companies.

       

      I want to display a reference line with the mean of the sales for that company. (Avg(Amount)). I also want to display 2 more lines showing +/- vThreshold%. So far I think I have implemented these.

       

      I now I want to colour the bars on the chart which do not fit within the specified threshold. So if the average is 50 and the theshold is 10%, a value of 60 or 40 will be red, and blue otherwise

       

      It makes much more sense in the attached file. Im sure theres some set thing im missing in my Background Color expression. Help!