Chart question

[chall]

I created a pivot chart in Excel 2007 and all was fine. Then when I copied the chart sheet and data sheet to another workbook, the chart displayed all nulls as zeros and the line chart looked awful. I discovered that the data for the chart series changed from a RANGE to an ARRAY, and that was the problem. See below. How do I stop this from happening when I copy the sheets to another workbook? Thanks!​

This:

=SERIES('MyChart'!$B$3:$B$4,'MyChart'!$A$5:$A$53,'MyChart'!$B$5:$B$53,1)​

changed to this:​

=SERIES("Values",{"1976","1977","1978","1979","1980","1981","1982","1983","1984","1985",
"1986","1987","1988","1989","1990","1991","1992","1993","1994","1995",
"1996","1997","1998","1999","2000","2001","2002","2003","2004","2005",
"2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",
"2016","2017","2018","2019","2020","2021","2022","2023","2024"},{12.18207,14.0286909999999,17.067354,20.7676019999999,
18.1367599999999,20.598585,18.9667939999999,21.376525,
20.614698,18.044191,17.7139869999999,17.428775,
19.3001609999999,19.397559,20.477668,20.4001459999999,
24.833492,28.9847179999999,35.468951,37.794598,33.202107,
40.561674,41.098448,39.55822,40.3784849999999,36.565224,
37.240596,37.163469,39.3347469999999,40.665137,39.79508,
37.545343,32.345186,28.2096139999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0},1)​