Data Sheet to Text Box

[abs]

Using Excel 2003. Have a user who has a workbook with sheet 1 being the
datasheet and then multiple sheets behind it each containing a chart. Within
some of these worksheets, he has a textbox into which he would like
information from the datasheet to show. Can this be done and, if so, how?
Any help would be greatly appreciated.

 

[Andy Pope]

Hi,

You can link chart titles and autoshape textboxes to cells.
http://www.andypope.info/tips/tip001.htm

To add a textbox, in xl2003, you can select the chart and then just type
some text. The textbox will be automatically inserted.
You can then link it to a cell.

Cheers
Andy