Existing Dynamic Chart adding in new columns of data not updating when new rows are added

First post:

I have an excel problem with dynamic charts we use weekly.

Short of it is we have two charts showing a 12 week lookback and 49 week lookback.

We add new row of data to each week and the charts show a lookback from the new week for the specified terms.

It was requested to add/insert two columns of data (F & K) which was done successfully but…

Now the charts are not updating as it used to when a new row of data is added, it just keeps the same chart periods before the new columns of data were added.

Included the original sheet which works as expected, and the test revised sheet that no longer automatically updates the dynamic charts when a new row of data is added.

I think I have all the offset periods in correctly for each series but the chart no longer has the series info.

Any help would be greatly appreciated.

The chart series do not refer to the dynamically defined range names, in the new workbook. Whereas that was the case in the old workbook.

Thanks, I had tried that before and could not get it to hold the range names. Gave it a shot again and it seems to be holding them now, except for the offsets for Column F for both charts. It looks correct but its pulling data from the middle of the range vs at the end for some reason.

Range F2:F61 of the Main Data sheet are blank cells, screwing with the OFFSET calculation.

Ah! Thanks that seems to have done it. Thanks so much for your help.