For business users of Microsoft Excel Free guides and templates

Excel Dashboard

A Repeating-Detail Dashboard to Compare Multiple Entities

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


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

As you can see from the date on this dashboard, I created it quite some time ago, like the other repeating-detail dashboard. When I did so, I designed the workbook to display data contained in an OLAP database that I no longer have available. When I get the chance, I'll update this dashboard to pull data from an Excel Table.

This dashboard has at least two unusual features:

First, I designed it to display seven companies at a time from an endless list of companies. That is, if I enter 1 in a cell (for page 1), it displays the first seven companies; if I enter 2 in the cell, it displays the next seven companies, and so on.

To see the challenge of these design, suppose there are eight total companies. When I enter 2, I see the 8th company in the first row. But I don't want to see empty charts and data areas for the other six rows. No problem. I found a way to display a blank area for the remainder of the page.

Second, notice that the Y axis uses the same values for each column of charts. This allows all seven charts on a page to be compared vertically.

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

 

Free Excel Dashboards

Click to see testimonials from readers

Charley's SwipeFile charts

Click to see who uses Excel dashboards.