All,
I am trying to take an array and use this to add a data series to a chart that is already created my code below:
Dim arr(ArrayLength - 1) As Integer
Dim j As Integer
For j = 1 To ArrayLength
arr(j - 1) = WorksheetName.worksheets(M
etricType)
.range("C"
& dataRow).value
Next
chartWorkbook.SeriesCollec
tion.Add(s
ource:=
I am not sure how to set the series source to the array.. how do I do this???
or for simple code:
Dim arr(2) As Integer
arr={1,1}
chartWorkbook.SeriesCollec
tion.Add(s
ource:=
THANKS!!!
Start Free Trial