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 |
All times are GMT +1. The time now is 12:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com