"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