Replace values in chart

[Amag]

I have some 20 charts in one file linked to a sheet (Sheet A). Now I
have to replicated these charts except that they now should be linked
to another sheet (Sheet B).
I dont want to individually go to each chart, right click and change
the data source. Is there a simple way to do it, something like Ctrl
H, wherein you replace all?

Thanks in advance.

Best Regards

 

[Jon Peltier]

Make a copy of the first workbook, copy the data from sheet B onto sheet A,
and the charts will now display the new data.

- Jon