color coordinate data from IF results for charts
 

I want to show all data bars that are less than zero to be Red in color and
all positive data bars be Green in color.

color coordinate data from IF results for charts
 

All clearly explained by Jon at
http://peltiertech.com/Excel/Charts/...nalChart1.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ASME Help" <ASME wrote in message
...
I want to show all data bars that are less than zero to be Red in color and
all positive data bars be Green in color.