AJP Excel Information

Charts
 
 

Traffic light chart

Traffic light chart
 
A very specialized conditional chart which uses a traffic light to illustrate the relationship between 3 value bands and an actual value. The download illustrates how the conditional formulas are constructed and used within the chart. It also contains a step by step guide to creating this chart. 
 
Alternative links
Visual Traffic Lights - Conditional formatting
   

Last updated 5th July 2008

 		  
  Home | Charts | VBA Code | Fun Stuff
Newsgroups | Tips | Links | What's New | Book List
Contact | About
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2008 Andy Pope