Forum Discussion

Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 22, 2026

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...
Charting
excel
office 365
Lorenzo's avatar
Lorenzo
Silver Contributor
Feb 10, 2026

Things have evolved with Version 2602 - Build 19725.20014 => Revised this discussion title (was: Chart from dynamic array challenge)

Attached zipped files:

  • 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)

Resources