Jon,

For some reason I can't make this work. I copy the entire spredsheet with
embedded graphs, but it is till referencing the original sheet and not the
copy.

Helge

"Jon Peltier" wrote:

Doing this maintains the links to the data for the original chart, which is
tedious to relink if you have more than one or two charts.

I showed Brendan an easier way to chart new data without having to redefine
the chart's links.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"LADYBUG" wrote in message
...
Hi

i think you can just right clicknon the graph and then copy and paste as
normal



"Brendanluc" wrote:

I have new data in different worksheets all with the same data format. I
want to make the same graph in each worksheet using the data in that
worksheet but I was hoping not to have to recreate the graph and select
all
the data in each worksheet. Is there a way to do this as long as the
data is
in the same place in each worksheet?