passing array to a graph vba

Question

Hello,

having an array arr(0 To 11, 0 To 12), how do I pass the values of the first column to a chart (Y),

0,0:11,0?

Thanks

Answer 1

Declare a second array, populate it in a loop and use it for the chart, e.g.

    Dim arr2(0 To 11) As Double

    Dim i As Long

    For i = 0 To 11

        arr2(i) = arr(i, 0)

    Next i

    ActiveChart.SeriesCollection(1).Values = arr2

Answer 2

hello,

looking around I found this method:

yourgrapharr = Application.Index(myarr, 0, 1)

this will pass cloumn 1 in the array.

Change 1 to 2 and you'll pass the second etc