Changing references in graphs without using the Source Data option

  • Thread starter Thread starter DRR
  • Start date Start date
D

DRR

Hi
I have set up a graph which i want to copy to identical sheets all
named differently, but i cant use the find & replace function as its a
graph

Can anyone please tell me how i can change the chart references so that
for each copy i can link it to the new sheet name, without having to fo
into the Source Data option for each Series & Graph??

Many Thanks
 
Back
Top