Need help for Automated Graph build macros

Hi all im new here.
My problem is that i have to create 100+ graphics (this my boss want),so after i create the first table i just copy past and change the data range and the name of the table.
I want to automate this process with macros so i record a macros .
Explaining: "Eono1 is the name om my workbook.
SO what i want ,the macros automaticali create new graph ,and chage the data range ,(my data range is for january to december i row so i want to grab the next row from C3:N3 to becom C4:N4)

Lets say i have 48 countrys (names R3C2),macros should automaticay stop after c48:N48 for 2014,q48:ab48-2013 and AE48:AP48.(The last graphic is created).
Thanks a lot
Regards.
Here is the macros and the exaple table with chart

http://speedy.sh/bga4E/exaple.xlsx

Please Login or Register  to view this content.

So really what i want to do after i record this macros up ,to edit it this way :
Next time whe i start the macro (by click or keyboard shortcut) ot add "+1" to this $C$3:$N$3 ,$Q$3:$AB$3 ,$AE$3:$AP$3 , R3C2(only R3 should be changed)
so they become $C$4:$N$4,$Q$4:$AB$4,$AE$4:$AP$4, R4C2 then save the chages with the new values.
So the next time i runt it it will chane "+1" again and all of the 4 become 5 and so and so on. In this way mu table will be ready with only one click.

If you use a loop with the variable X, you can use a syntax like

Please Login or Register  to view this content.

Thanks a lot
I just start to use excel few days ago ,and my codin abilities are at very low leve but i manage to do it.
For future readers ,First recodr macros with wanted table ,the add

Please Login or Register  to view this content.

Again thanks a lot you safe me hours of making tables with this suggestion .

Hi again here is a short 7 minute video what i have acomplish with your help
https://www.youtube.com/watch?v=6jJ0G9lF_4U
and the full one
https://www.youtube.com/watch?v=bxA8dNzrPE8