3 Replies Latest reply on Sep 25, 2018 6:42 PM by Sing Yan Ang

    Differentiate Negative and Positive Values for Area Chart using Colours

    Sing Yan Ang

      Hello all!

       

      I have a series of % difference plotted against month/year and I would like to differentiate the negative and positive values using colors. I created the following calculated field:

      IF lookup([% Difference M2M Volume],0) < 0 THEN "Negative" ELSE "Postive" END and it seems to work on a bar chart.

       

      However, what I hope to find out is if this is possible on a area chart too?

       

          

      Thanks in advance!