The following link does two colors. Extending it to 3 should be pretty
straightforward.

http://groups-
beta.google.com/group/microsoft.public.excel.charting/browse_thread/thr
ead/124801ec8fec8ba7/f72d941a0711c714?q=conditional+chart+group:
*Excel*+author:tushar&rnum=24&hl=en#f72d941a0711c7 14

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I would like to create a chart where the color of the bar varies depending on
the point value. For example the range 0-1.99- red, 2.00 through 2.99 -
yellow, and 2.99 through 5.00 - green. Any ideas?