Perhaps you could use Jon Peltier's technique for conditional charts:

http://www.peltiertech.com/Excel/Cha...html#CondChart


Tim A wrote:
I have a speadsheet where I have conditinally formatted the hours of overtime
into red, yellow and green. I want to make the spreadsheet into a chart that
carries over the conditinal format colors and puts them in the chart. I have
the employees names in the X axis and the hours worked in the Y axis. Is it
possible to do this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html