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.
 
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/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Adding Text to a Textbox in Excell 1
Displaying content of a cell somewhere on the chart 1
Load ws cell data into a textbox via click on chart datapoint 5
link a chart source to a cell reference 3
Cell referencing on a chart 2
Control in Chart Sheet 6
Excel: using data labels as markers 4

Back
Top