Hi I have a block of data in a spread sheet, in lots of rows and columns
thuss
ActiveChart.SeriesCollection(1).XValues = "=sheet1!R2C2:R2C182"
ActiveChart.SeriesCollection(1).Values = "=sheet1!R3C2:R3C182"
ActiveChart.SeriesCollection(1).Name = "=sheet1!R3C1"
ActiveChart.Location Where:=xlLocationAsNewSheet

X values are row R2C2 to R2C182 (horizontal)
Y values are in row R3C2 to R3C182 ( horizontal)
Name is in cell R3C1.

I want to plot many charts with a for loop, with say a indexing variable X?
It may look something like this with X in, but the syntax is not correct..
ActiveChart.SeriesCollection(1).XValues = "=sheet1!R2C2:R2C182"
ActiveChart.SeriesCollection(1).Values = "=sheet1!XC2:XC182"
ActiveChart.SeriesCollection(1).Name = "=sheet1!XC1"
Can some on advise the correct syntax for a variable x ?

Thank you,
Peter ( HADF )