Text Boxes

  • Thread starter Thread starter Graham Parkinson
  • Start date Start date
G

Graham Parkinson

I have a number of text boxes within charts that
highlight some of the information. I change the data that
produces the charts and would like to automatically
change the text in the text box by linking the text box
to cells within a worksheet. Is this possible to do?

Thanks

Graham
 
Hi Graham

you can link a text box to a cell,
1) click on the text box
2) click in the formula bar
3) type
=A1
(or whatever cell)
4) press enter

Cheers
JulieD
 
1) click on the text box

Unless you click exactly on the border, this'll put you in the box. If you
have a crappy mouse (or DTs? <g>), hover anywhere over the box, then hold
down CTRL & click.

Rgds,
Andy
 
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

Autopublishing creates a bitmap of charts and text boxes 3
Can a text box use a formula or cell reference 3
Printing alignment 2
How do I fill a text box with colour? 2
Print Area to include text box 10
Text box link doesn't update 7
Excel Move or Copy Stopped Working? 0
Chart title text linked from a cell? Possible? 2

Back
Top