Hello, sorry if this question has been asked before.
I've got a project where there are a LOT of worksheets. Each worksheet has the same basic layout. On the first worksheet I created a graph, which uses data from columns A and B.
I want to create an identical graph on every worksheet, using data still from columns A and B on the relevant worksheet. Obviously I could do this by copying and pasting the original graph onto every worksheet, then formatting every graph to update the source data worksheet reference. This will take ages though, as there are so many worksheets.
Is there another way of doing this so that the worksheet reference automatically updates as I copy and paste the graph?
Many thanks,
Chel
Bookmarks