Have Excel Graph Horizontal Access Reference Have Sheet Name Included in Formula

How do you usually make copies of this tab? The way I usually do it goes something like this:

With the cursor in the sheet/tab of interest (not the chart):
1a) Home tab -> Cells group -> Format -> Move or copy sheet... or
1b) right click tab -> Move or copy sheet...
2) Select "Create a copy" checkbox and tell where you want the new copy of the tab to be placed.
3) Confirm selection.
4) Rename sheet, if I don't like the automatic name that Excel comes up with.

I find that, when I make copies this way, the embedded chart references all stay referenced to the "current" sheet rather than the original sheet. Since that sounds like what you are asking for, I suggest trying it.

No, I am not aware of a simple "formula" that would fit there. Chart references, even though they look like cell formulas, do not quite work like cell formulas.

Can you not program you macro that is creating the duplicated tabs to change the tab reference in the chart as it creates the duplicated sheet? Could you record a macro following the procedure I described to see what the VBA code would look like that recreates the exact steps I describe?