Microsoft Office Tutorials and References
In Depth Information
formula into the Go To dialog’s Reference edit box, then choose
OK. After you do so, Excel should select the range A5:C10.
Once the formula is working, assign it as a dynamic range name.
To do so, choose Insert, Name, Define. Specify the name
TopRegions and paste the OFFSET formula above, including its
equal sign, in the Refers To edit box.
To test that the TopRegions name is defined correctly, press F5,
enter TopRegions as the Reference, then choose OK. (You must
type the name because the TopRegions name won’t appear in the
list of names in the Go To dialog. This is because Excel doesn’t list
dynamic names.)
Top Regions
# e i n e
1 New York
Set up the Camera object
The final step is to set up the Camera object for use in
your dashboard. To do so, choose any cell, click on
the Camera icon, then click any cell. This will give
you the picture of a cell you don’t care about.
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
UseRows
4
Select the Camera object. In the formula bar,
replace the object’s formula with =TopRegions.
When you press Enter, the Camera object should
immediately display a figure like the top one here.
Top Regions
#
Region
Score
1 New York
193
2 California
179
3 Kansas
165
4 Alabama
161
5 Montana
157
The Camera object will have a border around it,
however. To remove the border, right click on the
object, and then adjust the setting in the Colors
and Lines tab. Depending on your dashboard
design, you also might need to set Patterns to
none.
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
To test that the Camera object is working as expected, enter the
value 3 in cell C2. When you recalculate, the Camera object returns
three rows of data, not four.
Search JabSto ::




Custom Search