Don't highlight the sheet, copy the contents, and paste onto a blank sheet.
Instead, select the sheet and then either right-click on the sheet's tab to
select Move or Copy, or use the Edit menu to go to Move or Copy Sheet. Tell
it where you want the new sheet & ensure that you've selected to create a
copy.
--
David Biddulph

"Elmer Smurdley" wrote in message
...
Nope. I highlight the worksheet and copy to a blank worksheet. The
graph copies but the source data for the sheet in the new sheet still
points to the original sheet.

On Tue, 11 Sep 2007 14:56:44 -0400, "Jon Peltier"
wrote:

If the chart is embedded in the worksheet, you should be able to copy the
worksheet elsewhere, and the copied chart will point to the data on the
copied sheet. Replace this sheet's data with the new set of data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Elmer Smurdley" wrote in
message
. ..
When I copy a worksheet with a graph or just copy a graph and paste in
a new worksheet, the source data is still linked to the original
worksheet.

I've tried editing the sorce data to remove the sheet name to try to
make it relative to the current sheet, but that gives me "Error in
your formula".

Is there a quick way to get the graph to link to the data in the new
worksheet? Even a macro would help, if that's what it takes.

Thanx in advance...