Bugs #86321 #136160 #136254 have been created specifically for this topic.
Still reproducible up to an including Version: 7.1.0.0.alpha0+ Build ID: f08ddf3d3df0ef12fef36e96ffe6f5b9a7fda9e3
Readers busy building spreadsheets (like me): some laborious workarounds that may (sometimes) help (while waiting for a debugged version) -
Click on the chart and dragging it a few pixels will cause it to update.
Zoom out (then in) the whole sheet view (using mousewheel if you have one) may work.
Copy the chart, paste the twin on the same sheet. The twin often autoupdates(!), the original can be deleted.
Don’t know if that works for everyone.
Note: OpenOffice (Apache) has the same flaw since 2014 up to 2020 (all after version 4.01).
(forum-test.openoffice.org t=71092 p=370292).
The pertinence is that Libreoffice Calc 4.1.3.2 could open those same files and the charts worked with LO.
Attempting to open LO Calc files with broken charts using Apache (2019), the x,y scatter remains immobilised on both softwares. So, it’s else than guaranteed yet reports exist of being able to recover a file by switching application/OS.
I have, once, only once, been surprised that 7.0.1.2 on Fossa Ubuntu 20.04 “refreshed” or “repaired” a file with broken charts. The software shows charts working - and the saved file then works everywhere else too!
That file was under evolution since two years (using Calc 6.3.4 on a different workstation Ubuntu Bionic 18.04) - and all the charts now work. It was/is a huge relief. So; Trying that out on a twin 6.3.4 file to recover more - (hoping to use Calc 7.0.1.2 on Fossa as a recovery tool) . . . it opened the file, saved it - none of the charts work any more, none at all. This attempt at workaround or getaround is All or Bust!