Fix Excel Dynamic Array Charts That Do Not Update
Question details
The user needs an Excel chart to resize automatically when its source dynamic array changes.

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

Try a named range based on the spilled array
Use this workaround if your Excel build accepts a spill-based named range as a chart series source.
Use an Excel Table as the chart source
Use a table when the spill-based chart source is not supported and you can place the chart data in a table.
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.

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.




