Variable range for seriescollection.value

I'm setting up a chart that automatically adjusts the series based on the number of rows of data. I already have my script set up to determine the last row in the worksheet that contains data--I just can't figure out how to edit the chart.

This is the code that I've got:

Please Login or Register  to view this content.

Where x is the last row containing data.

Thanks.

so does your code not work? if it errors what does the error say?