Dial Meter or Odometer or Guage Charts

[datboyrib23]

Excel Wizards:

Does anyone know if there's a way to create "dynamic" charts in excel that change when the underlying data is updated? I'm trying to create a "dashboard" with dynamic charts for our Board Meetings, and have heard of Guage/Odometer charts (similar to the Odometer in a car).

I've looked everywhere online to see if I can figure it out, but I am seriously stumped. If you someone knows how, I'd be forever grateful.

Thanks for reading and any help that you can offer.

Peace,
Datboy

[royUK]

Take a look at Andy Pope's charts

[datboyrib23]

Thanks royUK. I'm not sure if that has what I'm looking for, but it is definitely a good resource for other charts I may need in the future!

[royUK]

last example on the page is a Guage Chart

[Andy Pope]

All charts update when the underlying data is changed.

Checkout these dashboard links and do not get seduced by the ineffective dials.
http://chandoo.org/wp/excel-dashboards/

[suzzy]

Check out www.spreadsheetzone.com and search for dashboards

[datboyrib23]

thanks everyone - i'll take a look.