This content has been marked as final. Show 5 replies
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>')