LibreOffice Version: 24.2.5.2
OS: Arch Linux, kernel 6.10.3
DE: KDE Plasma 6.1.3
Hi all. I’m using LibreOffice Calc to track a medical condition for my partner, and It’s working great, but there’s one thing I haven’t been able to figure out. My data consists of a single number value from 1-10 for every day of the month, so my first two columns are date and value. I have a third column for brief notes (just a couple of words), and I only have notes for a handful of days. They’re fairly important though, and when we visit her doctor, it’s important to see where they land on each chart. So far I haven’t figured out a way to get these notes to appear where I want them, so I’ve just been marking up the printouts with a pen each time.
To demonstrate I created a sample document (with fake data). I’ve attached the document below.
(I had a screenshot, but I can’t include it because I’m a new user)
For example, I would want the note about “too much mustard” to appear over the bar for 1/24. I’ve found a number of topics around the forums discussing data point labels (mostly on scatter plots), but I haven’t been able to make them work for my case. I understand that I need to use the third column as a category or a name, and then format the labels to use category or name respectively, but so far all I’ve done is mess up my X axis.
By editing the data ranges so that the “Name” range uses my notes column for Categories, I’ve gotten the labels to appear over the bars as I wanted. But, so far, every time I get the labels working, my X-Axis changes unexpectedly to match - the dates disappear and duplicate labels replace them. I don’t know how to avoid the change to the X-Axis.
Any input or advice would be appreciated. The document below shows the problem.
corndogs2.ods (57.1 KB)