Microsoft Office Tutorials and References
In Depth Information
Step 7: Set Up the Other Figures.
The dashboard report, Figure 8-1, includes three additional figures,
an Income Statement, a Balance Sheet, and a Legend.
Create the Balance Sheet
Figure 8-6 shows the
top of the data sheet
for the dashboard’s
The FigTitle cell isn’t
used, nor is the
Scale value is used
to scale the data.
Figure 8-6. The top of the worksheet that contains
the Balance Sheet. The Income Statement worksheet
uses a similar design.
The labels in column
B are the names for
the summary accounts in the data sheet. And the labels in column
F typically use the same descriptions, returned by formula. The
indents in cells E15 and E16 are set by the Indent setting in the
Alignment tab of the Format Cells dialog box.
As Chapter 7 explains, Column C contains a formula that returns
each account’s row number, and column D returns each account’s
Sign. Accounts with a natural debit balance have a sign of +1 and
accounts with a natural credit balance have a sign of -1.