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?