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