Maybe this will help

http://peltiertech.com/Excel/Charts/...html#CondChart


Regards,

Peo Sjoblom

"Joe" wrote:

I need colors in a bar chart to change automatically when
a certain number (i.e., days) is acchieved. For examples
if a project has less than 100 days the bar line in the
chart is green. Once, the project goes over 100 days the
same bar turns red. Can I do this in Excel?