How to use the Forecast Linear Function in Google Sheets and add a Trendline in a Chart
Вставка
- Опубліковано 9 лип 2024
- This short video shows you how to add a trend line to a chart in Google Sheets and also how to forecast the date at which you would reach a daily spending goal based on actual historical data.
You can find me on Instagram: / davidresau
How to add a trendline in google sheets
=FORECAST.LINEAR(Empty Date Cell, Spend Y-Axis, Date X-Axis)
Date, Spend, Goal
If you thought this video was useful, please like, share, and subscribe.
#googlesheets #trendline #forecastfunction - Навчання та стиль
You are my hero. I watched like five other videos before I watched this one and this actually helped me figure out what I was doing. Thank you!
Awesome, glad you got it figured out. Thanks for watching and I hope you subscribe. 🙏🏽
David, thank you for informing us viewers in an easy and simple way.
it was quite cool of you
helpful and straight to the point, thank you!
Thank you!
Well done, nicely explained in an easy to follow way.
broooo thx! I just really freaking needed this ^^
You are welcome.
Thx for the succinct explanation and perfect example! Also, thx to Jared Hodge for the extra advice. Cheers.
But just to add, rather than setting the independent and dependent variables as absolute values (i.e. using the "$" sign), I was able to get incredible accuracy using a 21-series moving average. Of course, the moving forecast is dependent on the actual data as they become apparent, so I guess this would be great just for a few days of forecasts and not too far into the future. I used a bit over a year's worth of stock's price data (294 data points for a blue chip company) and can confirm that overall accuracy was a stunning 0.22%! Thanks again!
Very helpful thank you!
Very helpful!
Nice thanks
Schools should teach this.
Great video ❤️
Thank you!!! They definitely should.
Do you know how to make the trendline show the value at all when we want certain value of y axis and they just show us x value with the specific y value form the trendline?
very good tutorial
Awesome thanks
so useful 🙏
edit: don't you think you should use the $ symbol to lock the function values?
ie. =FORECAST.LINEAR(A32,B$2:B$31,A$2:A$31)
seems like if you don't then you're using forecasts to predict future forecasts...
Can we do this for candlestick OHLC with 20 day ema
This was so helpful
Thank you! Please share and subscribe for me.
trying to replicate this and for some reason my new value is less than the previous? I noticed in Excel the forecast.ets formula is working but that's not accepted in google sheets - any ideas?
how can i achieve a similar result if my data is not in a regular interval?
When is your data available? How often?
Not working for some reason.. Looking by the comments, error must be something what I do wrong. Doing exactly what said here and getting formula parsing error immediatly when highlighting Y axis data. Other result from that formula is #N/A.
All simple numeric data and Sheets wrote graph and trends out of it without errors..
Sorry to say it, but you're doing it wrong.... You're basing your linear estimates on previous linear estimates instead of making them all based on the original data (autofilling the cells changes them - try looking at the range 5 rows down and seeing that it is adjusting your data range also). To fix this, put dollar signs on the row numbers for the 2nd and 3rd function arguments before you autofill. Hope this helps.
Awesome. Thanks for your help. I’ll try to confirm your comments and thanks for speaking up.
This is odd... I have a table with 24 entries on column A1:A24 which are dates, starting 24 months ago... My B1:B24 are values starting at 150,000 and then decreasing about 1,853 "every month" ... my formula on a separate cell, became =FORECAST(B25,B1:B24,A1:A24) but the result is a whopping 2867528.036 .. what gives ?!? Yeah, I can certainly just replicate the 150000-1853 and get a final value, but I wanted to see "Forecast" in action..... and like the weather forecast, it went wild .....
When you autodrag your C values arent starting at the top!
does not work at all what soever. google sheets is pure useless crap