Microsoft Office Tutorials and References
In Depth Information
Figure 17-2: A chart after being converted to a picture (and then edited).
Creating Links to Cells
You can add cell links to various elements of a chart. Adding cell links can make your charts more dynamic.
You can set dynamic links for chart titles, data labels, and axis labels. In addition, you can insert a text box that
links to a cell.
Adding a chart title link
The chart title is normally not linked to a cell. In other words, it contains static text that changes only when you
edit the title manually. You can, however, create a link so that a title refers to a worksheet cell.
Here's how to create a linked title:
1. Select the title in the chart.
2. Activate the Formula bar and type an equal sign ( = ).
3. Click the cell that contains the title text.
4. Press Enter.