Gauge Speeding Dial Dashboard in Excel
I once read that the gauge on an Excel dashboard was like the fast food for Dashboards. The premise was they take up too much space and provided very little information. I would actually agree with this sentiment. You are showing only a small amount of information for a great deal of real estate on the one Excel dashboard page. However, when you only have a small amount of information to show and that information is important then there is no reason why they can not be added to an Excel dashboard. The following Dashboard chart tracks staff utilisation by Region, by Month (a reasonably important metric) at a consultancy. If the region changes or the month changes, the % utilisation on the gauge chart will change to reflect this. The Excel dashboard also depicts the top 10 client's sales YTD and a sales funnel for each of the regions.
For a listing of all Excel Dashboards on the Smallman.com visit this link. There are more Excel files than you will be able to view!!
The Excel attached file contains the above dashboard. It is an Excel 2003 file and will work with later versions of Excel.