Change Source Data in Chart

[Karen]

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

 

[Jon Peltier]

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]

Thank you for your help

I followed what you told me to do, but it's not working for me. I must be a
jinx! This may be a problem and I forgot to mention it in my previous
posting. All the sheets have different amounts of data. Sheet1 has 4 values
and Sheet2 has 9. So, what I did just to check it, I only copied the same
amount of values from one sheet to the next and it didn't update my Data
Label (Category Name) - Actually it has the same percentages and data labels.
Not surw what I did wrong.

Thanks again, Karen

 

[Jon Peltier]

Check out the series formula in the copied chart. Select a series and look
in the formula bar. You should see a formula like this:

=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$10,Sheet1!$B$2:$B$10,1)

If you don't see cell references, or references to a defined name, something
may have happened to the chart. For example, in Excel 2003 and earlier, if
you copy a chart or the sheet it's on, and the chart was defined with
worksheet-level names, the sheet-level names are likely to be converted into
static arrays. Workbook-level names are okay (although there is some funny
business with them in 2007).

- Jon