Chart data labels don't follow when copying entire tab if data is empty

[Nazhien]

Hello, I have a file with data that the user will input in column G, this is then copied and slightly modified in column AB-AE.

I then have a chart that looks at the data in AB-AE and creates two charts that shows the length and height of the values in column AB-AE (which are the values visible in column G)

The user will then copy the entire tab, replace the data in column G and this will repeat like 50-200 times depending on the project.

Everything works perfect IF the G column actually contains atleast 1 row. If G is empty, one single thing will break and that is the chart data labels. They will point to the copied tabs data, and not update when the tab is copied.
This means when the user inputs data in column G, the chart will have the correct data, but the incorrect labels.

I anonymized an example file, if you copy tab '100' like it is, it's going to work fine, and the chart will update correctly.
But if you first delete the data in column G, and then copy the tab, and then start filling in new data in column G, the data will show up in the chart correctly, but the labels will be pointed to tab '100', which is incorrect and unwanted behavior.

Is there any way around this that I am missing? I tried googling but to no avail. Maybe another way to setup the data labels?

[JeteMc]

When I open the file the following dialog box appears.