Help needed to loop a macro and create many charts through a data range

Hi there, brand new to forum and just learning VBA.

I have a table of data, over 100 entries, each needing a separate chart. I have recorded a macro which does the following

Selects my chart
changes its name
changes the row values it references
copies to cell on the sheet, 16 rows down.

I have done it in the macro for 3 repetitions but can someone guide me how to loop for 100 repetitions but also increment the chart name and reference data?

Please Login or Register  to view this content.

Thanks in advance

Hi Mehmetcik, pasting that directly into the editor returns error on line " Range("B" & 3 + (Count - 1) * 16).Paste"

to be honest, i dont know what its doing, could you comment on what the code does?

Thanks

Hi Mehmetcik,
I'm afraid I am at a loss. I have attached the data set and graph. the code still returns an error. I would be grateful if you could look at it and comment. Can you also point out where it goes wrong so that i can learn

Thank you very much