Bug 111362 - [Feature request] Possibility to exclude data point from trend line
Summary: [Feature request] Possibility to exclude data point from trend line
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Chart-Trendlines
  Show dependency treegraph
Reported: 2017-08-04 19:52 UTC by krzmbrzl
Modified: 2018-03-29 20:54 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description krzmbrzl 2017-08-04 19:52:19 UTC
When having a data series it can be visualized using a chart and in that chart one has the possibility to display a trend line (equation) that fits the data points the best. However there is (as far as I know) no possibility to exclude one or more of the data points from that trend line.

An example of when this would be useful would be the following: One has done an experiment and is now visualizing the results as a chart. However there is this one data point that you know can't be correct so you don't want to include it in your analysis (but you still want to have the point itself being displayed in the chart in order to provide a complete overview of your results).
As of now you have to create a new data series in Calc, remove that one data point from it and put that one in the same chart as the one before and calculate the trend line from that.

It would be really handy if you were able to graph all data points in the chart and then select one (or more) in order to exclude it/them from the tren line calculation. That would provide a much quicker and more user-firendly approach to the scenario.

NOTE: If someone can give me some hints on where this has to be done (in the code) I might be able to implement it by myself... So if you don't have time to implement it but you have a rough idea on how it has to be done: Please share your knowledge ;)

Steps to Reproduce:
none - it's a feature request

Actual Results:  
none - it's a feature request

Expected Results:
none - it's a feature request

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:54.0) Gecko/20100101 Firefox/54.0
Comment 1 Cor Nouws 2017-08-08 18:48:17 UTC
thanks for filing > new