7 Replies Latest reply: Nov 6, 2012 2:10 AM by Anna Jernqvist RSS

    Different color on pos

      Hi

      I wonder if someone can help me. I want bars in a chart to turn red if they are negative and green if they are positive. I have added this code "=If(Sum(Avd.) < 0, RGB(193,0,43), RGB(0,128,64))" But depending if I write "<" ">" or if I write the green RGB or the red RGD first or second I only manage to get all the bars, both positive or negative, green or red. I've tried to ad two expressions but it doesn't help. Could someone help me?

      Thanks in advance.

      /A