A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

is there a way to add stoplighting to a chart



 
 
Thread Tools Display Modes
  #1  
Old March 7th, 2006, 12:56 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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
  #2  
Old March 7th, 2006, 02:08 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
pasting chart shows chart area, not the chart Pirjo Powerpoint 3 October 13th, 2005 04:31 AM
how to add animation to a chart - make lines appear David Leonard Powerpoint 11 June 2nd, 2005 12:33 AM
Urgent Chart Questions Brent E General Discussion 0 May 9th, 2005 11:01 PM
Scrollbar on Chart Jumps to Left when Chart is Clicked Bob Charts and Charting 5 May 1st, 2005 02:06 AM
build chart template; then add series one by one L Mehl Charts and Charting 2 February 12th, 2004 10:53 PM


All times are GMT +1. The time now is 07:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.