Dashboards by Example
    Business dashboard users, data visualization experts, IT teams, & executive management - Welcome to Volume 1 of Dashboards By Example!   Please send in your dashboards!

For more Business Intelligence Dashboard Examples, use this link to the Dashboard Spy sitemap: Dashboard

« Analysis Dashboard for the State of the Union Address
iDash PowerPoint Template for Dashboard Style Presentations »

A Look at Building Dashboards in Excel

Update: If you need a quick path to Microsoft Excel dashboards, consider these Excel Dashboard Templates from ExcelUser. They are plug and play, pure Excel worksheets. Just point them to your data source.

It’s not often that you get to look over the shoulder of a talented information visualization expert while he builds an Excel spreadsheet. Jorge Camoes’ post entitled How to Create a Dashboard in Excel allows us to do exactly that.

As Mr. Camoes wrote to me:

Just wanted to tell you about a dashboard I posted in my blog, the “Demographic Dashboard”. It is a fully functional Excel 2003 dashboard that uses population data from the US Census Bureau to show growth and age structures for each country around the world.

With this dashboard I wanted to show that an average Excel user can design a dashboard that fits the needs of his small/non-profit organization for data monitoring. I also tried to follow some visualization best practices (no gauges, no speedometers…).

Hope you can find it interesting.

Take a quick look at this Excel dashboard and you’ll agree that “interesting” is an understatement:

excel dashboard demo

There is even an screen capture tutorial on how to use this demographic dashboard. The animation effects that show data trends projected into future years are particularly interesting.

excel demographic dashboard

Be sure to download the Excel dashboard itself. Go to the Excel Demographics Dashboard Download page and check out the different options.

Tags: Excel Dashboard, Excel Download, Dashboard Demo, Excel 2003 Dashboards, Demographics, Data Visualization

Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.  


What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.  

Leave a Reply




Last Modified: Thursday, May 22nd, 2008 @ 14:25

This business intelligence dashboard blog entry was posted on Monday, September 17th, 2007 at 1:07 pm and is filed under Dashboard Screenshots. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:

Learn how to create Excel dashboards.

Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?