Frequently asked questions - Calc
From The Document Foundation Wiki
How can I create a chart in a spreadsheet so that the data is automatically updated on editing?
- Go to ▸ .
- In the dialog that appears, choose LibreOffice Calc > General.
- In the Update links when opening area, click on the Always button.