Repetitive charting on same graph

This is what I am trying to do, tracing one single graph by picking out data from a repeated interval. I've attached an example file with the chart I want to generate.

The logic is quite clean cut. But, I am not really sure how to translate it to VBA syntax.
Basically, on the Active sheet, I want to perform the following operation.

I have a repeating template of values.

Floating cell= C4
Floating range= FloatingCell to FloatingCell.offset(20,1)
Chart the same with Q2 on x axis, Q 3 on Y axis.
series name= D1

Floating cell=C4+24
Again, the corresponding range and chart it out on the same initial graph.
Series name=D1 offset by 24 on the column.

The charting should end when the floating cell basically find a value when it keeps going down. I have only 5 data sets in the example file here. But, the code is to enable me to deal with 500-600 such data sets.

To add to the complication, I am developing a macros which will dynamically move the sheet down. i.e. when a new data set is taken, the latest one gets pasted on top and all the other values move down. I want the graphing to be able to accommodate and trace the latest values too. I am thinking clearing the graph and rerunning the loop is one way out. But, there might be something more efficient.