How do I copy a graph to new worksheet and get data from new sheet?

[Elmer Smurdley]

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...

 

[Jon Peltier]

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

 

[Elmer Smurdley]

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.

 

[Jon Peltier]

No. Don't copy the cells of the sheet. Copy the sheet.

Right click on the sheet tab, and follow Move or Copy to make a copy of the
sheet.

- Jon

 

[David Biddulph]

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.