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/...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