changing colours on chart when values below 0 on y-axis

[#1]

Hi

is there nice easy way of changing colours on the following line chart when the value drops below 0 on the y-axis, either by changing colour of line or the symbols dots?

I'll also what it applied to the columns in the bar chart when they drop below 0 as this is a Fast Type Change chart!!

if below 0 I want it to change to red etc

                                       

[MK_QSL · Accepted solution]

Check enclosed file..

[awhitfield]

You could try something like this, it actually works better on a bar chart 🙂

[awhitfield]