Hello,
I am making a report that has lots of graphs, a lot of my data is coming in from other sources so that I only have to change one cell and my data tables will refresh.

I'd like to copy and paste my tables and graphs (as I have to do this about 50 times) and not have to change the source data of my graph each time... right now when I grab the 30 rows that contain my data and my graph and paste them, the graphs are still referencing the old data...

Is there a way to change the SERIES reference of the graph from absolute to relative?

If this is unclear let me know, thanks in advance for your help.

Adam