Ask Your Question
0

Trend Line Data Range [closed]

asked 2012-08-13 20:19:01 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 21:50:07.513170

2 Answers

Sort by » oldest newest most voted
1

answered 2012-08-14 17:19:19 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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

edit flag offensive delete link more
0

answered 2013-03-13 12:16:45 +0200

qubit gravatar image

Hi @Anon,

Does @Jens S's answer help you out?

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-08-13 20:19:01 +0200

Seen: 1,342 times

Last updated: Mar 13 '13