VBA - reference to a chart

[yusoon]

dear community:
Everytime I update the chart data range, I have to Select i
first:

ActiveSheet.ChartObjects("Chart 1").Select

ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R35C13:R" & iROWS
"C13"
ActiveChart.SeriesCollection(1).Values = "=Sheet1!R35C19:R" & iROWS
"C19"

ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R35C13:R" & iROWS
"C13"

ActiveChart.SeriesCollection(2).Values = "=Sheet1!R35C20:R" & iROWS
"C20"


I tried this but not working:

Sheet("Sheet1").ChartObjects("Chart 1").SeriesCollection(1).XValues
"=Sheet1!R35C13:R" & iROWS & "C13"


Thanks

 

[yusoon]

Sorry i mean:

Sheet("Sheet1").ChartObjects("Chart 1").SeriesCollection(1).XValues
"=Sheet1!R35C13:R" & iROWS & "C13"

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 metho

 

[Jon Peltier]

Worksheets("sheet1").ChartObjects("Chart 1").Chart. _

SeriesCollection(1).Value = "=Sheet1!R1C1:R20C1"

Change ".Value" to ".Values".

- Jon

 

[crossplatform]

Oh, thanks.

*> Worksheets("sheet1").ChartObjects("Chart 1").Chart. _

Change ".Value" to ".Values".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______