Loop - Reference Cells Correctly?

Hi folks

I've been working on trying to create a loop for adding a graph to a new worksheet for several rows of data and I've got so far with it but hit a brick wall with referencing the correct row and I can't seem to get my head around what is bound to be a simple thing.

This is my code with graph formatting etc removed:

Please Login or Register  to view this content.

I have got the name of the series(2) data referencing correctly, but I'm unsure how to code the values of this series.

Hello Janc,

If I understood well, change this part of the code :

Please Login or Register  to view this content.

Thank you so much, that works perfectly

Could you explain the logic behind this part: Cells(n, 2).Resize(1, 2) so I can understand where I'll need to make changes to include further columns in my series, and also so I can add an additional new chart on each sheet from a later column.

Your previous code was adding the info from row 5 only for the 2nd data series

Please Login or Register  to view this content.

My piece of code takes the values starting from the cells in row n column B (.cells(n,2)) and extends the range by 2 columns (.Resize(1,2))

Please Login or Register  to view this content.

The trick here is the .Resize(number of row, number of columns) function.
I'm starting from Cell(n, 2) and extends it 2 columns.
So if we are in B5, the final selection is B5:C5

Check the Help in Excel on those 2 functions : OFFSET and RESIZE. They are very useful when it's time to select range.