I need som help linking charts in Excel.
e.g. 'Workbook A' has the data and several charts, I would like only the charts to link to a new workbook, 'Workbook B'. So when the data is changed in 'Workbook A' the charts will be updated in 'Workbook B'. Can this be done? Also is there any way to put these charts on the web and have them automatically updated?
Thanks for the help.