Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format problem | Excel Discussion (Misc queries) | |||
Conditional Format Titles | Excel Discussion (Misc queries) | |||
conditional format | Excel Worksheet Functions | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |