G Guest Mar 7, 2006 #1 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
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
J Jon Peltier Mar 7, 2006 #2 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 _______
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 _______
