this post was submitted on 17 Oct 2023
2 points (100.0% liked)

LibreOffice

463 readers
6 users here now

LibreOffice is a powerful free and open source office suite, used by millions around the world.

founded 2 years ago
MODERATORS
erAck@discuss.tchncs.de
2
[Solved] Plotting weight? A how to question (lemmy.one)
submitted 1 year ago* (last edited 1 year ago) by waspentalive@lemmy.one to c/libreoffice@discuss.tchncs.de
3 comments fedilink hide all child comments
 

[Solved] Use date format for the dates and use the xy scatter plot

I have the dates and weights for the times I was weighed at my doctor's office. I would like to plot those so that the actual slopes are visualized.

I tried just putting the numbers in two columns and plotting them with a line plot but the days between the dates are irregular, sometimes 3 or more months elapse, sometimes only a week or two, but the dates on the graph are evenly spaced.

Is there a setting that will space the dates out to account for the number of days between dates, so I can see how well my diet is working?

you are viewing a single comment's thread
view the rest of the comments
[โ€“] Chais@sh.itjust.works -1 points 1 year ago (1 children)

Did you change the type of the date column to date? It sounds like it's used as a string, which means it is used as categorical data.

[โ€“] waspentalive@lemmy.one 2 points 1 year ago

Yes, I think I did. I will make sure and try it again.