Text Boxes
 

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

"Graham Parkinson" wrote in message
...
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

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