Jon has very useful instructions at
http://peltiertech.com/Excel/Charts/...nalChart1.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"jwats" wrote in message
...
I would like to set the color of individual bars on a bar graph based on
the
value of the cell on the corresponding excel 2007 spreadsheet. I want to
use
traffic light colors - red, yellow and green depending on the numeric
value
in the cell it is tied to.