How can I get a calc line graph to display accurate dates when I hover mouse over them

English
#1

I have a large line graph tracking my finances. Points are a weekly total, and because it is now at about 750 points I have formatted the X-axis to show by month. To compensate for the density of this graph, I use the mouse hover to inspect a point for its value. The Y-axis is good. However, the date indicated when I hover is not the actual date of a particular amount. It seems to be a date derived from the X-axis. An example:

Date Amount

2/5/21 627680

2/12/21 635750

2/19/21 640874

2/25/21 635324

Hovering over each of these points shows the date to be Feb-21 [the format of the X-axis] rather than 2-12-21 which is available in the data set.

#2

Please attach a sample file.

#3

Uhmmm… this is personal info. Not going to attach the file, nor am I going to create a new file with 750 weekly dates and perhaps use an arithmetic function to give it 750 value points. Then format the X-axis to show monthly [Sep-20, Oct-20, Nov-20 etc] make the graph, post it so you can go “oh”.

I think I described this quite well. I want the hover value to match what is in the data, not what the label is under it on the X-axis. My original Excel version did this without any special formatting, but obviously it is needed here, and that is my question.
To make it explicitly clear, when I hover over the first point I listed before, I see “2-21 627680”. When I hover over the second point, it shows “2-21 635750”. When I hover over the third point it shows “2-21 640874” Then, “2-21 635324”. I want to see “2-5-21 627680”, “2-12-21 635750”, “2-19-21 640874” “2-25-21 635324”.

#4

Sorry, but is you asking for help, and you expect others doing what you do not want to do. Perfect, good luck.

#5

Quite ready to do work. Actual productive work with anybody who can think. This is a pretty well described problem that does not need an “example” sitting in front of you. If you don’t know, say so and let me move on.

#6

I’m using LibreOffice 7.2.4.1 on a new Macbook Pro (M1 Pro) and hovering over chart lines only shows the column name (e.g. Column B) or column title. I’m hearing the same with Linux computers.
Maybe it only works on Windows computers?

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