This code gives me run-time error : '438' object doesn't support thi
property or method

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

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