hi Friend, regarding Estimated Trajectory. I use Office 365, my solution is using at cycle 1 =SUM($B$14/12), the next cycle onward is =SUM($B$14/12)+E3. basically is (Total Project Point/12) + the previous Total Project point (from the previous cycle).
Very helpful! Great walkthrough. The Est. Trajectory null formula didn't work for me, so I just used a manual formula =$E$14/12 and copied that down and looks like it helped.
@@DougHExcel ive done everything right, but when I create the chart, the line which shows the estimated projectory isnt there, it only has 2 points, one at the 0 and another at the end value, so technically it did work but the line just isnt there
Coming through 9 years later. Needed to do this for college. You're saving me a lot of time lol.
Thanks for the Burn Up!!!
Gracias! Sencilla y clara explicación :-)
De nada. Gracias por el comentario!
Thanks for the tutorial. Easy to understand.
Hi curlycalynna, glad you liked it, thanks for commenting!
Thanks a lot Doug. Tutorial is simple yet very informative. Hats off
Glad it was helpful!
Perfect, thanks!
hi Friend, regarding Estimated Trajectory. I use Office 365, my solution is using at cycle 1 =SUM($B$14/12), the next cycle onward is =SUM($B$14/12)+E3. basically is (Total Project Point/12) + the previous Total Project point (from the previous cycle).
Thanks It helped me to my project!
Hi Carlos CB, glad you liked it, thanks for commenting!
I am not getting the line for Estimated Trajectory. It just shows 2 dots at the start and end on the line.
parul sah, that is very interesting...thanks for letting me know...haven't seen that...may want to try again from start
@@DougHExcel mee too not getting line for estimated trajectory
use hidden and empty cell settinga and select optionconnect data points with line
Very helpful! Great walkthrough. The Est. Trajectory null formula didn't work for me, so I just used a manual formula =$E$14/12 and copied that down and looks like it helped.
Hi Garrett Jow, thanks for the comment!
very useful. I don't know why i'm not seeing dotted lines for estimated trajectory. am i missing something
Great
Hi Hussein Ali Hussein, thanks for the comment!
Not great for people who don't use Excel a lot, but good enough to get what's needed
Hi Mike Tapio, thanks for adding to the thread!
the estimated projectory line doesnt show when i make the chart
Sorry, don’t understand the comment/ question... but you may want to recheck the steps on watching the video again
@@DougHExcel ive done everything right, but when I create the chart, the line which shows the estimated projectory isnt there, it only has 2 points, one at the 0 and another at the end value, so technically it did work but the line just isnt there
I am having same issue,probably the version of excel that is on my machine,although i added linear trajectory option. Thanks for the tutorial.
@@DougHExcel Hi Dough the dotted estimated trajectory line doesn't show when we make the chart
Are the scope points always a cumulative number of task hours or can they be the total amount of time from start to deadline?
Thanks for the great tut. How would you act when you get extra tasks?
Increase/Insert the sprint and readjust values as needed.
I use excel 365 and # N/A didn't work out, which function can I use to create Estimated Trajectory
maybe a forecasting application? th-cam.com/users/dough517search?query=forecast
we have use hidden and empty cells setting and select connect data points with line