I have a simple XY scatter plot made from a 2-column spreadsheet. When I hover over a dot, I can see the ID of the dot (e.g. "Data point 8456").
I would like to know if I could have the content of a third column instead of the ID. Ideally, a dot would then be defined by an "X", a "Y", and a name.
It can be done; this won't show a label on hover, but will put the text in the plot itself. (Tested in LibreOffice 4.0.4.2 but likely to work in later versions.)
Select the columns that contain the data you want to plot (but not the labels) and create a chart (Chart button or Insert->Chart...).
Choose the XY (Scatter) chart type and click Next. Then have the "First row as label" checked or unchecked as appropriate and click Next.
Once you are on the dialog for selecting Data Series and Data Ranges, select any of the Data Ranges, then define a range for the "Data Labels" (the text you want next to each point) by entering it or using the tool that allows you to select it from the spreadsheet.
Once you've clicked "Finish", either
1) Select the points, right click and click "Insert Data Labels", then right click again and click "Format Data Labels; or
2) Click Insert->Data Labels...
Make "Show category" checked. Make "Show value as number" unchecked. Click OK. You should now see the data labels. Depending on how close your points are etc., they might overlap each other; the Format Data Labels dialog box has options for font, label placement and rotation which could be useful.
If this answer wasn't satisfactory, this might help (it's more or less what I said, but worded differently): https://ask.libreoffice.org/en/question/23756/calc-insert-text-next-to-the-charts-data-points/?answer=25142#post-id-25142
The solution above does not work for me ...
... no matter what I do, I can only get the 'Y-Axis values' to show as data labels .?.
Is this is a bug, is there a solution (in this simplified example, I would want 'A' ... 'E' to be used as Data Labels for the Data Points.
Here is the relevant system info:
LibreOffice Calc
Version: 6.3.5.2 (x64)
Build ID: dd0751754f11728f69b42ee2af66670068624673
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
user486920's solution works for WPS (another office software mainly distributed in China) too :)
The key is that you make sure to click "Format Data Labels;" after insert data labels. I wonder why libreoffice official current user document does not include this XY scatter chart instruction.
