J
jersiq
I have a problem with adding series to a newly created graph in VBA
The ranges for my data need to be pulled from a variable amount of
sheets, based upon the data I am currently working with.
The array to obtain the variable values is in an array of integers
which may not be necessarily sequential.
i.e on one book I may have the integers of 1, 2, 3, 4
on another I may have 1, 2, 3, 9, 10
I am able to create the series, and chart without any problems,
however when I run my macro it gives an error of "series formula is
too long"
I checked the help, but I am not quite sure where I am going wrong
here.
below is my code, the parts that are only pertinent to making the
charts.
Set alpha_chartobj = Sheets("Alpha Face").ChartObjects.Add _
(250, 375, 75, 225)
With alpha_chartobj.Chart
.ChartType = xlLine
For Each carrier_graph In Sheets("Sheet1").Range("D2" &
carrier_array_upper)
With .SeriesCollection.NewSeries
.Values = Sheets("F" & carrier_graph).Range("B2:B" &
last_row_filtered)
.Name = "F" & carrier_graph
End With
Next
End With
The ranges for my data need to be pulled from a variable amount of
sheets, based upon the data I am currently working with.
The array to obtain the variable values is in an array of integers
which may not be necessarily sequential.
i.e on one book I may have the integers of 1, 2, 3, 4
on another I may have 1, 2, 3, 9, 10
I am able to create the series, and chart without any problems,
however when I run my macro it gives an error of "series formula is
too long"
I checked the help, but I am not quite sure where I am going wrong
here.
below is my code, the parts that are only pertinent to making the
charts.
Set alpha_chartobj = Sheets("Alpha Face").ChartObjects.Add _
(250, 375, 75, 225)
With alpha_chartobj.Chart
.ChartType = xlLine
For Each carrier_graph In Sheets("Sheet1").Range("D2" &
carrier_array_upper)
With .SeriesCollection.NewSeries
.Values = Sheets("F" & carrier_graph).Range("B2:B" &
last_row_filtered)
.Name = "F" & carrier_graph
End With
Next
End With