Ask Your Question
0

Libre Charts: How can I make a graph dynamically adjust its range based on how many cells have data

asked 2019-05-20 23:31:13 +0200

CompilingInformation gravatar image

I have an excel spreadsheet of my weight that I update daily. I want the graph of that data to update its range to however many cells have been updated with new weight data. Currently I have to update the graph each week to readjust its range to however much data I have, and I'd like to make that process automatic where it automatically sets the range it graphs to however many cells have data in them. So instead of the graphs range being :

$WeightSheet.$C$1:$C$100

I'd like the range to start at cell C1, and go down until it reaches an empty cell. Is there some sort of command or input I could use like I just made up below that would work in this situation?

$WeightSheet.$C$1: "HAVE RANGE EXTEND UNTIL NULL CELL IS FOUND OR UNTIL" $C$100

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2019-05-21 01:03:23 +0200

See the example of this PivotChart in the accepted response example.

https://ask.libreoffice.org/pt-br/que...


ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more
0

answered 2019-05-21 00:37:29 +0200

Lupp gravatar image

updated 2019-05-21 00:40:06 +0200

Main suggestion:
Define the range with (at least) one empty row at the end. Insert new rows for data immediately above this row. The range will adapt automatically.

Imo not preferrable:
Set the option
Tools>Options>LibreOffice Calc>General>>Expand references when new columns/rows are inserted
Now the range for the chart will even be adapted if you insert new data rows immediately below those alrteady contained in the range.

Why not:
Set the range to the maximum you want from the beginning. Labels plus 13 weeks, e.g. would make 92 rows.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-20 23:31:13 +0200

Seen: 39 times

Last updated: May 21