Data Sheet to Text Box
 

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.

Data Sheet to Text Box
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"abs" wrote in message
...
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.