is there a way to add stoplighting to a chart

[Loretta]

based on the value as compared to the goal we need to indicate on the chart
red, yellow or green similar to scorecard/kpi indicators

 

[Jon Peltier]

Andy Pope shows an actual stoplight in this example:

http://andypope.info/charts/trafficlight.htm

He also has a couple other examples:

http://andypope.info/charts/tilechart.htm
http://andypope.info/charts/spotlight.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______