Macro to copy and paste a Graph multiple times and pull the data set down to the new table

[Exceltookmyhairline]

Hello all,

This is my first post and I have been racking my brain trying to find an answer to this question. I hope you can all help. We have created a excel spreadsheet that pulls from other tabs in order to give a snap shot of an employees pay grade range and a compa ratio. In order to display this to leaders, each employee is listed below one another with a graph and table that shows exactly where they are at. When new employees are added, a pivot table pulls all their data. In order to put them into the summary tab and have a graph, I have to copy and paste the graph in the 19 cells below the current selection. When I paste, the new data on the table pulls from the pivot table but and the graph comes up. The problem is that the graph's data series is still tied to the previous graph. It is not so bad when it's one employee and I can just drag the series outline to the new graph. However, I have to update 300+ employees now. PLEASE PLEASE I hope someone can help create a Macro to autopopulate this. Basically there are 3 data series that need to pull down. The tables are the same size and are spaced out the same between each employee. Each data Series has 4 rows within 1 column pictured below[TABLE="width: 500"]
<tbody>[TR]
[TD]Comp[/TD]
[TD]Mid[/TD]
[TD]C/R[/TD]
[/TR]
[TR]
[TD]43306[/TD]
[TD]51175[/TD]
[TD]98%[/TD]
[/TR]
[TR]
[TD]43306[/TD]
[TD]52800[/TD]
[TD]97%[/TD]
[/TR]
[TR]
[TD]44337[/TD]
[TD]52800[/TD]
[TD]82%[/TD]
[/TR]
[TR]
[TD]44337[/TD]
[TD]52800[/TD]
[TD]73%[/TD]
[/TR]
</tbody>[/TABLE]

The data set has to be pulled down 15 rows from the last value in order to capture the new table. Any help is much appreciated as this has a couple of us stumped.