As you have discovered the SERIES formula has a finite length limit.

See this page on ways to reduce the length of the array of values.
http://peltiertech.com/Excel/ChartsH...ChartData.html

You will save yourself a lot of heartache if you just use a worksheet to store the values. Hide the worksheet if you don't want the user to see it.