We’re rewarding the question askers & reputations are being recalculated! Read more.
6

First, calculate the linear regression factors: y=ax+b with the following formula: =LINEST(B2:B21;A2:A21) Then add another column next to the y-axis and name it calculated y-axis. Build the following formula to calc. the y-axis and copy that for all x-values.: =$D$3*A2+$E$3 Next is a piece of cake. Add the calculated y-axis to the existing data range or ...


3

Use the SMA (Simple moving average). It works as follow Take W points back (e.g. 3, 5 or 10, that's your window size) and do an average for them. This will create a new point Use those newly created points to plot your line. NOTE: at the end you'll have N-W+1 points where N is original number of points and W is your window size Here is an example google ...


1

There's multiples ways to do this : I used =Trend but =Growth works too. =TREND(C2:C11,A2:A11,A12:A24) =Forecast is an amazing function too. =FORECAST(A3,$B$2:$B$11,$A$2:$A$11) You can use Arrayformula for extra lazyness : =ARRAYFORMULA(FORECAST(A3:A24,$B$2:$B$11,$A$2:$A$11)) Theses formulas will be accurate the more data you feed them. I updated ...


Only top voted, non community-wiki answers of a minimum length are eligible