Link To A Cell From Chart

[Salza]

Hi all.
I have a text box in a chart worksheet. Can I link it to an information from
any cell in other worksheet in the same workbook.

Thanks.

 

[Jim]

Yes. Click the text box icon, then click on the chart sheet to insert the
text box. Click in the formula bar and =Sheet1!A2 (or whatever cell you want
to link).

 

[Debra Dalgleish]

To link a cell's contents to a textbox:

1. Select the textbox on the chart sheet
2. Click in the formula bar, and type an equal sign
3. Click on the cell that you want to link
4. Press the Enter key.