VBA to draw a graph

Hi all this is my first post here and i hope i can get a solution.

I have an excel sheet populated with loads of values. There is a space between each set of data. I need to draw a graph for each section and i cant work out how to do it. I have attached the sheet in question.

The gap between each column has "space" written on row three which is needed to prevent it being deleted.

The drawing of the graphs needs to be automated as there is going to be 100's of sheets contain lots of data. The column width of each section can change so it needs to be dynamic

Any help is apprciated