Dashboard

    Dashboards By Example Volume 1   From Excel Dashboards to Real-Time Dashboards, these dashboards contain KPIs, metrics, charts, trends and data visualizations. Learn the best practices of enterprise dashboard design by studying the work of your peers on business dashboard implementation teams around the world. Examine their digital dashboards and share your dashboard design tips in return.

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

Note: Dashboards By Example readers can get these interesting business intelligence dashboard white papers discussing the latest approaches to enterprise dashboards.

Want to connect with the Dashboard Spy? Visit the About The Dashboard Spy page to learn how to connect via LinkedIn.

Building an Executive Dashboard in Excel 2007 with Conditional Formatting

Latest News in Excel Dashboards: New functionality for Excel based Enterprise Dashboards.

One of the truly exciting improvements in Excel 2007 for us avid enterprise dashboard project team members is the extent of the conditional formatting of the cells. Depending on logic related to the value of the contents of the cell, you can assign colors (think heat map visualizations) or icons (think red/green visual KPI indicators).

Here are a couple of excel 2007 demo videos that give a glimpse of the new features that you will definitely be using when building an executive dashboard.

This first video has no sound so think of it as an early silent movie about business intelligence visualization! Watch the cells as the person quickly drops down the conditional formatting options.

http://video.google.com/videoplay?docid=-4115540572629796916

This next one does have sound. You may want to skip straight to the latter part on the formatting options.

http://video.google.com/videoplay?docid=-1192618361577555007

And here is a quick tour of some new Excel 2007 features. This guy blows through 5 new features in 30 seconds!

YouTube Preview Image

For reference, here is a link to some more info on Excel 2007.

Tags: Excel Dashboard, Excel Dashboards, Excel Dashboarding, Dashboards with Microsoft Excel

The Dashboard Spy Business Intelligence Dashboards Blog

Learn how to create Excel dashboards.Excel Dashboard

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

4 Responses to “Building an Executive Dashboard in Excel 2007 with Conditional Formatting”

  1. Andreas Said on

    A very useful extension for Excel dashboards is MicroCharts. It provides cell-sized charts
    * Line, column, pie and bar charts
    * Sparklines with rich formatting
    * Bullet graphs for dashboard gauges

  2. Andreas Said on

    You can download the MicroCharts Add-In here:
    http://www.MicroCharts.net

  3. Jon Peltier Said on

    The video links are broken.

  4. admin Said on

    Sorry about that Jon. They are back up now. The Dashboard Spy.

Leave a Reply




Want to see a different randomly selected business intelligence dashboard example? Click here to view another Digital Dashboard from the Dashboard Spy.

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

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