Part III: Creating Charts and Other Visualizations
FIGURE 23.22
Using linked pictures to enhance visualizations
The Excel Camera tool provides an easier way to create a linked picture. Unfortunately, it’s not on the Ribbon inter-
face, so it’s not that easy to find. If you use this feature frequently, you can save some time by adding the Excel
Camera tool to your Quick Access toolbar as follows:
- Right-click the Quick Access toolbar, and choose Customize Quick Access Toolbar from the shortcut menu
that appears. The Excel Options dialog box appears, with the Quick Access Toolbar tab selected.
- Select Command Not in the Ribbon from the drop-down list on the left.
- Select Camera from the list and click Add.
- Click OK to close the Excel Options dialog box.
After you add the Camera tool to your Quick Access toolbar, you can select a range of cells and click the Camera tool to
take a “picture” of the range. Then click in the worksheet, and Excel places a live picture of the selected range on the
worksheet’s draw layer. If you make changes to the original ranges, the changes are shown in the picture of the range.
