Description: I used LibreOffice-Calc to create a Net Plot to compare two Data Series. I used Chart Type Net using "Points and Lines" style. The second data series had No initial y-value to plot in the first Category. So, after creating the Net Plot, I did Edit Chart - Format Data Series - Options Tab -Plot Options - Plot Missing Values - Continue Line (true). I expected this to connect the last data point in the series to the second y-value. What happened was the line was extended from the last data point to the missing initial y-value, leaving a gap to the second y-value. Steps to Reproduce: 1.Create Net Plot to compare Two Data Series - use "Points and Lines" style 2.Delete initial value of second data series 3.Edit the Chart (Net Plot) 4.Right Click on data series and choose Format Data Series 5.On the Options Tab, select Plot Options\Plot Missing Values\Continue Line (true) & Press OK Actual Results: The connecting line for data points in 2nd series extends from the last data point in series to the missing initial y-value. Connecting line does not extend to second y-value in the series. Expected Results: I expected all data points in the second series would be connected together & the missing value ignored. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.8.4.2 (X86_64) / LibreOffice Community Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002 CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: threaded
Created attachment 198974 [details] Net Plot demonstrating unexpected data point connecting line behaviour
I'm sorry, but I don't understand the usefulness of closing the line in this type of chart. Perhaps there are cases where it might be of interest. What do those lines added to close the gap mean? I think it can only lead to a misunderstanding of the values.
Created attachment 199020 [details] Example of Net Plot output from Google Sheets PDF Example that shows how Net Plot in previous attachment Oranges_and_Apples_01.ods is displayed in Google Sheets.
Created attachment 199021 [details] Net Plot from Google Sheets of Bike Wheel Spoke Tension Readings Example of Wheel Tensiometer output data displayed in a Net Plot using Google Sheets.
(In reply to m_a_riosv from comment #2) > I'm sorry, but I don't understand the usefulness of closing the line in this > type of chart. Perhaps there are cases where it might be of interest. > What do those lines added to close the gap mean? I think it can only lead to > a misunderstanding of the values. Connecting data points in a series using lines doesn't really have a meaning particularly. Connecting two data points doesn't mean the real data is a linear function that follows this line. The connecting lines are a visual aid to help an observer identify trends within a series or differences between data series. I guess that is their "meaning" or purpose. These lines are just a visual appearance choice and when offered by software would be expected to treat all data points consistently. The Continue Line option for missing data points in LibreOffice Net Plots skips the missing data and connects adjacent data points only for missing values in the middle of a series. The function treats missing data points at the start of the series differently. At present the line is continued from the last available real data point and stops at the Category of the missing initial value - leaving a gap to the next real data point in the series. So, the connecting line is currently indicating a fictitious value where no real data exists, which is incorrect. (See attachment Oranges_and_Apples_01.ods) The behaviour of the Continue Line function in LibreOffice is also not consistent with that of Net Plots offered in other software applications, which seem to treat all missing data values in the same way. (See attachment OrangesApples_GoogleSheets.pdf) The attachment BikeWheelSpokeTensions_GoogleSheets.pdf shows a typical plot used in bike wheel building which can be achieved using a LibreOffice Net plot that has missing values.
If the second or any other value is missing (eg. Apples = 16 and Pears = "") it works as expected. I would treat this as a bug.