Microsoft Office Tutorials and References
In Depth Information
Tip 92: Linking Chart Text to Cells
Linking Chart Text to Cells
When you create a chart, you may want to have some of the chart’s text elements linked to cells. That
way, when you change the text in the cell, the corresponding chart element is updated. You can even
link chart text elements to cells that contain a formula. For example, you might link the chart title to a
cell that contains a formula that returns the current date.
You can create a link to a cell for the chart title, the axis titles, and individual data labels.
1. Select the chart element that will contain the cell link.
2. Click the Formula bar.
3. Type an equal sign ( ).
4. Click the cell that will be linked to the chart element.
5. Press Enter.
Figure 92-1 shows a chart title being linked to cell A1.
Figure 92-1: Adding a cell link to a chart title.