Link a chart title or text box to a worksheet cell
You can link an existing chart title to a worksheet cell or create a new text box that is linked to a worksheet cell.
-
Click the title or, to create a new text box, click the chart area.
- In the formula bar, type an equal sign (=).
- Select the worksheet cell that contains the data or text you want shown in your chart.
You can also type the reference to the worksheet cell. Include the sheet name, followed by an exclamation point; for example:
Sheet1!F2
- Press ENTER.