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!