Calc chart/graph is empty at the beginning. How to consider only filled cells, not empty ones? (dynamic chart?)

English
,
#1

In Libre Office Calc (25.2.3.2 Linux Debian stable), my column “A” has dates like 01.07.2025, 02.08.2025, 01.09.2025

I am using that date column in a chart (on X axis, Y is amount), the data series “Categories” is “$Table.$A$2:$A$999”

999 because i do not want to bother editing chart data each time i add new row.

Problem is that the Calc for unknown reason is plotting the chart the way that it is empty at the beginning (despite my A column is not empty at the beginning, but empty at the end (my last filled cell is A134 and rest is empty) and as a time will pass, i will be filling next cells in the A column and need the chart/graph to consider/plot only filled ones.

How should I edit the "Categories" "$Table.$A$2:$A$999" or what exactly to edit (if you can please describe the steps since i am layman in Calc).

This unanswered question MAY be similar: diagram - Dynamic data range in Libreoffice calc - Stack Overflow

#2

Start your chart with the actual data, and later drag&drop the extended Data on the Chart, its a matter of seconds.

or attach a Example.ods with dummy-data, so we can examine.

#3

Non helpful post that does not solve the issue:
I can not see the way to DM you, so i will waste the space of this thread by my lame questions:

What exactly is meant by starting chart with actual data? I see that I can indeed select all data in table, and drag/drop it to the chart and it shows more or less similar chart as before, with up to date data:

$Table.$A$1:$G$134,$Table.$I$1:$J$134

but the Data ranges / Data series remains fixed (i see $134 there, and when i add next rows, the chart becomes outdated, and obviously i do not want to bother constantly drag&dropping the data), so my questions remains and if you can please describe the steps since i am layman in Calc. My question is general, I do not want to spend time composing sheet with dummy data.

My dummy data are:

A.............B
Date..........Amount
01.01.2000....100
02.02.2000....200
01.03.2000....150
#7

How do you add new rows of data? With copy & paste? Using the keyboard?

What chart type are you using? XY (Scatter), Line, Column?

As a workaround, if do you add to the actual data range one empty row below, you can insert empty rows as needed above this empty row, then add the new data. You can add to the last row the text “add data above this row”.

1 Like
#8

keyboard

Chart type is “Area”, “Stacked”

I have not understood your last paragraph. Please provide me exact steps on how to achieve it. (click XY, select “XY”…).

I am seeking universal steps on how to achieve what i need, not any custom solutions which may be useless for most people who come to this page. Thank you in advance.

#9

Select from the next row down, and insert rows above.
imagen

Add the new data.
imagen
The cell background color is just to see the chart range.

#4

What about …
disask_126079_GapsInX.ods (66.1 KB)

1 Like
#5

No, I do not understand what is different from my file. Please mention exact steps for anyone to follow.

#6

I won’t write an essay.
Remove confident data from your document, and attach the resulting file to your question.
One of the contributors may then be able to give reasonable and helpful advice without wasting a lot of time.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.