I created some charts in a sheet (Sheet1) and would like to replicate it in another sheet (Sheet2). The charts titles are using a cell to pick up the value. I use the = (equal sign) pointing to the cell with the title. When I duplicate the Sheet1 (with Move or Copy) the chart titles sheet reference is not changed. For example I have the Sheet1 with charts pointing to cell D2, this is what is in the chart title: =Sheet1!$D$2. When I replicate the Sheet1, the charts title on Sheet2 are not updated with =Sheet2!$D$2, instead, it still remains with Sheet1 reference: =Sheet1!$D$2. Is there a way to change all the charts title at once? I tried to go to Find & Select, and clicking on Replace but did not work.

Can anyone help me, please?

Thanks!