copying excel graph & data table.
 

I have created a data table and a graph. I have copied this 50 times, in the
spreadsheet. The copies of the graph refer to the original data table. I
want the data series range to auto select from the cells of where I have
copied too, without having to adjust every single graph.
Please help.
Many thanks.