2 Replies Latest reply: Jul 22, 2011 10:54 AM by Anne Duffy RSS

    Expressions , change Background colour based on range

      Hi guys

       

      I have  bar chart and I want the colour of the bars to change, dependant on the value.


      So on the expressions tab, in Background colour if result is Less that 45, Orange, BETWEEN 45 and 50 go Green and greater than 50 go red.

       

      I have tried the below, and it does not go red at all.

       

      Can anyone see where my issue lies?

       

      Thanks

      A

       

      if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<45, RGB(255,128,0),
      if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])>45, RGB(0,191,0),
      if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<50, RGB(0,191,0),
      if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])>50, RGB (255,0,0)))))