Changing chart source data in VBA

Hi all. I have a few charts on a sheet that reflect the last 5 rows of data in another sheet, plus the header row above. I ran a macro recording and found out I can set this data using the following code:

Please Login or Register  to view this content.

I would like the macro to do this:

Please Login or Register  to view this content.

My questions are:
1) How can I find out the current source data of a specific chart? (For example, I want to get the "A6:L10" part in the first code above)
2) How can I move/increment that range down by an additional row? (e.g. move that range down a row to "A7:L11" like the second code above)

Any ideas? I want to repeat this for almost 30 charts I have on this sheet.

Also attached is a screen shot of the data table I am using for example.