Microsoft Office Tutorials and References
In Depth Information
Using Excel’s Camera Tool
Figure 4-34: Your symbols are now part of your number formatting.
Because charts automatically adopt number formatting, a chart created from this data will show the
symbols as part of the labels. Simply use this data as the source for the chart.
This is just one way to use symbols in your reporting. Using this basic technique, you can use inserted
symbols to add visual appeal to tables, pivot tables, formulas, or other objects you can think of.
Using Excel’s Camera Tool
Excel’s Camera tool enables you to take a live picture of a range of cells that updates dynamically
while the data in that range updates. If you haven’t heard of this tool, don’t feel too badly. Microsoft
has hidden this nifty tool in the last few versions of Excel by not including it on the Ribbon. However,
it’s actually quite useful for those of us building dashboards and reports.
Finding the Camera tool
Before you can use the Camera tool, you have to find it and add it to your Quick Access toolbar.
The Quick Access toolbar is a customizable toolbar on which you can store frequently
used commands so that they’re always accessible with just one click. You can add
commands to the Quick Access toolbar by dragging them directly from the Ribbon or by
going through the Customize menu.
Tip
Follow these steps to add the Camera tool to the Quick Access toolbar:
1. Click the File tab and then click the Options button.
The Excel Options dialog box opens.
2. Click the Quick Access Toolbar button.
3. In the Choose Commands From drop-down menu, select Commands Not in the Ribbon.
4. Scroll down the alphabetical list of commands (see Figure 4-35) and find Camera;
doubleclick to add it to the Quick Access toolbar.
5. Click OK.
Search JabSto ::




Custom Search