Scatter X,Y individual points with labels

asked 2020-04-20 17:22:48 +0200

grin gravatar image

updated 2020-04-20 23:33:15 +0200

Version: 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 Calc: threaded

I try to achieve something similar to 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:

  1. Create a chart with a lot of series, where each series contains one point and its label and marker
  2. 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:

See this image...

Somehow they always get the Y-Values as the labels.

My questions are:

  1. How can I get it done the 1st way? It would be preferred.
  2. How could I get proper labeling with the second method?

UPDATE1: Starting from @dscheikey's comment I found that

  • if I do

    1. edit » select a datapoint » right click » Add data Labels, or
    2. 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
edit retag flag offensive close merge delete



In Data Labels - unmark Show Value as numbers - and mark Show category! Is that what you need?

dscheikey gravatar imagedscheikey ( 2020-04-20 19:11:50 +0200 )edit

Where exactly?

grin gravatar imagegrin ( 2020-04-20 23:14:51 +0200 )edit

AARGH! This is worse than I thought. I have found it, I'll update the question. Thanks @dscheikey.

grin gravatar imagegrin ( 2020-04-20 23:21:26 +0200 )edit

completely undocumented

Doesn't document it? Opening main help page, and entering "label" into Index gives me that as the single match under Charts.

Mike Kaganski gravatar imageMike Kaganski ( 2020-04-21 07:20:15 +0200 )edit

Well I can't find it on and from which is the Scatter-XY help. If I knew that I have to use different menu I can find it's help page, but...

grin gravatar imagegrin ( 2020-04-21 14:57:32 +0200 )edit

from which is the Scatter-XY help

As mentioned, typing "label" in Index there right on that page gives the result. You can't expect that every possible link somehow applicable to XY charts (there may be hundreds of them) is listed in the text of the page. Search facilities in help are for a reason.

Mike Kaganski gravatar imageMike Kaganski ( 2020-04-21 16:52:32 +0200 )edit

I am sure this is not the best way to discuss this. Scatter Chart wizard asks for data labels, does not display them and gives no hint why. Wizard Help [button] leads to the page I showed an gives no hint why, either. It is not even obvious what needed to be set, so I can't know what to search for. It is really simple to know it - restrospectively. Not the other way though. I guess I shall PR against the docs somehow, still, I can't see how to get the 1st version done.

grin gravatar imagegrin ( 2020-04-21 17:38:42 +0200 )edit