This website may help you out:
http://peltiertech.com/Excel/Charts/...nalChart1.html

tj

"Jared_Hmr" wrote:

I want to use plain bar charts but I want the color to change from red to
yellow to green as the number increases. For example, if a rep made 15 calls
that day then the bar would go slightly up and it would be RED. If the rep
mad 30 calls then the bar would of course go up a little higher and it would
become YELLOW. If ther rep made 45 calls or more then the bar would of course
go up higher and become GREEN.

Is this possible? If so, how do I do it?