5 Replies Latest reply: Aug 8, 2016 12:11 PM by Sunny Talwar RSS

    Line Chart - Changing Line Style for downward trend

    Jason Duryea

      How can the Line Style of an expression be changed from Solid to Dashed only on a downward trend from the previous value?

      This chart should show dashed line from May 2016 to Jun 2016 and from Jul 2016 onward.

       

      The formula in the Line Style (red line only) is as follows:

      =If(Above(Sales) > Sales, '<S2>','<S1>')

      7-29-2016 4-15-12 PM.jpg