Microsoft Office Tutorials and References
In Depth Information
Tip 92: Linking Chart Text to Cells
Oddly, this technique doesn’t work if the cell has a name. Excel displays an error
claiming that the formula contains an error. If you must link the chart element to a named
cell, override the name with the sheet name and cell address. For example:
In addition, you can add a linked text box (or a linked shape) to a chart:
1. Select the chart.
2. Choose Insert ➜ Text ➜ Text Box. Or choose Insert ➜ Illustrations ➜ Shapes and choose a shape
that supports text.
3. Click inside the chart to add an empty text box (or shape).
4. Click the Formula bar.
5. Type an equal sign ( ).
6. Click the cell that will be linked to the object.
7. Press Enter.