Array as chart series data source
 

Is it possible to use array variable values as the source for a chart series?
I have tried to use the SetSourceData method which failed because the method
was looking for a range.

Array as chart series data source
 

Sub test()
Dim sr As Series
Dim vY, vX

vY = Array(1, 2, 3)
vX = Array("AA", "BB", "CC")

Set sr = ActiveChart.SeriesCollection.NewSeries
sr.Values = vY
sr.XValues = vX

End Sub

Also look at series.Formula

Regards,
Peter T

"Mitch" wrote in message
...
Is it possible to use array variable values as the source for a chart
series?
I have tried to use the SetSourceData method which failed because the
method
was looking for a range.