Traffic Light Chart

setup three rules
one for each colour

for 2007, 2010 or 2013 excel version
Conditional Formatting

Highlight applicable range >>

select the range you want to colour


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=$B$5 < 46


Format… [Number, Font, Border, Fill] GREEN
choose the format you would like to apply when the condition is true
OK >> OK

REPEAT the above for the following formulas

=$B$5>=46
Yellow

=$B$5 > 60
RED

then you have to order the rules - so that the RED is at the top - using the arrows
and stop if true

i dont know how to change an image in a cell
however , you can get icon sets that would just show the 1 colour in a black frame

Hello
One way by using some pasted clip art on the data points. See the attached file example. Note, however, if you resize the chart you';ll also have to adjust the size of the light images.

Hope it gives you a few ideas.

DBY

*Note by changing the colour properties of the Traffic Light Stack to a monochrome image, you can do away with the 'Grey' series on the chart.