Highlight Negative Values on Graph

[eoinymc]

Hi there,

I want to be able to highlight any values less than zero on my graph..

So, when the value goes below zero, it automatically changes color to red.

The graph I am trying to do this to is a line graph by month.

Is this possible?

Cheers,

Eoin

 

[Andrew Poulsom]

Look here:

http://www.mrexcel.com/forum/showthread.php?t=414001