ExcelUser logo Free guides and templates
Work In Progress...After nearly ten years, I'm redesigning ExcelUser.com. This is the new design. You can learn more here. Also, if you find something wrong with the site, please tell me about the problems. And thanks for your patience.--Charley Kyd

Excel Dashboard Examples

Sample Excel Dashboard Reports

Excel may be the best product there is for dashboard reporting. These examples show why.


Charley Kyd is a Microsoft Excel MVP by Charley Kyd, MBA
Microsoft Excel MVP
The Father of Spreadsheet Dashboards

Some of these Excel dashboards were created by customers after they read my ebook, Dashboard Reporting With Excel. Some are from my dashboard templates. And others are ones I created years ago. But all of them were created in Excel, using only Excel.

Note: If you've created Excel dashboards for your own company, and you'd like share your work with others, send me your dashboard workbooks, and I'll add them to these samples.

Click on any example below to see a larger version.

Excel Dashboard Templates with Charts & Tables, Portrait Style

From IncSight DB Excel dashboard templates  From IncSight DB Excel dashboard templates

These portrait-style dashboards are from the IncSight DB Excel dashboard templates. Click the image to see larger versions.

Excel Dashboard Templates with Charts & Tables, Landscape Style

From IncSight DB Excel dashboard templates  

This landscape-style dashboard also is from the IncSight DB Excel dashboard templates. Click the image to see larger versions.

Excel Dashboards with Sales-Performance Reports

  

This is the top-left corner of a larger sales dashboard created by a reader of Dashboard Reporting With Excel. Click the image to see additional samples.

Excel Dashboards Based on Magazine Displays

 

The figure at the left is based on a display that Business Week ran for years. The right figure is based on an old Forbes display. Click the images to learn more.

Dashboard Templates with Equal-Sized Charts, Portrait Style

 

These portrait-style dashboards are from the IncSight QnE2 Excel dashboard templates. Click the image to see larger versions.

Dashboard Templates with Equal-Sized Charts, Landscape Style

This landscape-style dashboard is from the IncSight QnE2 Excel dashboard templates. Click the image to see larger versions.

Hospital Improves Outcomes with Excel Dashboard Reports

 

These Excel dashboards, created by a 'non-technical' hospital administrator, help to monitor healthcare activities and improve patient care. Click the images to learn more, and see Hospital Improves Outcomes.

Sales Force Marketing & Analytics Reports Using Excel Dashboards

 

These reports were created by a sales professional to help him manage and forecast the production of a field sales force. Click the images to learn more about the dashboards.

A Repeating-Detail Dashboard that Mostly Relies on Charts

Each row of this dashboard can show the same measures for different companies, products, divisions, and other entities. Click the image to learn more.

A Repeating-Detail Dashboard that Mostly Relies on Tables

  

Below the chart, each row of this dashboard shows the same measures for different companies. Click the image to learn more.

Excel Dashboards with Charts and Comments: IncSight Medley 1 & 2

This Excel dashboard report, IncSight Medley 101, was inspired by a report format used for several years by Business Week magazine.  FORTUNE magazine's format for their 2008 Investor's Guide inspired the design for the IncSight Medley 102 Excel dashboard.

The first dashboard was inspired by a section that Business Week ran for several years. The second by a Fortune magazine investor's guide.

Excel Dashboards with Charts and Comments: IncSight Medley 3 & 4

A format that Forbes magazine uses frequently inspired this design for the IncSight Medley 103 dashboard.  This Excel dashboard, IncSight Medley 104, uses a design that Forbes magazine uses occasionally.

Both of these dashboard reports were inspired by displays that Forbes magazine uses from time to time. Click an image to learn more.

US Economic Overview Dashboard Using Online Data

An Excel dashboard showing a US Economic Overview  

You don't need an expensive BI system to display professional-quality reports in a browser. You can publish dashboard reports like US Economic Overview for free.

Wire-Frame Excel Dashboard that Follows Edward Tufte's Advice

A wire-frame Excel dashboard report.  

Edward Tufte, the well-known visualization expert, once suggested that Kyd dashboards need less color. This report applies Tufte's suggestions. Click it to learn more.

Financial Excel Dashboards:
Dow Jones & McGraw-Hill

Excel dashboard showing the financial performance of Dow Jones & Company  Excel dashboard showing the financial performance of McGraw-Hill

These financial dashboards reflect the design of two popular business web sites when the dashboards were first created. Click on the dashboards to learn more.

Financial Excel Dashboards:
Microsoft & Starbucks

Excel dashboard showing the financial performance of Microsoft  Excel dashboard showing the financial performance of Starbucks

These two financial dashboards both were generated by the same workbook, which was linked to a database of quarterly financial data of public companies.

The Stamp-Report Dashboard Displays 110 Excel Charts Per Page

If you typically display only one or two charts per page, this report shows a different way to look at Excel charting.

If you typically display only one or two charts per page, this report shows a different way to look at Excel charting.

Financial Dashboard Report
Offers Both Tables & Charts

Excel dashboard of monthly financials, using a custom color theme  

Financial reports don't always need to be ugly and hard to read. This version provides great information on one page.

Click to see more testimonials

"Your Swipe Files have been an amazing help. Here are quotes from emails I received from my boss..."  Rondi Stearns

"We have been using IncSight QnE...It is such a great and affordable product for a nonprofit with no budget..."  Norm Frampton

Click to see more users.

Charley's SwipeFile charts


IncSight DB Excel Dashboards


IncSight Colors