Add TextBox with the content of a cell?

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
 
D

Debra Dalgleish

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

Jon Peltier

This part isn't really necessary:

"Click in the Formula bar"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Top