By far one of the best project planner videos I've seen
@roccosims
4 жыл бұрын
Still using this wonderful tutorial. Had to re watch it as I messed up the version I have been using. Mostly all steps work in excel 365. Thank you very much
@CecilDSouza
7 жыл бұрын
Perfect demonstration, tempo, speech, articulation and subject matter. Presenting is an art. You need to speak well with no slurring or ah's, oos' , you know, like etc. How did you manage not to even mention any of them in your presentation?. Remarkable.
@tristangeoffroy9286
6 жыл бұрын
Hi, I like your comment. This is very noticeable, he is so good. Trying to do this exercice then you release how difficult to reach this level of profesionalism. I am impressed ... and jealous ;-)
@MatthewHurstFilm
8 жыл бұрын
Thank you very much for this excellent tutorial. Just thought I'd add that, at least with the latest version of Excel, you can complete the data label process automatically by selecting all data labels, right click, Format Data Labels, Label Options, Value From Cells, Select Range - then choose the 'Event' range. Thank you again
@NENAD1979J
6 жыл бұрын
Thanks for the Video clip! Forgive me for the intrusion, I would love your initial thoughts. Have you tried - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates minus the normal expense. Ive heard some pretty good things about it and my m8 after a lifetime of fighting got astronomical results with it.
@DelbertTritsch
Жыл бұрын
7:19 - This part may have been the best way at the time; but now and for my needs, I’m able to use “Value From Cells” to populate data labels from my table.
@raselsheikh9982
10 ай бұрын
Sir, can i ask you a question?
@dimaegorov931
8 ай бұрын
🎉cool Спасибо. Очень позновательно. Успешное решение для длится льного и детального планирования. Круто.
@launchexcel
6 ай бұрын
Yes, this template still works well after all these years. Thank you for your comment 😄
@flashtheoriginal
3 жыл бұрын
This is just superb. Thank you
@HelvioAlbuquerque
10 жыл бұрын
I was looking for a tutorial like this, but I didn't find, until find this video. Thank you so much, man. This steps are magical! Lol
@MrAapje1234
7 жыл бұрын
You are an excellent teacher! Creating a timeline like you showed me really helped me finish my graduation project and thus graduate from university. Thank you very much
@camo8723
9 жыл бұрын
Thank you so much for offering the free and the paid options.
@abhishekdwivedi1692
2 жыл бұрын
You are a genius. I would love to see more videos. Excellent work... 👍👍 I will share your videos with my friends and colleagues as well.
@launchexcel
Жыл бұрын
Awesome, thank you!
@masoudmoradi4258
4 жыл бұрын
very professional please continue
@mahansor8295
4 жыл бұрын
Thanks a lot, very informative ☑️
@shephardfamily
7 жыл бұрын
Thank you for this project list example. I had took Advance Excel in college years ago...but they did not teach us this... I have implemented and modified your examples to produce a more robust Project Chart.
@marmanlive
4 жыл бұрын
That is absolutely brilliant, thank you for sharing... it saved me and my team a bunch of manual effort...cheers!
@陈威正
8 жыл бұрын
Thank you for the detail steps. I will modify it to become a Gantt Chart.
@xfonnjunsiibohpcch8378
8 жыл бұрын
Try link www.instructables.com/id/Windows-Office-Key to got help.
@tristangeoffroy9286
6 жыл бұрын
Great tutorial, thank you very much. It makes me realise the value of Error bars graph...
@davidw1324
9 жыл бұрын
You did a great job in explaining this and showing this. Keep up the wonderful work.
@nerajenkins220
7 жыл бұрын
Brilliant thank you. I've used this to create my own Portfolio Plan!
@launchexcel
7 жыл бұрын
Glad you found it useful
@PavelAnatolich
9 жыл бұрын
Guy, you are very cool! I found the same what I looking for 3 months!!!
@TheBartoxi
6 жыл бұрын
Amazing. I'm "proud" of doing this. Thank you
@victorchan7768
6 жыл бұрын
Hey Bartoxi! I'm glad you did it.
@SylvexDragonskin
11 жыл бұрын
It looks amazing. Nicely done! You have a great voice for explaining things.
@avinsin
4 жыл бұрын
Thank you for this knowledge. This is really wonderful.
@launchexcel
12 жыл бұрын
Great! Thanks for your feedback and for telling me you like the video.
@Steviebrit
12 жыл бұрын
Superb, well done mate. Looked extremely complicated and you made it feel so simple. Thanks.
@jakejus1
7 жыл бұрын
Wonderful guide. Thank you very much.
@sreepriyadeepak9192
2 жыл бұрын
Really useful and clear instructions
@shananarocks
10 жыл бұрын
Thanks for this Excel timeline chart lesson. I was looking for a stacked chart and xy vertical timeline. Maybe needs a secondary axis. Will try this out example. Cheers!
@peterharbman
3 жыл бұрын
Thank you kindly!
@launchexcel
11 жыл бұрын
You're welcome kh. alid, I am glad that you found it useful.
@maxiway1661
4 жыл бұрын
Kudos for the video content! Forgive me for the intrusion, I am interested in your opinion. Have you thought about - Weydaniel Organized Dominator (do a search on google)? It is a smashing one off guide for getting 7000 plus project management and business templates without the hard work. Ive heard some great things about it and my cooworker at last got great success with it.
@ashokkandukury2870
5 жыл бұрын
I am curious about Risk , how can we project on to time line chart. Thank you for sharing such a great trick. Appreciate your help regarding 'risk'.
@vchan79
5 жыл бұрын
Happy to help :) you can find a write-up on how to add "At Risk" at my website. www.launchexcel.com/timelines-in-excel-bonus-2/ It's Idea 1 on that page.
@zopete
6 жыл бұрын
Thank you! this was very helpful.
@launchexcel
6 жыл бұрын
Hi M-Sid... I am glad you found my video very helpful. One of these days I want to create some new Timeline template videos... when I have the time!
@gerardoconnor4278
5 жыл бұрын
Superb. Excellent tutorial. Thank you.
@justlookat6199
3 жыл бұрын
Thank you so much sir.
@brianx4264
6 жыл бұрын
Thank you for posting this video. I found it very useful. Only one problem: why my error bar for positive value and negative value are pointing to opposite direction? is there a way to fix that? thanks!
@juliajoyes1595
9 жыл бұрын
Great timeline template. How is it possible to insert new tasks whilst keeping the already present tasks consistent with their dates etc?
@manvanstaal99
12 жыл бұрын
Thank You. Thank You. Thank You. You were lost of help!
@aaronlowrey7302
2 жыл бұрын
Is there a way to use this scatter plot method to highlight the weekends as well for visibility?
@7346908
Жыл бұрын
You are awesome!
@urckuwait8776
7 жыл бұрын
thank you so mush I was able to do it all - but can you please advice how to do the RISK part?
@tungstenmercury
9 жыл бұрын
This is brilliant. Thanks :)
@ChinookMedical
10 жыл бұрын
Your video mentions that the template is available for free on your website, but I only see one option to buy it for $25. Is it still available for free?
@TheShephardFamily
7 жыл бұрын
Thank you so much!!!! This was excellent!!!1
@launchexcel
7 жыл бұрын
Thank you for the feedback. Very happy to hear you found it useful! By the way, in case you are interested I just started teaching Macros and VBA in Excel on this channel. This is a powerful skill-set that few Excel users have, and I decided to help beginners learn Macros and VBA in a friendly way. You can see the first video here: kzitem.info/news/bejne/1Zto1Y2vjZ9pim0 There's also a free e-book download - link is in the first Macros video (kzitem.info/news/bejne/1Zto1Y2vjZ9pim0) Thanks!
@manishagrawal417
8 жыл бұрын
very nice.. Can we add more details to show up under each bar, like total cost incurred in each task, etc, etc? how ould we do that?
@manishagrawal417
8 жыл бұрын
As soon as I typed my question, I got the idea on how to do it. It is very simple. Just add the data in the table first varying the dates and heights as where you want the marker to show and then change the data table to show the desired text..
@michelb96
8 жыл бұрын
hello, would you recommend your timeline Video for making a historical timeline? Because my historical timeline Needs more single-date Events and also Long-time Events. How should i do that?
@vlatkaMP
11 жыл бұрын
Amazing tutorial. Thank you! I've created my timeline using your video. Is there a way to adjust the x axis label to show only month/year of the beginning of some (or all) phases? Now it shows "random" dates of timeline according to major units, but it would be more informative and easy to follow for readers of chart to be able to have only important dates in the axis of timeline.
@muntasiriub
5 жыл бұрын
Excellent....Can you share a link to download ?
@rahulsurwade181
7 жыл бұрын
This is awesome dude .....superb one
@dompatrick8114
2 жыл бұрын
thanks
@mimpaps5913
4 жыл бұрын
How do you annotate in excel (10:25 in your video) or was that done during the video editing?
@ricme1281
4 жыл бұрын
Students are sometimes overwhelmed by tons of assignments and homework. The assignments from the school’s coursework’s may even be a thorn in the foot for the students to even work and live comfortably. If you are a student who is stuck with your homework or assignments, essays, thesis, research proposals and any other, please feel free to hire competent writers from acemywork.com/, which is an online assignments writing page. The experts from Acemywork.com guarantee you quality work free of plagiarism. Make order today and feel free to contact us. We have the best writers to take your #fall semester online classes for you. #fall and summer classes #Essay due #Homework help #Case study #Do my homework #Online class #essaypay #English class #Math #pay assignment #homework #essay write #essay help WhatsApp +1 213 328 1712 Make order at acemywork.com/
@michaelng755
4 жыл бұрын
Excellent! where can I get free version?
@raselsheikh9982
11 ай бұрын
If start date and close date available, what will i do? Plese suggest
@stefanieacat
10 жыл бұрын
Thank you ,very helpful
@KariRaquel14
7 жыл бұрын
you are awesome, great help!
@JudyN904
4 жыл бұрын
how do I add rows to the data without disrupting the whole chart? Do I have to reformat everything?
@asadjaved9431
7 жыл бұрын
v nice, dear r u available for online excel course?
@launchexcel
7 жыл бұрын
Hi Asad, I am currently creating an Excel course on Macros and VBA for beginners. If you (or anyone reading this reply) wants to get started with recording a Macro you can check out this new video plus free e-book download link: kzitem.info/news/bejne/1Zto1Y2vjZ9pim0 Thanks!
@volkennes
11 жыл бұрын
wow, thanks for your instruction
@honghanguyen2879
6 жыл бұрын
Great. Thankyou so much.
@tarekahf
11 жыл бұрын
Wow! Very good video.
@Daiv1341
Жыл бұрын
I really wanted this to work for me, but the "absolute" references of the diagram labels to the table cells become a mess when you insert a new row in order to add another task to any particular phase. It becomes a big chore to re-establish the correct linked references. Love the look, but Its really a "one-shot" Gantt chart with limited scalability.
@allabout1135
5 жыл бұрын
Thanks!
@raulsansores6271
8 жыл бұрын
Great Job !!!
@AbdielLorenzo
12 жыл бұрын
magnifico video me gusta
@hiepng8940
4 жыл бұрын
Hi, How Do I display the percent as a label for green error bar?
@juliezepeda5716
8 жыл бұрын
Thank you for this!
@calvindo6191
10 жыл бұрын
Hi, I have your template (thanks!) but I want to change the dates into 1 month formats instead, like 1/1/14, 2/1/14 so it shows the project progressing in a monthly progress within a year. Is there anyway I can change that on the chart? Thanks!
@simi957
9 жыл бұрын
Thanks for the tutorial.. I need help. I am working on mac and followed every step precisely, when i select a data to enter For series name select E30 (“Duration”) For Series X values select C33:C46 (“Start Date”) For Series Y values select H33:H46 (“Height”) and entered it didn't mention dates and entries was not same as yours its like zigzag. when i followed till end it was mess. like today redline is breaked. Please tell me how to fix it? i m using mac
@pannahazarika
11 жыл бұрын
The training video is great. Unfortunately, your web site has problems. When I signed-up (several times), it did not send me the confirmation email, and I could not download the template!
@marmanlive
4 жыл бұрын
One problem though, when I change the Start Date it moves another data point (diamond) across the timeline, though the reference external link is shown as correct, can you please help to figure this out??? This refers to lines with negative Height values, under the X axis.
@nguyencongquan4514
11 жыл бұрын
How can I download Template? I go to your link but I'm unable to download it. Plz, give me the link
@theponsway
4 жыл бұрын
I want to add specific colors to each task to color-coordinate them, but once I start filtering the colors always get mixed up :( Any ideas how to solve this problem? :(
@7sab6
3 жыл бұрын
As soon as I go to add data to add the red dots, the whole graph condenses so that all points are on the same Y axis.... ????
@salifdiallo9945
9 жыл бұрын
Extraordinaire
@huongang535
9 жыл бұрын
Hi. Can I ask for At risk/ Delay part in this chart :(
@PetarLiovic
9 жыл бұрын
which are all parameters of the table. not really see the end of the right. And what does this mean "series1,2 ..." Thank you a lot for this
@DrLTamor
11 жыл бұрын
I know I'll be using this!
@launchexcel
12 жыл бұрын
Glad that I was able to help lots.
@sebmlts7437
7 жыл бұрын
Hi, I would like to create a timeline with BCE dates. How can I do it on excel?
@MiguelGarcia-ps2mh
4 жыл бұрын
I want to buy the timeline template, thanks
@JosePerez-rt1kb
4 жыл бұрын
Miguel Garcia, Great Video clip! Sorry for butting in, I would love your thoughts. Have you researched - Weydaniel Organized Dominator (search on google)? It is a good one off product for getting 7000 plus project management and business templates without the hard work. Ive heard some super things about it and my work buddy after a lifetime of fighting got great results with it.
@bayakuyakucki5535
8 жыл бұрын
please can you help i cant have the dates displayed on x axis even though i am doing all things your are telling in the video on x axis it keeps displaying 2,4,6,8,..... anso on till 16
@NavneetDwivediELearninghub
6 жыл бұрын
Bayakuya Kucki kzitem.info/news/bejne/kWOBtJaLhYWlgZw kzitem.info/news/bejne/laCN13p-bnqrl2k Check this...it might b helpful too...
@Dr.SariHamoud
6 жыл бұрын
Thanks a lot
@kerri-annemak7691
4 жыл бұрын
Can someone help me? When I add my dates to the x axis, they change completely. I want to input each month from January - December 2020, but when I do, the months change and the years change. They aren't the same as where I selected them from.
@chandramanik755
11 жыл бұрын
Great, Thank you
@dannyjhoelgarciasegura5223
7 жыл бұрын
excelente
@y.natsarim
12 жыл бұрын
How do I get the step by step details to creating this timeline in excel?
@heregoesnothing7
2 жыл бұрын
Hi! I cannot open any of your links. It just keeps downloading
@DaronMoore1
11 жыл бұрын
I was unable to download the template. Is there a new link I need to go to?
@friendlyoutlook4167
4 жыл бұрын
Hi, I am not able to open the suggested site (www.launchexcel.com) from any of my devices. Has the website address changed?
@chandramanik755
11 жыл бұрын
Exellence, thank you.
@gifgif638
11 жыл бұрын
salute, I appreciate it.... Thank you very much :0)
@nguyencongquan4514
11 жыл бұрын
Pleaze Sir, can you introduce me to make At Risk in project timeline?
@r0b1
5 жыл бұрын
I need help, the "negativ" error bars is going to minus basicly, how i turn reverse?
@gopalashetty6405
5 жыл бұрын
Your English accent is too good. May I know where is this from.
@launchexcel
5 жыл бұрын
Hi Gopala Shetty - thanks for your comment! I grew up in London and studied in Cambridge. I guess that's where my English accent comes from. Hope you enjoy my other videos!
@gopalashetty6405
5 жыл бұрын
@@launchexcel thanks I subscribe your channel. If you make videos on Primavera P6 and MS Project please upload.
@wellsuz2
4 жыл бұрын
I am using the last version of Excel, When I click to include the new series for the actuals, all the data goes to the left
@abrahamcheung
5 жыл бұрын
intelligent!
@CHIMICHANGA-d6i
8 жыл бұрын
I'm using excel 2013, followed your steps but i got different result.
@jaimeizquierdo3355
9 жыл бұрын
What about RISK Graph ???
@wilfredderksen
4 жыл бұрын
Since yesterday the website of launchexcel.com is gone. :-/
@sergioordonez3529
6 жыл бұрын
from Australia?:D
@ajayjoshi2408
5 жыл бұрын
there is no sample template of excel is attached. where as you are claiming can download on given link. pls dont mislead people
Пікірлер: 167