Update: If you need a fast, low-cost path to Microsoft Excel dashboards, consider using ready-to-go Excel Dashboard Templates from ExcelUser. They are plug and play, pure Excel worksheets. Just point them to your data source. They look great and are inspired by magazine-style dashboards.
Microsoft Excel is very popular for quick business dashboards. The best way to create one for yourself is to find a sample and customize it for your own business. If you don’t want the typical green/red/yellow cells and want it to look a little slicker, we have some nice examples for you to download and study.
Dashboards speak an international language, right? In that case, you’ll have lots of fun figuring out these italian excel-based dashboards. Take a look at these MS Excel dashboard screenshots. The first shows the portlet-style presentation of the dashboard KPIs. The second shows the regular input view of the excel spreadsheet. Here is a link to a generic xls file. This link is to the production kpi dashboard and this link is the one to the marketing KPI version. Have fun with these excel dashboards.
Also, as a Dashboard Spy reader points out: “If you take the time to look over the dashboard, there’s some pretty cool things – unprotect the sheet with the charts and look how they did the gauge – It’s a pie chart with fancy formatting. It also fits very nicely on a single screen when you view it full-screen. In all, a very good job considering the tool used.”
Update: This just in from the Italian Dashboard team!:
I have seen some nice traffic coming from dashboardspy, so we translated the Italian page into english. There could be some errors (sorry for this!), but please have a look at the page: www.excelling.it/excel/dashboard_en.asp
I will keep you posted on updates, but you can count on the fact that there will be a lot of new cool excel dashboards. I you have suggestion, please tell us 🙂
President & Founding Partner
Tags: Excel Dashboarding, Sample Dashboard Download
Homework: If you need to review graphing using excel, check out these books on excel charts .
PS: If you find yourself part of an enterprise dashboard effort, you must study Enterprise Dashboards: Design and Best Practices for IT, the only book on actually implementing enterprise dashboards.
So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books listed on this site.