Libre Office has an easy way to calculate and show trade line in a graphic (i.e. right-click on data series and insert trend line). Formatting the graphic this way however is not really easy because the linear regression cannot be shown without the data series and drawing the linear regression only is precisely what I want.

I’m not trained in statistics, although I understand what a trend line is (with thanks to StackExchange), I don’t know how to calculate it.

Hence I would like to know: is there any automated means to calculate the trend line on Libre Office, other than the right-click option in the graphics?

**Answer**

LibreOffice’s help explains how trend lines are computed. You will see that the work is done through two functions: INTERCEPT and SLOPE.

If you are interested in linear regression, you should also have a look at the LINEST function.

**Attribution***Source : Link , Question Author : neydroydrec , Answer Author : Community*