Chart & Visualization Issues

Fix Excel Dynamic Array Charts That Do Not Update

Algirdas JasaitisAlgirdas Jasaitis Nov 18, 2026 870 views

Question details

The user needs an Excel chart to resize automatically when its source dynamic array changes.

Fix Excel Dynamic Array Charts That Do Not Update
Product
Microsoft Excel for Microsoft 365
Device & OS
not provided
Scenario
A chart is created from a spilled array in the Monthly Enterprise Channel, and the array's number of rows changes.
Observed behavior
The chart can be created from the spilled range but does not resize when the spill range changes.
Before you start

Confirm that the source formula spills successfully and that its anchor cell is not showing a #SPILL! error. Note the anchor cell and worksheet name so you can test the chart source.

Solution 1Recommended

Update Excel and test the chart in a new workbook

Use this check to distinguish a workbook-specific issue from a build, rollout, or channel limitation.

1
Check the build

In Excel, open File > Account and note the Microsoft 365 update channel, version, and build under Product Information. Compare them with Microsoft's current feature documentation.

2
Install available updates

Under File > Account, select Update Options > Update Now if available. If updates are managed by your organization, ask your IT administrator about the latest approved build.

3
Restart and retest

Close and reopen Excel. In a new workbook, create a dynamic array, select a cell in the spilled range, and choose Insert > Chart. Change the formula or its inputs to alter the spill size and check whether the chart resizes.

Update Excel and test the chart in a new workbook
Feature availability can vary: An eligible build does not guarantee that a feature is active. Staged rollouts, feature flags, or known bugs can affect behavior; check Microsoft's release information or ask your administrator.
Free Microsoft Office alternative

Create and Edit Spreadsheet Charts with WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets and charts. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files, though it does not fix Excel's update-channel behavior.

Create and edit spreadsheet charts in WPS SpreadsheetsOpen and save Microsoft Excel XLSX filesWork in a familiar, easy-to-use interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why does my chart not resize when the spilled array changes?

Chart support for dynamic arrays can vary by Excel build and feature rollout, and a bug may also affect resizing. Check File > Account for your build, install available updates, and test in a new workbook.

How do I refer to an entire spilled range?

Add the # operator to the spill anchor, such as =Sheet1!$A$2#. You can enter this reference under Formulas > Name Manager > New, although chart support for the resulting name may vary.

Can a dynamic array spill inside an Excel Table?

No. Place the dynamic array formula outside the table. If you use a table as the chart source, populate its rows separately or with a refreshable query.

What if my organization controls Excel updates?

Check File > Account for the installed channel and build, then ask your IT administrator about available updates and feature rollout settings. Update Now may be unavailable in managed installations.