Microsoft Office Tutorials and References
In Depth Information
3. Press Esc to exit text entry mode and select the text box object.
4. Click in the Formula bar and then type an equal sign ( ).
5. Use your mouse and click the cell that you want linked.
6. Press Enter.
You can apply any type of formatting you like to the text box.
After you add a text box to a chart, you can change it to any other shape that supports
text. Select the text box and choose Drawing Tools➜Format➜Insert Shapes➜Edit
Change Shape. Then choose a new shape from the gallery.
Adding a linked picture to a chart
A chart can display a “live” picture of a range of cells. When you change a cell in the linked range,
the change appears in the linked picture. Again, the process isn’t exactly intuitive. Start by
creating a chart. Then:
1. Select the range that you want to insert into the chart.
2. Press Ctrl+C to copy the range.
3. Activate a cell (not the chart), and choose Home
Excel inserts the linked picture of the range on the worksheet’s draw layer.
4. Select the linked picture and press Ctrl+X.
5. Activate the chart and press Ctrl+V.
The linked picture is cut from the worksheet and pasted into the chart. However, the link
no longer functions.
6. Select the picture in the chart, activate the Formula bar, type an equal sign, and select
the range again .
7. Press Enter, and the picture is now linked to the range.
This section contains a variety of chart examples that you may find useful or informative.
Charting progress toward a goal
You’re probably familiar with a thermometer-type display that shows the percentage of a task
that’s completed. Creating such a display in Excel is very easy. The trick involves creating a chart
that uses a single cell (which holds a percentage value) as a data series.