| 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 | |||
Hybrid Mode
