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.