Quick Way to update Multiple Graph

[gplhl]

Hi,

I and a colleague are a bit stumped, trying to create a heck a lot of graphs, by copying an pasting.

These are all in the same sheet, looking at tables for data. They are being copied and pasted to the same location in relation to each table.

The graphs links remain as absolute to the original data.

Is there a quick way to either toggle on and off absolute references prior to copying and pasting (and therefore they auto update to the new tables) or is it a case of you have to manually update the references to each one/

This is very time consuming manually.

Regards,

Gary

 

[Kamolga]

Fct+F4 on keyboard to quickly add or remove absolute reference.

Now, when you paste a graph, it is not on a specific location, so there is no way to go x rows down, y column right...but if you copy a sheet, graph on sheet 2 will have its data in sheet 2 as well automatically, so rather need to change data or you can then cut and paste in sheet 1 and delete sheet 2