Is there a way to copy a chart from one identically structured workbook to
another, without having to manually adjust the Series references to take out
the previous file name each time? A sort of "Paste-special-values" for
charts? I have to back fill about fifty workbooks with the same chart, and
the chart contains references to 7 different series - it's going to take me
hours!


Thanks,
Geoff.