Thread: 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:

Code:

ActiveChart.SeriesCollection(1).Values = "='Chart'!$C$2:$C$" & x

Where x is the last row containing data.

Thanks.

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