How to carry over conditional format colors to a chart

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?

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