How to carry over conditional format colors to a chart

[Guest]

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]

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

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