Microsoft Office Tutorials and References
In Depth Information
All labels with a white background in column A are names of cells
assigned to adjacent cells in column B. To name the bottom
section, for example, select the range A8:B18 and choose Insert,
Name, Create. In the Create Names dialog, ensure that only Left
Column is checked, and then choose OK.
Control Constants . I use this section to specify constants that
could change, but seldom do. In addition to Currency, I’ll often
include the name of the company, or the names of managers
whose names appear in reports designed especially for them.
Variables . This section contains values that you can change to
specify the information you want to report. Cell B5 contains a date
Reserved Names . The data sheets use a variety of names that
are local to each worksheet, rather than global. This list contains
the global version of each such name. By defining the global names
here, we help to ensure that we won’t accidentally assign a global
name to one of the data sheets, which could cause the Report
sheet to display the wrong data in a figure.
When you start a new dashboard, this list will be empty. As you add
names to your data sheets, you define their names in this list before
you define their names in a data sheet.
Scale Factor . The dashboard charts don’t have enough room to
display large numbers with all their zeros. Instead, we need to
display a value like $12,345,678.90 as 12.3, and then provide a unit
of measure of Millions of $ . As you’ll see, this table provides tools to
help achieve this goal.
To define the range names for this section, select D2:F7; choose
Insert, Names, Create; ensure that only Top Row is checked; then