How do I make a chart where colors change with conditional format.
Example:
if the value exceeds 5000: green line
if the value is less than 1000: red line

Preferably without macro or VBA


--
digicat
------------------------------------------------------------------------
digicat's Profile: http://www.excelforum.com/member.php...o&userid=14920
View this thread: http://www.excelforum.com/showthread...hreadid=543941