Ask Your Question

LibreOffice Calc X/Y range Problem for a plot (automatic update ) [closed]

asked 2013-06-03 12:39:55 +0100

sebberth gravatar image

updated 2015-11-02 03:08:43 +0100

Alex Kemp gravatar image

Dear all ! My problem is : I'm in LibreOffice Calc. I want to plot (x-y plot) the value from column A in function of column B. As these two columns are appended each days by new lines, I don't want to update the x-range and y-range values each days. So I put try to put in these two field A1:A10000 and B1:B10000, even if these two column are currently filled with only 500 values. The problem is that it's seems that LibreOffice Calc autmoatically update the values of these two field, and adjust these to the exactly size of the filled column. When I log off, my 10000 value is changed to 500, and I have to do the job again and agin.

I have tried an anohter method (use concatenate function to auomaticaly edit in a cell the string "A1:A500", but didn't find the way to send this information on the field X-range of the figure. It's seem that Libre office calc reject me each time I try to put a function (indirect, index or else... ), by showing red color in the field and I cannot click on "ok".

Could Someone find a solution to this ! ?? ( LibreOffice


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-02 03:09:02.211132


moggi gravatar imagemoggi ( 2013-06-04 01:06:31 +0100 )edit

Thanks for your help !!! Your solution work perfectly ! Sebastien

sebberth gravatar imagesebberth ( 2013-06-06 12:07:57 +0100 )edit

3 Answers

Sort by » oldest newest most voted

answered 2013-06-06 12:09:18 +0100

sebberth gravatar image

Thanks for your help moggi and mariosv !!! Your solution work perfectly ! Sebastien

edit flag offensive delete link more

answered 2013-06-04 02:56:47 +0100

ROSt52 gravatar image

@mariosv 's proposal of inserting rows is in most cased most likely the best solution. However, the inserting point for a new row(s) must be above the above the last data row.

image description

edit flag offensive delete link more

answered 2013-06-04 00:44:18 +0100

m.a.riosv gravatar image

Enable the Menu/Tools/Options/LibreOffice calc/General - Expand references when new columns/rows are inserted.

Instead of add data, use insert row below the last row with data.

edit flag offensive delete link more

Question Tools


Asked: 2013-06-03 12:39:55 +0100

Seen: 692 times

Last updated: Jun 06 '13