link data sheet to data sheet (Office 2000/2003)

Is it possible to link the data from one chart to another (i.e. the data sheet within a chart). I know one can link an actual table to the datasheet of a chart, but I haven't found a way to do it data sheet to data sheet. Here is the scenario. I am using a third party software to export the chart to Excel, however this chart is pretty ugly and needs a lot of formatting. Thus I created a 'master file' which will be used, and I would like to use the exported file as a source file with link to the master file. The source file will be exported every month with the same name (I also have tables, which I have already linked to the masterfile, now I'm only stuck at the charts). Any ideas anyone?

Re: link data sheet to data sheet (Office 2000/200

I don't think you can link to the datasheet in an MS Graph chart. You can open the datasheet manually, and copy the data to the clipboard in order to paste it elsewhere, or you can write VBA code to read the data from the datasheet and use it elsewhere.