Project Timeline/Milestone Chart in Excel

Поділитися
Вставка
  • Опубліковано 25 сер 2024
  • Hello Friends,
    In this video you will learn how to create a project Timeline/Milestone Chart in Excel
    Please download this excel file from below given link:
    drive.google.c...
    Watch the best info-graphics and dynamic charts from below link:
    • Dynamic Graphs
    Learn and free download best excel Dashboard template:
    • Excel Dashboards
    Learn Step by Step VBA:
    • VBA Tutorial
    Facebook:
    / pkan-excel-expert-9748...
    Telegram:
    t.me/joinchat/...
    Twitter:
    / priyendra_kumar
    Send me your queries on telegram:
    @PKanExcelExpert

КОМЕНТАРІ • 113

  • @dionejessicaa
    @dionejessicaa 2 місяці тому +1

    Thankyou so much! Very helpful in simple way!

  • @user-bv1xb4xd7o
    @user-bv1xb4xd7o Рік тому +1

    Great Video

  • @dylanmaher6458
    @dylanmaher6458 2 роки тому +1

    Very helpful

  • @magalihall7518
    @magalihall7518 Рік тому +1

    Your instructions in the video was clear and concise. This really helped me out. Thank you!!

  • @swapnajare5560
    @swapnajare5560 2 роки тому +1

    You're a fantastic teacher, sir. Very clear step-by-step instructions. Thank you.

  • @robblaze08
    @robblaze08 Рік тому +1

    You are REALLY GOOD!!! I just followed you step by step and IT WORKED. Thank you!

  • @kfossi1986
    @kfossi1986 Рік тому +1

    Great video.

  • @user-zg3zn5ne3p
    @user-zg3zn5ne3p Рік тому +1

    Thanks a lot boss

  • @allisonkelsey59
    @allisonkelsey59 5 років тому +1

    Thank you for the simple approach to solving this problem. Many of the other avenues I explored were overly complex - thanks for sharing this!

    • @71javer
      @71javer 4 роки тому

      Cheers for the Video! Excuse me for chiming in, I am interested in your opinion. Have you heard about - Weydaniel Organized Dominator (erm, check it on google should be there)? It is a great one of a kind product for getting 7000 plus project management and business templates minus the normal expense. Ive heard some decent things about it and my mate finally got cool results with it.

  • @abasalifarah2108
    @abasalifarah2108 2 роки тому +1

    I really searched for a long time to create the same chart, and I didn't find any until now, thanks, bro.

  • @foo_swan
    @foo_swan 2 роки тому +1

    Very detailed instructions!! Thanks a lot !!!!

    • @PKAnExcelExpert
      @PKAnExcelExpert  2 роки тому +1

      Most welcome

    • @foo_swan
      @foo_swan 2 роки тому

      @@PKAnExcelExpert sir is there a way to plot two milestones on same date with + and - values at same point? In my chart it shows two separate data points

  • @ivanm9759
    @ivanm9759 6 років тому +1

    Hello. Thanks for the video. Another tip for position 11:20 (in the video) is that you can manually select the data labels and then go to the "data label format" and select below position

  • @nursyahidahnoormohamed8460
    @nursyahidahnoormohamed8460 2 роки тому +1

    thank you so much ! very clear explanation and easy to follow.

  • @piyushmishra2167
    @piyushmishra2167 4 роки тому +2

    Very well explained, solved my problems

  • @kejgonjames7201
    @kejgonjames7201 4 роки тому +1

    Thank you for sharing your knowledge ..

  • @michelecrook46
    @michelecrook46 4 роки тому +2

    This was extremely helpful! Really, a lifesaver, thank you!!

  • @bricc322
    @bricc322 6 років тому +1

    Beautifully orchestrated, as always. Thank you, PK!

  • @davidqquintero1843
    @davidqquintero1843 4 роки тому +1

    Thank for you the video, very helpful.

  • @14IEA
    @14IEA Рік тому +1

    excellent video my friend!

  • @chromaenterprise8514
    @chromaenterprise8514 4 роки тому +1

    Great! saved my life today!!!

  • @DineshKumar-ur3fh
    @DineshKumar-ur3fh 4 роки тому +1

    Thank you ji. Explained very well

  • @skillcenter4828
    @skillcenter4828 2 роки тому

    Thanks Dada. It's helpful.

  • @faizanhaqqi8322
    @faizanhaqqi8322 5 років тому +1

    thank you Sir!!!! I am preparing timeline for my meeting tomorrow using this. Awesome!!!!!

    • @PKAnExcelExpert
      @PKAnExcelExpert  5 років тому

      Thanks for your valuable feedback

    • @vladimirbeslic1713
      @vladimirbeslic1713 5 років тому

      Lovely Video! Excuse me for butting in, I would love your initial thoughts. Have you heard the talk about - Weydaniel Organized Dominator (search on google)? It is a good one off guide for getting 7000 plus project management and business templates without the hard work. Ive heard some awesome things about it and my cooworker got amazing results with it.

  • @coachingchannelforyou177
    @coachingchannelforyou177 4 роки тому +1

    Very Excellent and Useful

  • @tiyefeyisa2535
    @tiyefeyisa2535 4 роки тому +1

    Thanks so much it really helped when i was struggling.

  • @menuherath3022
    @menuherath3022 3 роки тому +1

    Thank you so so so much!!! Was so helpful for my project. ❤️❤️

  • @jevclade82
    @jevclade82 2 роки тому +1

    Awesome, thank you!

  • @gigis7479
    @gigis7479 3 роки тому +1

    Thank you.. really helpful

  • @paulramasco6769
    @paulramasco6769 Рік тому +1

    This was excellent, thank you!

  • @kathyheil29
    @kathyheil29 5 років тому +2

    Thank you so much, really helpful

    • @PKAnExcelExpert
      @PKAnExcelExpert  5 років тому

      Thanks for your valuable feedback. Please share it with your friends and colleagues.

  • @chavanakornsawaschai1167
    @chavanakornsawaschai1167 3 роки тому

    Thank you very much, Sir. This helps me a lot. In order to display the milestone tasks with creativity is this video perfect. Really apreciate this useful lesson. :)

  • @gayethrimuthusamy8741
    @gayethrimuthusamy8741 3 роки тому +1

    Tq so much 😊 it's really helped me alot

  • @yubelinruntuboi7360
    @yubelinruntuboi7360 5 років тому +1

    Thanks you very much, it helps me 🙏🙏

  • @robertasergnese7195
    @robertasergnese7195 3 роки тому +1

    Thanks a lot :)

  • @verticom1
    @verticom1 5 років тому +1

    very nice..... thanks.

  • @Adam_K_W
    @Adam_K_W 4 роки тому +1

    Well done.

  • @dhiyauddinesa217
    @dhiyauddinesa217 4 роки тому +1

    Thank you

  • @صقر_الجزيرة
    @صقر_الجزيرة 3 роки тому

    excellent work and I hope to see more from you soon :)

  • @rschultz7141
    @rschultz7141 3 роки тому +1

    Very good but can't you make the line scale by the date. You used a even interval so that looks good but if your milestones are not even intervals they should be shown on a timescale.

  • @g16565
    @g16565 4 роки тому +1

    Awesome.. Extremely helpful.. Great Job.. keep it going.. :-)

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 5 років тому +1

    beautiful

  • @Oli_Planet
    @Oli_Planet 5 років тому +1

    thank you

  • @theoklingels3058
    @theoklingels3058 6 років тому

    thanks for very useful and easy timeline in excel

  • @yamin207eb
    @yamin207eb 6 років тому

    Thank you PK.

  • @sreejarathish
    @sreejarathish 10 місяців тому

    Is thre a way to give coditional colors for the error bar?

  • @deviprasadsemwal
    @deviprasadsemwal 6 років тому

    Thanks lot

  • @luan0936
    @luan0936 5 років тому +1

    thank you Sir

    • @PKAnExcelExpert
      @PKAnExcelExpert  5 років тому

      Thanks for your valuable feedback

    • @sergeydzema5569
      @sergeydzema5569 5 років тому

      Thanks for the video content! Excuse me for chiming in, I would appreciate your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (do a google search)? It is a good one of a kind product for getting 7000 plus project management and business templates minus the normal expense. Ive heard some unbelievable things about it and my buddy after a lifetime of fighting got cool results with it.

  • @joses.pacheco3069
    @joses.pacheco3069 6 років тому +1

    Sensacional.

    • @freemusic7421
      @freemusic7421 6 років тому

      Jose S. Pacheco Thanks for the Video clip! Apologies for the intrusion, I would love your opinion. Have you researched - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a smashing one off product for getting 7000 plus project management and business templates without the hard work. Ive heard some interesting things about it and my work buddy after a lifetime of fighting got great success with it.

  • @balazsbatta575
    @balazsbatta575 3 роки тому

    Thank you so much. It helped me to create Timeline/Milestone chart for multi projects. I have only one problem. When I change the project code with the slicer, sometimes the bar chart is reset. Do you have any idea why and how I can fix this?

  • @stc.asif1
    @stc.asif1 2 роки тому

    Its great 👍 and simple i really appreciate your efforts 💐
    Please let me know how do I add end date or another Milestone in this time line that has data labels 🏷 too ?

  • @goalisticfaz
    @goalisticfaz Рік тому

    I was hoping the milestones to move left and right if we change the dates, but unfortunately they dont

  • @jatinpatwal5677
    @jatinpatwal5677 4 роки тому

    What does it mean when someone says they need • bookings, savings, and forecasted revenue data in order to create a historic and future chart of revenue, bookings, and savings .
    I have the Booking revenue & savings data...but not sure if this is all required in 1 chart or 3 different charts.

  • @cheetah703
    @cheetah703 4 роки тому +1

    how can I remove the old values from the sheet (highlight and Line Chart) ??

  • @krishnamurthyhunagund1049
    @krishnamurthyhunagund1049 6 років тому

    Very nice video

  • @abhigupta9727
    @abhigupta9727 4 роки тому

    this is good . thank you ! One question - what software have you used to create this video ?

  • @EnhantedSaber
    @EnhantedSaber 6 років тому

    Possible to have the vertical lines end with an arrow design instead?

  • @vimalaramasamy7865
    @vimalaramasamy7865 3 роки тому

    Nice, how input plan timeline and actual in the same chart?

  • @sumittripathi2461
    @sumittripathi2461 6 років тому

    Hello sir nice video can we make map in excel with particular data plz make a video for interactive map thanks in advance

  • @qus.9617
    @qus.9617 5 років тому

    Ah im such an idiot, you already had a turnkey solution share link. Many thanks.

  • @pawansharma-wo3xh
    @pawansharma-wo3xh 6 років тому

    Excellent pk!!!!!
    Can you post a tutorial on excel on line collaboration....

    • @PKAnExcelExpert
      @PKAnExcelExpert  6 років тому

      Thanks for your valuable feedback. I will definitely try to make such video very soon

  • @rahildesai6286
    @rahildesai6286 6 років тому

    i dont see the plus element on my thing

  • @thendralarun7419
    @thendralarun7419 4 роки тому

    Thank you, nice and simple explanation. i want to add link in the roadmap (Hyperlink) can someone please help me?

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 роки тому +1

      Thanks for your valuable feedback. I will definitely try to make such video very soon

  • @share4824
    @share4824 6 років тому

    Hi, How i can do the same in google sheet

  • @juanez8
    @juanez8 6 років тому

    What is the name of the music you use?