is there a way to add stoplighting to a chart
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 |
is there a way to add stoplighting to a chart
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 _______ "Loretta" wrote in message ... 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 |
All times are GMT +1. The time now is 07:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com