Value Pasting a Chart

**andrewc** · 09-09-2008, 02:20 PM

Hi,

Is it possible to "value copy/paste" a chart in the same way you can tabular data? I'd prefer not to paste the chart as a picture.

Thanks

**Andy Pope** · 09-09-2008, 02:27 PM

not 100% sure what you mean.

You can copy and paste the chart but the links will not automatically update.

If you copy a worksheet with a chart object on it then the sheet references will update.

**andrewc** · 09-09-2008, 03:25 PM

Sorry for the confusion!

I want to be able to delete the SERIES reference in the chart so it is effectively a picture rather than a "live" chart that can be updated.