Adding Text Links

You can also add a linked text box to a chart. The process is a bit tricky, however. Follow these steps exactly:

1. Select the chart and then choose Insert Text Text Box.
2. Drag the mouse inside the chart to create the text box.
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 will be linked.
6. Press Enter.

You can apply any type of formatting you like.

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 Shape => Change Shape. Then choose a new shape from the gallery.