asked 2012-08-13 20:19:01 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
Is there any way to set the data range of the trend line specifically without changing the entire data range of the original plot?
answered 2012-08-14 17:19:19 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
Correct me if I am wrong, but you I suppose you use the graph-function to insert a trend-line. You can also use the TREND function to calculate a trend-line in your own interval: =TREND(A19:A38;B19:B38) (this is a matrix-formula, so you have to use ctrl+shift+enter) and then incorporate the line in your graph.
Jens
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-13 20:19:01 +0200
Seen: 165 times
Last updated: Mar 13
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
