Here's a good example of using a chart to create a guage of sorts:

http://www.andypope.info/charts/gauge.htm

There are others out there that look more like progress bars, etc. Just
Google something like "+excel +gauges +vba" and you'll find some good
examples.

HTH,

Eric