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
Bookmarks