Even better than a bullet graph, which like the gauge shows a single value
of the variable in time, would be a line chart showing recent values of the
variable up to the current value. You can add effects to show the target and
colored zones if you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
On Thu, 7 Jun 2007, in microsoft.public.excel.charting,
Del Cotter said:
I am trying to create perfomance metric's graphs, and it seems that gauge
charts are the most common use.

A better device for doing something similar is the "bullet graph", which
is like a gauge graph, but in a straight line. The word and concept is by
Stephen Few. Try googling "stephen-few bullet" and reading some of the web
references, or ordering his books on the design of performance reports.

P.S. for an Excel implementation of bullet graphs, try googling
"charley-kyd bullet".

http://www.exceluser.com/explore/bullet.htm

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.