Defining graph series using VBA

I have code that creates a graph from dynamic data. To do this I’m using a pre-created graph in a workbook that uses series in another worksheet in the same workbook. To change the graph – I just put new data in the worksheet cells that house the series data. The code works fine.

This is a data sample
junk1.png

The challenge is I don’t know how to change the series through VBA so I’ve manually plugged in an end row value of $30.
Junk2.jpg

This creates a bunch of blanks in the graph when the data is less than 30 rows long.
How can I set the correct series length with VBA code in the code below?

Please Login or Register  to view this content.

I solved this with the following:

Please Login or Register  to view this content.