Macros to build charts from Excel.

Hi everyone, I have a problem. Basically I have to work on an Excel sheet with many values. I have to create 8 scatter charts with 8 different data sets inside. The ranges that I have to use are equally spaced in every series of data and in every scatter plot that I have to create so I had thought of using a macro with for loops that would allow me to automate this procedure. Unfortunately, having never worked with macros, I can't build it. I attach a txt (Macro) with the macro that I recorded, as you can see each series of data is made up of 7 values ​​(example range from 2 to 9 then from 10 to 17 and so on up to 58-65) the one relating to the attachment is only the first of the 8 graphics that I have to build. The second scatter plot will consist of the same data series number as the first with the same names only that the ranges will be out of phase by 64 for example if in the first chart the ranges of the first data series is 2-9 in the second chart it will be 66 -73, the second series 74-81 and so on for the other series of this second graph up to 122-129. This procedure, as I said, must be automated for 8 different graphs each consisting of 8 data series, the data series of each graph have a step of 7 and from one graph to another of 64 up to the last series of the eighth chart whose range will be 506-513. I hope I was clear, for a person who has practice in these things I don't think it's something very complicated but unfortunately I can't. If someone could help me I would be infinitely grateful because it would greatly facilitate the work I have to do. Thank you.
I also attach the excel sheet on which I have to work.

Starting from the recorded macro, I managed to create the macro that I attach. But the problems are different:
1. I have to enter the names of the data series by hand and this is very inconvenient since the series in all the graphs are called the same way.
2. Create an initial curve in the extra chart which calls "series1"
3. It doesn't always work, sometimes it creates as many data series as the columns of the excel file that I have attached previously.
Thanks to those who will help me.