Chart - conditional format

[digicat]

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

 

[Andy Pope]

Hi,

No need for VBA code. You can create conditional charts by using
additional data series. See these sites for further details.

http://peltiertech.com/Excel/Charts/ConditionalChart1.html
http://www.edferrero.com/charting.aspx

Cheers
Andy