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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Amag" wrote in message
...
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