View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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.