In bar chart i have added the Referance line Target & Threshold.
The Target indicate green line & Threshold indicate Red line.
Also the Blue line is Linear Trendline or expression. so i want to make
that Trendline or expresion line colored on the basis of following conditions.
IF Blue line appears in between Target & threshold then Yellow ,
IF Blue line goes above Threshold(Red Line) then Pink.
IF Blue line goes below Target (Green Line) then Green.
Consider any 1 blue line i.e. Trendline or Expression line to color.
Pls see the attached qvw file for ref.
i am a beginer ....pls suggest solution.