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?
Thanks,
K.
