Cannot get data point labels to show the right units

[BallistaBarista]

Hello there,
sorry for the question, but I feel like I have spent enough time already digging through forums and threads and still could not get it to work right.
My problem:
I have a single data point in a XY point-and-line graph. It has one float X and one float Y value from a table linked, aswell as a data row name. So basically it is a single point data row. I now want to show the coordinates in a label to be able to see the XY coordinates on a glance, because depending on other values, this datapoint might change a lot. The X and Y values in the linked cells come from formulas.
I have tried different approaches, but my coordinates are always “1;some number”. The problem is the 1. No matter how the numbers or the data is formatted, the X value is always 1, while in reality it should be something like “-24,65” or so (like the x value, which shows up corretly every time). I reckon it has something to do with the X value being treated as “category” in the data point formatting menu, but I am lost now.
Can someone please help me out? Thank you.
I added an image and realized, it does this with the other graphs, too. It really seems to have something to do with “categories”?

Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 12; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.1
Calc: threaded

[Villeroy]

1. Both cell ranges, having the x-values and the y-values, need to be numbers. The text “-15” is not a number. Number formats do not apply to text.
2. Change the chart type from “Line chart” to “X-Y Scatter chart”.

[BallistaBarista]

Thanks, but the formatting is already number format. The graph is also XY (sorry if my initial description was confusing). It’s a XY scatter chart with lines between the points.

[Villeroy]

ask115166.ods (29.8 KB)

[BallistaBarista]

Yeah, in this example, it works. I double checked all my cells and the diagram options for fomatting and it all is decimal number format. I can’t get it to work.
Edit: Hovering over it with the mouse cursor reveals the true values:

[Villeroy]

Do you send photos of your broken car to the mechanic?

[BallistaBarista]

What is that supposed to mean? It depends, sometimes I have? Do you want my sheet? If so, you could just have said that
Example.ods (23.3 KB)

[Villeroy]

Having the sample file, I confirm, that the cell values are numbers, actually. Therefore, formatting of the cells changes the appearance of these numbers, but with LO 24.2 the formattings of the chart axes do not follow. I can format the axes indepentedly of the cells.
LO 24.8 seems to have fixed this issue which was unkonwn to me.

[BallistaBarista]

Thank you very much for this clarification. This saves me a lot of time from here on out.

[Villeroy]

Oh, wait a moment. It has nothing to do with the version. A hard recalculation (Ctrl+Shift+F9) or reloading the file updates the cell based formatting in the chart. The behaviour is the same in 24.2 and 24.8. It does not catch the cell format change.

[BallistaBarista]

I marked this as the new solution, as it works for you and might help others. Somehow i still can’t get it to work. Maybe something is bugged for me that can’t be reproduced.