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 |
Assign data to chart series, using array
I found the answer: There is a bug in Excel, described in
an article on the Microsoft website: Microsoft Knowledge Base Article - 213653. -----Original Message----- 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 . |
All times are GMT +1. The time now is 03:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com