Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Copy/autofill Text from sheet to sheet if meets criteria | Excel Discussion (Misc queries) | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How do I save a data as non-unicode text in am Excell sheet? | Excel Discussion (Misc queries) | |||
HOW TO CHANGE EXISTING XL DATA SHEET TO ALL UPPERCASE TEXT | Excel Discussion (Misc queries) | |||
How do I reference data from a sheet specified by text in a cell | Excel Worksheet Functions |