Calc offers an XY ("scatter") chart type: A data series is a pair of columns, containing X and Y coordinates respectively; and it results in points on the chart area. I would like to use the X and Y coordinates for placing some label, or numerical value, at different positions on the chart area. In this chart type, 3 columns will be necessary (for a single data series): X, Y and Value or Label. This chart type will have several variants, depending on what happens at each (x,y) point: * Value is placed as label only, and point indicator is independent of it * Value is used as radius of the dot/disc at each point (or a scaling factor of the shape, if it's a different point) * Value is used as the point on a color gradient of the dot or disc or shape at each point. Other choices might be similar to those of XY charts: * Which shape to use for the different points of a data series * What color gradient to use for the dots/discs/shapes; this could be done similarly to the selection of color gradients for conditional formatting. * Place a dot at each point Yes/No * Draw a line from point to point Yes/No * (related to bug 160398) Whether to use some background image (vectorized or raster) - such as a map
Created attachment 193377 [details] Example 1 An example XY+Value charts: X,Y and string label
Created attachment 193378 [details] Example 2: 3 data series, String labels with arrows Example XY+Label chart: This one has 3 data series, all associated with the same X,Y coordinate pairs. Each data series has a different shape marking the position, with a different shape color. Note the because the textual labels don't fit easily right next to the X,Y points themselves, they are moved farther away and arrows indicate which point has which value. Many points aren't actually marked with a string label.
Created attachment 193379 [details] Example 3: Values + colors + sizes all in one XY+Value Example 3: This example goes possibly a little beyond a reasonable ask, since each point has, at the same time, several values represent by the same disc shape: The disc color, disc radius, and adjoining label value are all apparently part of the same data series. Note specifically the color scale serving a sort of legend, on the side.
(In reply to Eyal Rozenberg from comment #3) > Created attachment 193379 [details] > Example 3: Values + colors + sizes all in one I guess this is a bubble chart, isn't it? https://help.libreoffice.org/latest/lo/text/schart/01/type_bubble.html I'm not sure you can set different colors (or custom colors) for each point, though.
(In reply to Rafael Lima from comment #4) > I guess this is a bubble chart, isn't it? Hmmm... mostly, yeah! But can you get bubble labels from a column? I believe that's not possible.
Also, what if you don't want the bubbles?
Created attachment 193485 [details] Scatter plot with extra data label Of course you can add data label from another source to your chart. Either you show it for all data points and remove individually or add one by one (click once, wait a second, and click again). Using arrows (example 2) is not possible without manually drawing (keep in mind that we are bound to the file format and cross-platform/application compatibility). And the bubble thing with different colors is another question. You can change the attributes of a single data point likewise the label after waiting a second.
We do have a scatter plot, and individual formatting of data points is possible => invalid enhancement request.
(In reply to Heiko Tietze from comment #7) > Created attachment 193485 [details] > Scatter plot with extra data label In the scatter plot, how do I enable all labels exactly? I see a "reset" which clears them all. Selecting the series and right-clicking it doesn't seem to have any option for showing the labels.
Insert Data Label, then change DL type to Category. Keep an eye on Data Range > Data Series, how to configure the chart's data.