For business users of Microsoft Excel Free guides and templates

Excel Dashboards

Sample Excel Dashboard Reports from Forbes and Business Week

These Excel dashboards, inspired by long-running displays in business magazines, illustrate more ways to format your reports.

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

This mockup is based on a format that Business Week used more than ten years ago. It uses a different color scheme, however.

My ebook, Dashboard Reporting With Excel, explains how you can create dashboards like these for your own company.

Excel dashboard report based on a Business Week display

As a general rule, pages filled with columns of numbers tend to put their readers to sleep. But this mockup, adapted from an old Forbes magazine display, is an exception.

Although this page contains many numbers, the numbers are grouped in categories that interest typical managers: top customers, our company vs the competitors, customer satisfaction, top products, numbers of employees, etc.

Notice that many columns of numbers on the left side of this display don't line up vertically. My ebook, Dashboard Reporting With Excel, explains how to use Excel's Camera tool to achieve this effect.

Excel dashboard report based on a Forbes display.

Free Excel Dashboards

Click to see testimonials from readers

Charley's SwipeFile charts

Click to see who uses Excel dashboards.