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/...nalChart1.html
http://www.edferrero.com/charting.aspx

Cheers
Andy

digicat wrote:
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, Microsoft MVP - Excel
http://www.andypope.info