0 Replies Latest reply: Oct 14, 2014 5:08 PM by Sophie Wei RSS

    how to apply multiple background color in line chart

      Hi,

       

      In my data file, there were three columns: Month, Value and Type. Type can be either 'A' or 'B',  and those two types of data need to be showed in one single continuous line. In this chart, I want to mark 'A' in one color and 'B' in a different color.

       

      the expression is    =sum({1<Type={'A','B'}, Month=  >}Value)

      and I put    =if(Type='A', red(), green()) in the background color

       

      The color does not change.

       

      Can someone please help me with that?

       

      Thanks,

      sophie