change data range on chart

[wwrightchess]

I am trying to change the data range on a series of charts but I get error 1004 which usually means I am missing a command. Here is the code

Sheets("GlennICE_output").Select
lr = Cells(Rows.Count, 1).End(xlUp).Row
Workbooks(partName).Activate
With Workbooks(partName).Charts("cp_plot")
.SeriesCollection(1).XValues = "C2:C" & lr
.SeriesCollection(1).Values = "P2:P" & lr
End With
The error is on
.SeriesCollection(1).XValues = "C2:C" & lr
lr is declared long and parname is a string

 

[BSALV]

the name of the worksheet has to be in front of that address with extra characters ' and !

s=sheets("Mysheet").name '----> name of the sheet with your data (in the same workbook as the chart !)
.SeriesCollection(1).XValues = "='" & s & "'!C2:C" & lr

 

[wwrightchess]

that did it thanks a lot. One of these days I'll get the syntax down