4 Replies Latest reply on May 15, 2018 10:49 PM by Zhouyi Zhang

    Segment line into two different colours

    Elie Rahi

      I need to segment a line in a line plot into two different colours. I need one colour to show the "actuals" and another colour to show the "forecast". I tried creating a formula to put on the Colour mark, but that hasn't worked:

       

      IF [Year] = 2018 AND [Month] >= 5 THEN "Forecast"

      ELSE "Actual"

      END

       

      I've attached a workbook