8 Replies Latest reply: Feb 17, 2015 12:26 AM by jagan mohan rao appala RSS

    Using the If Statement in the colour expression

    James Kerrigan

      Hi guys,

       

      I'm trying to change the colour of the data points in a scatter graph where those between 80-95% and 105-120% are blue, those between 95-105% are green, and the rest are red.

       

      So far I have:

      if(value > 0.8 and value < 1.2, green(), red())

       

      But I have no idea how to add in a third colour.

       

      Hope you guys can help!