I am on Ubuntu 24.04.3 LTS, using LibreOffice 24.2.7.2. I’ve converted this spreadsheet, including its chart, from a Windows 10 machine Excel spreadsheet. I’ve used the spreadsheet resaonably often, written macros for it, etc. Now I’ve come to my financial end-of-year chart, and getting a result I don’t expect.
I have a chart that shows end-of-year figures for 2014-2024. I want to add 2025. I clicked on the chart and got the grey outline, right-clicked to get “Data Ranges”, and edited the range box so it read “$A$2:$B$14” instead of “$A$2:$B$13”. The chart did not change, it still shows values through 2024.
Is there something else I’m supposed to do to get the new range to be used on the chart. I clicked around looking for a way to update the range per axis, but didn’t find one.
I did eventually find the option to set to automatically revise the chart for new data when new data is entered below/right of existing data and turned it on, but that didn’t update the chart either. I tried deleting the data I had entered and repasted it in place, and that still didn’t update the chart.
Any help appreciated.
If someone wants to give me a bonus, there’s supposed to be a way to set Calc so that the chart is updated automatically if figures are placed in the next cells below/right of the existing data. I followed the instructions for that as far as I could