Link To A Cell From Chart

S

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.
 
J

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).
 
D

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.
 
Top