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