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