Hi.
Using VBA 6.3 with Excel 2003, I'm trying to change the range in a chart with 2 series:
Set WS = Worksheets("Graph_Sheet")
WS.ChartObjects(2).Activate
ActiveChart.SeriesCollection(1).XValues = "='DataSourceSheet'!R8C1:R18C1"
ActiveChart.SeriesCollection(1).Values = "='DataSourceSheet'!R8C54:R18C54"
ActiveChart.SeriesCollection(2).XValues = "='DataSourceSheet'!R8C1:R18C1" '<---Error Line
ActiveChart.SeriesCollection(2).Values = "='DataSourceSheet'!R8C53:R18C53"
But, when executing, I get this error message in the "Error Line":
Run-time error 1004 Method 'SeriesCollection of Object '_Chart' failed
What am I doing wrong? Thank you very much in advance
Bookmarks