When there are gaps or nulls in the data then the "lines only" chart type selection doesn't produce a visible line. Therefore it is not possible to "select" the data series and amend its characteristics to make it visible. However, it is possible to double click the chart and then select the "Chart Type" toolbar button and modify the type to "Points & Lines", at which point the lines appear. Pointless to try to amend any meaningful characteristics as reverting to "lines only" disappears the chart again. Attached is a 3000-row file with two charts. (Just in case it's a feature of the data volumes) The first has continuous data in the column(K), the second has nulls interspersed with the data in the column(L). Double click the lower chart select "Chart Type" from the resulting toolbar Change the chart type to "Lines Only" Observe that the line disappears Change the chart type to "Points & Lines" Observe that the display is now "Points Only" The only way to get any lines back is to; Right-click the Data Series Select "Options" Activate the radio button "Continue line" from "Plot Options" If the line has been disappeared by the change of chart type it will revert to a line display if the toolbar "undo" is activated. NOTE: A standard filter has been set to "show" column D <343 to bring the data into visual range. Workaround: select "Points & Lines" and ensure the points are no denser than the lines. Version: 7.2.1.2 (x64) / LibreOffice Community XXXXXXXXX even though the panel doesn't mention this release XXXXXXXXXX Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
Created attachment 175290 [details] Full data file to demonstrate the issue
I have not tested the result of adding column M as a second series to the chart for column K. I also managed to misidentify Column M as column L in my definition - Ooops, Sorry
Seems it works with XY type
Seems it goes into full freeze "not responding" mode (using 43% processor) if 3D X-Y mode is selected and then when it eventually responds, the entire chart space is blank.
Curioser & Curioser. Having re-selected a visible chart type whilst typing the above response, it suddenly - automagically - reverted to an empty space as an X-Y 3D format. Steps to reproduce;- Just sit there and type an addendum to the error report ;)))
(In reply to Colin from comment #0) > Double click the lower chart > select "Chart Type" from the resulting toolbar > Change the chart type to "Lines Only" > Observe that the line disappears > Change the chart type to "Points & Lines" > Observe that the display is now "Points Only" Reproduced already with oldest of 6.3 Linux bibisect repo. In 50max repo, the chart is already blank upon opening. Arch Linux 64-bit Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: ffc23650d988051bf9fe43edeb4e16096907b080 CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 19 October 2022
*** Bug 156794 has been marked as a duplicate of this bug. ***
A related problem? https://ask.libreoffice.org/t/lost-chart-line-in-calc/95306