Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
conditional color fill of bar graphs
I would like to set the color of individual bars on a bar graph based on the
value of the cell on the corresponding excel 2007 spreadsheet. I want to use traffic light colors - red, yellow and green depending on the numeric value in the cell it is tied to. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
conditional color fill of bar graphs
Jon has very useful instructions at
http://peltiertech.com/Excel/Charts/...nalChart1.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jwats" wrote in message ... I would like to set the color of individual bars on a bar graph based on the value of the cell on the corresponding excel 2007 spreadsheet. I want to use traffic light colors - red, yellow and green depending on the numeric value in the cell it is tied to. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill autoshape color with ref cell conditional formatting | Excel Worksheet Functions | |||
Conditional color fill | Excel Discussion (Misc queries) | |||
Conditional color fill | Excel Discussion (Misc queries) | |||
Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
Conditional color fill whole line... | Excel Worksheet Functions |