Microsoft Office Tutorials and References
In Depth Information
Most dashboards, however, have diverse topics. In this case, if
your one-page dashboard report displays 30 charts and tables,
your supporting workbook will contain at least 31 worksheets. It will
have at least one sheet to support each figure and one sheet to
contain the actual report.
It may seem strange for someone to recommend that you create a
workbook with many worksheets. As a general rule, workbooks with
many sheets make navigation difficult.
As a general rule, this is true. But in dashboard reports, using one
sheet per figure brings two significant benefits: clarity and flexibility,
as you will see.
In addition to the report page and the pages to support each figure,
dashboard reports typically include at least two additional
One sheet that always is included is the Control sheet.
Dashboard reports bring together a lot of content, often from many
sources. It would be virtually impossible to re-use a dashboard
report if there weren’t an easy way to control the reporting period
and other key variables. That easy way is the Control sheet.
To be clear, you try to design your dashboard report so that you
never modify any sheet but the Control sheet, unless you want to
change the structure of your report. From month to month, division
to division, department to department—whatever—you change only
the settings in your Control sheet.
To the degree you enforce this rule, dashboards are easy to
maintain. To the degree you ignore this rule, dashboards become a
nightmare to support.