Build ID: 1:6.4.1-1
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: gtk3;
Locale: hu-HU (hu_HU.UTF8); UI-Language: en-US
I try to achieve something similar to How to create an XY plot with individual data points? but maybe the advices there don’t work due to their age, or it’s a different problem.
I have a similar table: lot of individual points (X,Y), all separately labeled. There seems to be two ways to achieve what I want:
- Create a chart with a lot of series, where each series contains one point and its label and marker
- Create a chart with one serie(s), which contains all the points but label them individually.
I do not have the faintest idea how the first would be achieved: I cannot coerce LO to put anything in the X-Values, no matter how convoluted I try to input the range. (True, I could add the series manually, separately, which is obviously not a real solution for a lot of datapoints.)
I can trick LO to create the second version. Almost. It requires an extremely convoluted sequence of steps: after creating the chart I have to edit it, then select one point, then right click and Add datalabels. But…
The result is one serie(s) with same looking points. However no matter what I input into the “Data labels” I cannot get them properly labeled. See this image:
Somehow they always get the Y-Values as the labels.
My questions are:
- How can I get it done the 1st way? It would be preferred.
- How could I get proper labeling with the second method?
Starting from @dscheikey’s comment I found that
- if I do
- edit » select a datapoint » right click » Add data Labels, or
- select top menu Insert » Data Labels, and no need to even touch anything
- then data labels appear.
- If I did the 1st version, I have to go back, right click again and then a new menu entry appears: Format Data Labels, where I can unselect Show value and select Show category; I sure don’t have to mention that “category” was found nowhere else in the menus.
- If I did the second version (and the labels magically appeared even without pushing Ok) then I immediately have the options to unselect and select the checkboxen.
So this is the solution to the second question, but this definitely badly needs fixing:
- completely undocumented
- inconsistently named
- almost impossible to figure out without help
- the Insert»Data Labels probably buggy since it shouldn’t add labels without Ok
- seems to play against Data Labels in the Chart Wizard