Change graph color when number when exceeding threshold

[cercle92]

Hi everyone,

I have a list of numbers, and I plot a graph of it.
But now I want to change the graph color when a certain number, the threshold, exceeds

Can someone help me?

Thanks in advance!

[Andy Pope]

Usual approach is to use additional series with data based on formula. Search for conditional charts.

If still stuck post example file detailing what should change and when

[adyteo]

If you upload the file, I may be able to help you with a macro to change the graph color when a threshold is reached.

[ben_hensel]

My advice is to pump your data through a dummy series and use them to run your chart.