Chart- step thru a ranges of columns, Create new chart, X-axis is constant with each charl

Hello,
Thank you for your help. I have tried to solve my problem by watching youtube videos without any success.
The AA columns are killing me.

My goal is to learn how to;

1) step thru a range of columns, create a new scatter plot for each range and the x-scale will be consistent for every new chart.

2) Chart location. - Please stack the chart in a vertical sequence.


3) Chart title - Please include the vba code to update the chart title. This location will always be located at the first column of the data set

Attached is example of the data, chart location and label.

Thank you for your help