It's possible. Create the chart, remove any series it contains by default,
then use this to add and populate each series from arrays of data you've
calculated:
With ActiveChart.SeriesCollection.NewSeries
.Values = MyYArray
.XValues = MyXArray
End With
Note that you are limited to how many characters it takes to represent an
array as a string of the form ={1.234567890,2.345678901,3.456789012}. You
can reduce the length of this string somewhat (see
http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html).
It's also difficult to debug the code when you're dealing with arrays you
cannot see.
Charts work better with worksheet data. It's easier and better to use
worksheet ranges as chart source data. Put the data into a hidden sheet if
necessary.
- Jon
