syntax error, source range for chart

[ajohns52]

Hello I am trying to use a variable in a source range to create a chart. Basically if more data is added i would like my chart to adapt. I used the variable last row and I put it in the source range but I am getting a syntax error



LastRow = d_paste.Cells(d_paste.Rows.Count, "A").End(xlUp).Row

ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range("'Runtime Graphs'!$A$4:"$A$" & LastRow,'Runtime Graphs'!$D$1:"$D$" & LastRow")


Thanks in advance for the feedback

 

[RoryA]

Try:

ActiveChart.SetSourceData Source:=Union(Sheets("Runtime Graphs").Range("A4:A" & LastRow),Sheets("Runtime Graphs").Range("D4:D" & LastRow))

 

[ajohns52]

Thanks Rory! It works