The following technique is more reliable. Assuming Sheet1 is the sheet with
data and a chart, copy Sheet1 and it will be named Sheet1 (2), then copy the
data from Sheet2 and paste it into the same cells of Sheet1 (2). Sheet1 (2)
will then contain a chart with the updated data that was pasted from Sheet2.

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

..
"Karen" wrote in message
...
Using Excel 2002

I created a pie chart on one sheet tab (Sheet1). I have 10 tabs of raw
data.
The data resides on their respective tabs. I want to use the same chart
and
format for each tab. I copied the chart from Sheet1 and pasted it to
Sheet2.
Then I right-clicked on the Sheet2 chart and changed the source data to
refelct the data on sheet2. Is this a glitch or somethin? It doesn't
update
my data labels correctly. The percentages are wrong and it keeps the same
category names from the Sheet1 chart. How can this be fixed so I don't
have
to recreate the chart each time?

Thank you, Karen