For business users of Microsoft Excel Free guides and templates

Dashboard History

First Excel Dashboard Report Showing Financial Data for a Public Company

Excel dashboard reports have been around a lot longer than you might think. This report of a dashboard report of a public company from 1992 offers lessons that still are relevant today.


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

The figure below shows the first Excel dashboard to display data about a public company. Although this report looks quite similar to today's reports, the old and the new reports are significantly different under the hood.

Back in 1992 I probably was using Excel 4.0. In those early versions, Excel could support only a few charts in a workbook. So to create this report back then I wrote a macro that generated each chart in a separate workbook and copied its image to the report page.

Today, of course, Excel dashboards are more powerful and much easier to use. Even so, the lesson from those early days still applies to dashboards today: Creating Excel dashboards consists of two areas of knowledge, the body and its engine. The body can look great, but the report will fail if the engine is poorly designed.

Since the early 1990s I've experimented with many ways to support Excel dashboard reporting.  Today, the reason you can generate your first dashboard report in a few hours. is that I've created a much easier and more powerful way to support each figure in the dashboard. That is, I've designed a much better engine. And no macros are needed!

This is one of the reasons that Excel users in more than half the countries in the world use my Excel dashboard products. These users include people working in banks in at least 30 countries, more than 200 universities, hundreds of hospitals and other healthcare organizations, and each company that makes up the Dow Jones Industrial Average.

An early Excel dashboard report created by Charley Kyd in 1992.

 

The First Spreadsheet Dashboard: Mini-Graph Reports in Lotus 1-2-3

The World's First Excel Dashboard Report

The First Publicly Used Excel Dashboard

 

Free Excel Dashboards

Click to see testimonials from readers

Charley's SwipeFile charts

Click to see who uses Excel dashboards.