Change the line graph range in Excel 2007 automatically without changing the data range

Hi All,

I am preparing a report where in I have plotted about 230 line graphs, I want the line graph to be updated automatically without me changing the source data range.

Is this possible. Please help me with this automation at the earliest and of possible guide me step by step as to how to automate such reports.

I have enclosed the source data and graphs as well.

Thanks and regards,
Vinay Kumar H M