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 change when open, but the chart stands the range before
4 Replies
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
Yes, that's odd. It doesn't happen when you perform recalculations by pressing F9. Though, after closing and reopening the file it seems to misbehave when the seconds are higher than initially. But as soon as the seconds are lower than the value at which the file was saved, the chart grows with the expanding array again. could be a bug. Use the Feedback button on the Help ribbon to report it to MS. Who knows?
It just doesn't work, no matter the second is higher or lower than before.
I post feedback: https://feedbackportal.microsoft.com/feedback/idea/bbe5c087-1cb2-ef11-95f5-6045bdbc7c39
