Description: When you create an XY chart, and wish to create data labels for each point; LO Calc ignores whatever you use in the [Data Labels] textbox of the [Data Ranges] dialog box for the chart. Note: I am not 100% that FORMCONTROLS is the correct label above, it just seemed the closest option. Steps to Reproduce: 1.Enter two columns of numerical values for xy values, enter a third column of same length for the [Data Labels] (i.e. A, B, C, D, E, ...) 2.Highlight the data; Insert > Chart; correct the wizards guesses for [Data Ranges], [Range for X&Y Values], & [Data Labels] 3.Double click the chart to enter the chart editing mode; single click on a data point (which will select all the data points) and right click & select [Insert Data Labels]. Actual Results: It will then show only the Y-axis values of each data point & not use the information provided in the [Data Labels] field. Expected Results: It should use the values indicated in the [Data Labels] field, for each data point. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: It should use the values indicated in the [Data Labels] field, for each data point. Note: This bug should not be affected by user profiles; so I did not reset my profile. System Info: 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 Renderer: GeForce GT 730/PCIe/SSE2 Vendor: NVIDIA Corporation Version: 4.6.0 NVIDIA 441.12 Shading language version: 4.60 NVIDIA v3.0 (100 % - 23/23)v3.1 (100 % - 7/7)v3.2 (100 % - 10/10)v3.3 (100 % - 10/10)v4.0 (100 % - 14/14)v4.1 (100 % - 7/7)v4.2 (100 % - 13/13)v4.3 (100 % - 20/20)v4.4 (100 % - 10/10)v4.5 (100 % - 11/11)v4.6 (100 % - 11/11)vARB 2015 (41 % - 5/12)
Created attachment 159769 [details] SpreadSheet containing the problem described.
Created attachment 159770 [details] Contains a screenshot containing the appropriate dialog box.
In the dialog for formatting data labels, in the Data Labels tab, tick the box "Show category". Arguably this could be explained more clearly in the Help https://help.libreoffice.org/latest/en-US/text/schart/01/04030000.html and Calc Guide https://documentation.libreoffice.org/en/english-documentation/
(In reply to Buovjaga from comment #3) > In the dialog for formatting data labels, in the Data Labels tab, tick the > box "Show category". > > Arguably this could be explained more clearly in the Help > https://help.libreoffice.org/latest/en-US/text/schart/01/04030000.html and > Calc Guide https://documentation.libreoffice.org/en/english-documentation/ The upcoming Calc Guide now has improvements https://listarchives.libreoffice.org/global/documentation/2020/msg01735.html