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
# 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.
2 Calif ornia
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.
1 New York
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
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.