This thread depresses me.

I have a file which has 100+ sheets in it, with each sheet named after a
date and filled with all sorts of data. A new chart per sheet has been
requested and it would be great to be able to remove the sheet name and have
the source data be relative and just copy and paste the chart 100+ times
across the sheets.

It seems I'm going to have to actually create a chart 100+ times, which
stinks.

"Excelfool" wrote:

I want to paste an Excel chart from worksheet 1 to worksheet 2 and for the
newly pasted chart in sheet 2 to reference the sourse data as worksheet 2 not
its original data from sheet 1.