I offer as further explanation. The data for the embedded charts reside on
the same sheet as the chart. As a test when I changed the location of the
original chart from the Worksheet, to a Chart Sheet, the same thing occurs
to the data series. I would expect some kind of problem moving the chart
from the worksheet because the names are at the worksheet level not the at
workbook level. But I don't know why doing a worksheet copy would have the
same results on my source data as changing the location from the worksheet
to a Chart sheet. Looking at the defined names shows that they are copied
to the new worksheet at the worksheet level correctly.


"Joel Mills" wrote in message
...
I'm using Excel 2000. And have created an application that retrieves data
from an export and creates several charts. Now that I have several users
testing it they want to be able to copy a worksheet containing a chart
into the same workbook. When they perform sheet move or copy and copy the
sheet into the same workbook the data series isn't copied correctly.
After answering yes to the message box that informs them that they names
already exist the chart is copied. Inspection of the names at the
worksheet levels proves to be correct, but the data series isn't copied as
expected. See Below: The first series from the original chart. The
second series from the copied Chart.

=SERIES(Curve!TARGETEARLY,Curve!Week_Ending,Curve! PercentEarly,1)

=SERIES("Target Early %
Complete",{38359,38390,38418,38449,38479,38510,385 40,38571,38602,38632,38663,38693,38724,38755,38783 ,38814,38844,38875,38905,38936,38967,38997,39028}, {0,0,0,0,0,0,0.00116280610622283,0.039377811179597 5,0.135734068089231,0.211814337205252,0.2944776885 09942,0.406082938316851,0.512269331828989,0.607771 349820539,0.747642205933577,0.876835785464403,0.98 0649240508246,1,1,1,1,1,1},1)

Joel Mills