https://bugs.documentfoundation.org/show_bug.cgi?id=165043
--- Comment #5 from Michael Woodhead <[email protected]> --- (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. -- You are receiving this mail because: You are the assignee for the bug.
