I have a sheet with lots of graphs in with the data for each graph above each one.
I have to move the order of the data and graphs and i'm trying to find the easiest way to do it.
My question is can I move the data for each graph without having to edit the data range for each graph? ie is there a way to 'lock on' the data so wherever it is or moved to the graph will
always pick it up?