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.
Bookmarks