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