Dial Meter or Odometer or Guage Charts
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
Take a look at Andy Pope's charts
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
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!
last example on the page is a Guage Chart
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
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/
Check out www.spreadsheetzone.com and search for dashboards
thanks everyone - i'll take a look.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks