I have the following code that creates a chart based on a table from Range("Y2:Z" & iRow3), where iRow3 is the last row of the table (changes as new data is input):
With ActiveSheet.ChartObjects.Add(Left:=Range("C12").Left, _
Top:=Range("C12").Top, _...