I don't think there's a brilliant way to do this. Here is Jon Peltier's (a chart wizard)
response to the same question:
Quote:
The easiest and least tedious way is to copy the original worksheet that
contains the chart. The copied chart thus links to the copied worksheet.
Now copy the data from the table on the second worksheet, and
paste-special-values or -formulas into the table on the copied worksheet.
|