VBA- SeriesCollection(1).Value error
 

What's wrong with this code:


Worksheets("sheet1").ChartObjects("Chart 1").Chart. _
SeriesCollection(1).Value = "=Sheet1!R1C1:R20C1"


It gives me run-time error '438' object doesn't support this propert
or method

--
Message posted from http://www.ExcelForum.com

VBA- SeriesCollection(1).Value error
 

"crossplatform " wrote in
message ...
What's wrong with this code:


Worksheets("sheet1").ChartObjects("Chart 1").Chart. _
SeriesCollection(1).Value = "=Sheet1!R1C1:R20C1"


It gives me run-time error '438' object doesn't support this property
or method.


---
Message posted from http://www.ExcelForum.com/


value is not a valid property of SeriesCollection. what exactly are you
trying to do; add a new series or replace an existing series or something
else?
Paul D

VBA- SeriesCollection(1).Value error
 

Worksheets("sheet1").ChartObjects("Char
1").Chart.SeriesCollection(1).Value = "=Sheet1!R1C1:R20C1"



Well, I'm trying to update the chart's series range. The followin
works perfectly:


ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Values = "=Sheet1!R1C1:R20C1"

But I dont want to activate the sheet and the chart :(
Any suggestion

--
Message posted from http://www.ExcelForum.com

VBA- SeriesCollection(1).Value error
 

have you tried using the formula property?
Paul D

"crossplatform " wrote in
message ...
Worksheets("sheet1").ChartObjects("Chart
1").Chart.SeriesCollection(1).Value = "=Sheet1!R1C1:R20C1"



Well, I'm trying to update the chart's series range. The following
works perfectly:


ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Values = "=Sheet1!R1C1:R20C1"

But I dont want to activate the sheet and the chart :(
Any suggestion?


---
Message posted from http://www.ExcelForum.com/