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

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