Microsoft Office Tutorials and References
In Depth Information
The previous figure is logically similar to the one before that. The
difference is that the briefing book contains two Camera objects in
its Print Area. The first has been rotated by 270 degrees, and the
second has not been rotated at all.
Dynamic Cameras: Variable-Length Lists
One significant benefit that the Camera tool offers is that the range
it references can be changed dynamically. This feature provides
three significant benefits for dashboard reporting. One of these is
variable-length lists.
Some management reports, including dashboards, show ranked
lists of important information: best customers, most-profitable
products, top people, etc.
Top Regions
# e i n e
1 New York
This kind of information can be a problem to
report automatically each month because the list
can be too long for the available space one
month and too short the next. A dynamic Camera
object can eliminate these problems.
193
2 Calif ornia
179
3 Kansas
165
4 Alabama
161
A
B
C
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
DataRows
5
MaxRows
4
Suppose we have room in a dashboard report
to list the top-four regions each month, based
on some score. Because the scoring is
rigorous, there’ll be months when fewer than
four regions will qualify for the list.
UseRows
4
Top Regions
#
Region
Score
1 New York
193
2 California
179
3 Kansas
165
4 Alabama
161
5 Montana
157
The top figure shows the list for the current
month, and the bottom figure shows the
worksheet that supports this list. The list, of
course, is returned by a Camera object.
5
#N/A
#N/A
5
#N/A
#N/A
5
#N/A
#N/A
5
#N/A
#N/A
5
#N/A
#N/A
Before I explain how the Camera object works, I’ll briefly describe
the supporting worksheet.
Search JabSto ::




Custom Search