I’m working with Excel 2010 to plot, on an existing chart, n distinct XY curves , in one shot (1=<n<=100,each curve about 10-100 points) .
To do this, I’m using a single SeriesCollection (because easy to manage,with a unique format for all the n curves, and above all, erasable all at once when no longer needed),whose source is a vertical range on two columns, as the red lines in the attached spreadsheet.
My question is: it is possible to feed the same SeriesCollection via software, without dumping the data on a range?
I have tried various kind of arrays, and/or recursive calls of subroutines, but without success.
I obtain even a SeriesCollection that gives a single curve instead of a set of distinct curves(see VBA macro in the spreadsheet).
Thanks for any help.forum.ozgrid.com/index.php?attachment/51215/