SeriesCollection object in Excel 2007 and 2003

[Guest]

I created a program that in Excel 2007 that assigns an array to a new series
SeriesCollection.XValues and SeriesCollection.Values. It then shows up on
the chart.

In Excel 2003, there are apparently limits on how long the series
information can be. Is there any fix from MS on this or a way around it that
doesn't involve referencing a data range on the worksheet? It dynamically
adds series, and I'd prefer to not have them on the worksheet. I have tried
transposing and still run into limits and get errors. I have also tried
putting the in .xvalues as array(x(1), x(2), x(3), etc.). That also ran into
problems.

Any help is much appreciated!

 

[Guest]

I have had similar difficulties and tried loading the series as a string
"={22,13,19}". You might consider using a hidden worksheet to store the
data.


Chad