Forum Discussion
Chart doesn't update its range when recalculate happen when the file open
Reproducible Steps: Set formula =SEQUENCE(SECOND(NOW())), and create a chart. It is a dynamic array, so the chart's range should update when the array change Close and open the file. The array...
With names it works on re-opening
X-axis is optional if you'd like sequential numbers instead.
It's a fallback solution. But since dynamic charts with dynamic arrays is a key feature in Excel 2024, I hope they can fix this problem to make it really work.
https://support.microsoft.com/en-us/office/what-s-new-in-excel-2024-for-windows-and-mac-faee26b6-ad74-40a8-9304-aa6db716553f