Microsoft Office Tutorials and References
In Depth Information
Step 3: Add the Control Sheet and the First
So far, your dashboard workbook contains only the Report sheet,
which is a mockup. Before you can add a real figure to your report,
you first need to add a data sheet and the Control sheet.
The data sheet contains the data that supports your first figure. The
Control sheet contains values and settings that apply to your entire
You’ll spend some time creating these two sheets and your first
figure, described in the next step. Once these items work correctly,
you will use these items as patterns to complete your report.
The Control Sheet
Figure 8-4 shows the Control sheet used for the dashboard.
Although these lists of items seem extensive, they are easy to
Figure 8-4. This Control sheet contains a variety of settings and values
used by the dashboard.