Graph issue: From a formula to a list of data points

[rcmii]

I have a line graph in Excel 2007 that has somehow switched from a range to a list of data points:

Was:
=SERIES("2009",,'Residential East'!$C$9:$C$61,1)

Now:
=SERIES("2009",,{0,2811.1237669166,2692.6638068342,2674.3002585324,2976.6525598132,2906.74121438209,2920.6073867898,3022.6443588596,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A},1)

A) How did this happen?
B) Is there an easy way to fix this? This has permeated all of my graphs and I have 20 graphs with a total of 60 lines among the 20 graphs....and I'd really like to avoid manually changing all of this.

Thank you in advance for your help.

RCMII

 

[rcmii]

bump