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(MetricType).range("C" & dataRow).value
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