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