Add TextBox with the content of a cell?

  • Thread starter Thread starter Zurn
  • Start date Start date
Z

Zurn

I'm having problems on how to automatically add a text box to
chart...containing the text of a cell from an other sheet.

Even when I put the textbox allready on the chart, I cannot put th
text from say sheet1 cell A1 in that textbox.

Does somebody have an answer to my problem?

Thx

Zur
 
Select the chart
Click in the Formula bar, and type an equal sign
Select the sheet that you want to reference
Click on the cell that you want to reference
Press the Enter key to complete the formula.
Point to the border of the text box that was created, and drag it to the
top of the chart.
Format it with the buttons on the formatting toolbar.
 
Back
Top