View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stratuser[_2_] Stratuser[_2_] is offline
external usenet poster
 
Posts: 4
Default Assign data to chart series, using array

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