Need Macro to create 70 scatter plots, same exact format, different data

I am analyzing a list of sales data, need to create a macro for creating the scatter plot for each product. There is about 70 different scatter plots i need to make. They are basic, only contain 8 data points in each one. I know how to record the macro to create the first one, but i need it to move down one row of data each time it is clicked and create a scatter plot from that next row of data, rather than create the same scatter plot every time i click it.

This is my current code:

Please Login or Register  to view this content.

I am sure there is a way to do this, but i have not had any luck on youtube or other forums yet.

HELP!
Thank you!

We're going to need a sample file with about 5 series.

There is about 70 different scatter plots i need to make.

Do you wan to create them all at once? If only a single, do you want it to be in the same cell location each time? If you only need a quick look, how about a userform with the chart image? How do you want to activate the macro? Command button on page? Do you want to be able to pick a series from a list? We could go back to the userform idea and create a combobox with all the series and have the chart image appear in the userform.

Please post your Excel version. Better yet, go to your user profile and put it in there.