S
Stratuser
I'm having trouble assigning data to a chart series, using
an array. Here is my code, which bombs on the last line,
with an error saying that it can't set the Values property
of the Series class. Both mean and onestdplus are arrays.
'Build chart
Charts.Add
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SeriesCollection.NewSeries
'Assign series values
ActiveChart.SeriesCollection(1).XValues = Range
("Dates")
ActiveChart.SeriesCollection(1).Values = Range
("Inputs")
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(2).Values = mean
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(3).Values = onestdplus
an array. Here is my code, which bombs on the last line,
with an error saying that it can't set the Values property
of the Series class. Both mean and onestdplus are arrays.
'Build chart
Charts.Add
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SeriesCollection.NewSeries
'Assign series values
ActiveChart.SeriesCollection(1).XValues = Range
("Dates")
ActiveChart.SeriesCollection(1).Values = Range
("Inputs")
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(2).Values = mean
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(3).Values = onestdplus