runtime error in odd place

[men5j2s]

This part of my macro stops at line 6 below, where it throws up a runtime error...

There is no reason why it wont work as its an exact cope of line 2, but references the next column in a spreadsheet nd is for n additional series..

any ideas?

    ActiveChart.SeriesCollection.NewSeries                                                                  
    ActiveChart.FullSeriesCollection(1).Name = "='" & Left(Device, 31) & "'!R1C9"             
    ActiveChart.FullSeriesCollection(1).XValues = "='" & Left(Device, 31) & "'!R3C8:R" & LastRow & "C8"    
    ActiveChart.FullSeriesCollection(1).Values = "='" & Left(Device, 31) & "'!R3C9:R" & LastRow & "C9"    
 
    ActiveChart.FullSeriesCollection(2).Name = "='" & Left(Device, 31) & "'!R1C10"
    ActiveChart.FullSeriesCollection(2).XValues = "='" & Left(Device, 31) & "'!R3C8:R" & LastRow & "C8"
    ActiveChart.FullSeriesCollection(2).Values = "='" & Left(Device, 31) & "'!R3C10:R" & LastRow & "C10"

 

[men5j2s]

I've just found out that when you add a 1st series to a chart and go to name it and click the button tht takes you to the data location, it defaults to the lcation of the data. when adding a second series, it does not, you must actively click on the original tab then select the cell you want.

does this mean that i need to point it to the sheet too?

how would i tell it which sheet to use? I assume it would be t the last part of the code on line 6 " ' ! R1C10"