Macro for making repetitive charts out of excel spreadsheet data

[emcadenlg]

I am a teacher and am tracking points the kids earn for different activities. The workbook has a spreadsheet tab for each student. There is a table of data for each week of the school year and each table needs to generate 2 charts. I am looking for a macro to develop all of the charts and paste them into the same spreadsheet as the tables. I have done this the long tedious way on one tab and it takes forever. Hoping someone can help me with a macro to do this easier. I have attached a spreadsheet so that you can see what I am talking about. Each table has 2 bar graph charts. Thanks in advance for any help.