Loop macro for multiple separate graphs from rows of a large data set

(Please - Bear in mind i have very little VBA knowledge) (Use Excel 2007)

I am working with large amounts of data from a doppler water current radar,

My data is:
1st row: C24-AB24 (which needs to be on Y-axis) (Heights of readings from sea floor)
2nd row & all other rows: C25-AB252 down to C4938-AB4938 - Each row as source data for X-axis in each graph (X-axis) in seperate graphs (readings of shore velocity at each height)

I am trying to create a macro that repeats the creation of graphs until the last row of data with some sort of loop command (for loop etc) - with each time selecting the next row (each row as X-source data for each graph).

I.E. each iteration (i), the same Y-source row (first) but the X-source from the second row and each of the next rows each iteration - producing a graph every i,

Please help me out to incorporate a loop command.

This is a script i recorded for the graph I'm trying to automate

Please Login or Register  to view this content.

Any help will be much appreciated thanks
Glenn Toms
Stellenbosch, South Africa