Expanding range for chart, doesn't show up on chart

[notLion]

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

[notLion]

Some additional info: I have two scatter plots and one bar chart on the same spreadsheet, showing different views off the same table of data. I add a row to the data at the end of each year. When I updated the range on the bar chart (by double-clicking the chart, right-clicking the graph portion, and entering the new range), the bar chart immediately updated to reflect the new range, just as I expected. But on neither of the scatter plots did the graph update, and I can find no way to tell them to update.

I finally created new scatter plots, I guess we’ll see what happens next year. But I’d still like to know if there’s a way to do this.

[Villeroy]

Tools>Options>Calc>General
“Exand references when new columns/rows are insterted” = ON

Now you can insert new cells (or entire rows) directly below the referenced area and the references will adjust, for instance A1:X99 becomes A1:X100. Same with columns (A1:X99 → A1:Y99).
This affects all references in formulas, names, charts and elsewhere.

With that option unset, references expand when you insert cells within the range. Insertion on top moves the reference down (A1:X99 → A2:X100). Insertion directly below does nothing.