Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text box linked to datasheet
I need to insert a datum (using a text box) linked to the datum in the datasheet. I also need that the chart datum will update automatically with a change in the source datum in the datasheet. So far I have managed to insert a datum in the chart by opening a text box in the chart and then entering =spreadsheetname!datumcell. The problem is that this will not update automatically after the workbook is saved, closed and reopened. I need a link that works like a hyperlink. The only, less satisfactory, solution which I think will work is to put sneak the datum across to the chart as a lable using j-walk label input addin. *Help will be appreciated.* -- bacs ------------------------------------------------------------------------ bacs's Profile: http://www.excelforum.com/member.php...o&userid=25955 View this thread: http://www.excelforum.com/showthread...hreadid=467218 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Chart Title or Text Box Linked to cell & sheet | Charts and Charting in Excel | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |