Chart updates inconsistently when dynamic array resizes

Question

Hi

• Excel 365 v2601 b19628.20132 Current Channel / Windows 11 25H2
• Sample file avail. here
• Question already posted here on Jan 22, 2026

In B6 below an array that dynamically resizes according to the 'START Year' & 'TOPN Cat' variables. The Chart is setup as follow:

• Select an empty cell > Insert 2-D Line chart
• Right-click > Select Data… > Chart data range > Select the Serie names & Values (C6:G12)
• Click Edit under Horizontal (Category) Axis Labels > Select the range with the Years (B7:B12)

Check of the Chart data range:

Changing 'START Year' works no problem: the Chart data range & Horizonal Axis Label range are properly updated

Changing 'TOPN Cat' (the array resizes horizontally) screws up the chart:

The Chart data range is properly updated but the Series & Axis Label ranges don't update accordingly

Q: Am I doing something wrong, facing a limitation or is this something else?

Thanks & any question let me know
Lz.

Answer 1

Things have evolved with Version 2602 - Build 19725.20014 => Revised this thread title (was: Chart from dynamic array challenge). This post on TechCommunity has a zipped file with:

• 26-02-07_SAMPLE_YearAsDate: [Year] converted as Date + <false blank> replaced with 0
• 26-02-07_SAMPLE_YearAsText: [Year] converted as Text + <false blank> replaced with 0
• 26-02-10_TESTS_ChartDynArray (tests conducted by someone else)

2026-02-10 Reported a problem at MSFT