Forum Discussion
Lorenzo
Jan 22, 2026Silver Contributor
Chart updates inconsistently when dynamic array resizes
Hi (Excel 365 v2601 b19628.20132 Current Channel / Windows 11 25H2) Initial post edited (& cross posted here on Jan 29, 2026) after further investigations In B6 below an array that dynamically res...
Lorenzo
Feb 03, 2026Silver Contributor
You made a very good point in converting the Years as real Date values - EDIT: TEXT( Years, "0000" ) also does it. Unfortunately this doesn't address the whole issue
NB: In any case <false blanks> must be replaced (not a problem)
#1 Changing TOPN when the series are in columns doesn't work. Before:
After TOPN change:
#2 With a Transposed array (series in rows) TOPN can be changed to any value, this works no problem
#3 With a Transposed array, not changing TOPN but START Year. Before:
After START Year change:
Thanks much again Riny_van_Eekelen​