Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)
Вставка
- Опубліковано 28 лип 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Excel Gantt Charts are great for project planning. They help you schedule your project tasks and keep track of your progress. In this Excel tutorial you learn to create a complete Gantt chart that includes Project Plan & Actual in one view. We also add the project progress bar for each task so we can keep track of percentage completed. You can also download the Gantt Chart template from the bottom of the blog post below and update according to your project plan.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/gantt-chart...
🔍 What You'll Learn:
- Crafting a Gantt chart that shows actual vs. planned timelines.
- Techniques for including percentage completion within the chart.
- Advanced Excel functions like Workday and error bars for dynamic data visualization.
👨💼 Perfect for:
- Project managers and planners seeking advanced Excel charting skills.
- Excel users interested in detailed, dynamic data representation.
- Anyone who wants to step up their Excel game with complex chart types.
📌 Key Highlights:
- Integrating planning and actual data in a single Gantt chart view.
- Utilizing Excel's error bars for creative data display.
- Dynamic updates to the chart with real-time data changes.
💡 Elevate your project presentations with this detailed Gantt chart tutorial. Perfect for tracking progress and planning with precision!
LINKS to related videos - Quick Gantt Chart: • How to Quickly Make a ...
Fully featured Gantt Chart: • How to Make a Gantt Ch...
Corporate report makeover playlist: • Corporate Report Makeover
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Grab the file I used in the video from here 👉 pages.xelplus.com/gantt-chart-project-file
Super clean and readable gantt chart EVER ! Thank you so much and can see how much effort you've put to create this chart!❤️
Glad you like my version!
I'm a visual person an this is exactly how I want to see how projects are progressing. A quick wham bam and mind blown.... Thanks so much for helping my project management skills get raised to the next level.
Another good lesson, job well done. You are always forever remembered.
Thank you so much.
It's been 4 years since I've been (I hope) an advanced Excel user, and I've never find a UA-cam channel with both so awesome tips & tricks and high quality in its videos.
In 2017, for my work, I've realized a tool on Excel for Project Management. I think I did a good job, but about the Gantt Charts I was not so satisfied. Then I changed company and I left the project in a folder without having time to perfect it. In the next few days I need to resume the project and seeing your video in UA-cam home gave me a lot of great ideas to complete it.
Thanks a lot and keep up the good work!
Thanks for the kind feedback Daniele. I'm glad I can provide some ideas for your own project.
Way to think outside the box! Or in this case, inside the graph box. I'm so glad I subscribed to your channel. You're truly innovative with how you combine the available graph functions with the data in all your videos to maximize the presentation. Now when I hear someone claim they're an excel expert, I'll ask if they heard of Leila Gharani, if not, then they're no where close to knowing what excel can possibly do. Keep up the amazing work.
Wow, thank you for the kind words 🙏
Lovely Video clip! Forgive me for the intrusion, I am interested in your initial thoughts. Have you researched - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a great exclusive guide for getting 7000 plus project management and business templates without the headache. Ive heard some super things about it and my cousin finally got great success with it.
Kudos for the Video clip! Sorry for the intrusion, I would love your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (do a search on google)? It is a good one of a kind guide for getting 7000 plus project management and business templates minus the headache. Ive heard some amazing things about it and my good mate called Gray at very last got great results with it.
You have saved my life...thank you so much Leila...awesome work!
Great tutorial! This was exactly what I needed for my project! Thank you!
I've been working with Excel for thirty years, and I've built planning matrices which try to do a similar thing, but this simply amazed me. I don't think I've ever seen a clearer explanation of something so stunning from the rather clunky basic features in Excel. You are some kind of mathematical angel, a kind of 21st century Ada Lovelace. Thanks so much!
Is there a way of making a chart, say with 4 series, where each of the series contains a set of labels and numbers which are different in each series? With all the breakdowns of each series simultaneously showing?
People often use colored cells and stuff to show progress in Excel, but this is dynamic and user-friendly. I love the video! Thanks!
My pleasure Patrick. I'm glad you like the video.
Hi Leila, thank you for the amazing work you do. 🙏
You never stop surprising! Moreover, I tend to find ways of implementing your methods into my work and they're really useful! Thanks a lot :)
You're very welcome. I'm happy if it's applicable to your work.
Holy moly! Did not think this is even possible with Excel.
Glad you like it.
I'm always blown away at how good your tutorials are.
Thank you for the kind words David.
Congratulations! Perfect job! Thank you!
Many many thanks to you Leila. This is immensely helpful. Keep making such videos
That error bar trick is brilliant!
Error bars are totally underrated :)
Throwback in time now from 2022, thank you very much Leila for your help.
I cannot say how much is appreciated your work. It can be easily seen how much you dedicated, even for this simple task of Gantt Chart in that page of your website, how much detailed and also here so well explained..I must say it's so great and you are really good.
Thank you! 😃
Your efforrs are always highly appreciated...
I'm glad to hear that :)
Quite helpful. Thanks for sharing your knowledge!
I've been working in project management field for more than 12 years and I confirm this was AWESOME!!!
Good to hear, thank you!
Pure genius. Took me for-ever to get it right and working, but eventually got there. Many thanks for taking the time to put together this comprehensive tutorial on a very complex topic. Extremely helpful and useful!!
Glad it worked out!
Thanks Leila for these many videos... Loved it...
Wanted to learn how to do this for a long time. Great video! Will really help me with time management for projects in school.
I'm glad the tutorial is helpful Rasmus.
What a great video, thank you so much! I just have a question, can you do the same chart but displaying Quarters and years instead of actual dates?
Thanks Leila, so useful! I needed to track projects in a portfolio and show if they had been extended past the approved end date. A bit tricky but I got there in the end.
That's great Dianne. I'm glad you could apply it right away.
No words to say... you are really great ..
There's always a way in excel to do anything.. loved it ...
Like they say: If you can think it, you can do it :)
Vielen Dank Liebe Leila,🤗
I have used your previous gantt charts, and this is so sophisticated. I love all your charting techniques. ❤️
Viele liebe Grüsse 🤗
Danke, liebe Katerina! 🤗
Excellent Leila! Some years ago a company I was working for spent a small fortune on software for project planning and it was useless. We wasted time learning how to use it and then putting in data, and it never really did what we wanted. The comments below should bring a smile to your lips - you are really appreciated!
They definitely do George!
This is great! Will use this as a production planning tool. Thanks!
My pleasure. I'm glad it's useful.
This Gantt chart series is amazing, appreciate your videos definitely have learned so much from you
Glad you like them!
Great explanation! Excel can do it all! Except good coffee and calculate correctly. Looking forward for November!
😂
This really helped me! Thank you :)
Great Gantt Chart. The vertical Line marking Today is absolutely fantastic. Thanks Leila. This is very helpful.
Glad you like this version of the Gantt Chart!
the best tutorial ever. she's the best
Lovely Video! Sorry for the intrusion, I am interested in your initial thoughts. Have you considered - Weydaniel Organized Dominator (do a google search)? It is a great exclusive guide for getting 7000 plus project management and business templates minus the headache. Ive heard some great things about it and my mate after many years got cool success with it.✅
Thanks for the video content! Sorry for the intrusion, I would love your opinion. Have you heard the talk about - Weydaniel Organized Dominator (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 super things about it and my cousin got great success with it.
Hi Leila, I would love it if you added a scroll bar to the Gantt chart view, via a how-to video. Thanks and keep up the fantastic work!
Speechless! Thank you.
Wow! This is so easy to follow. Thank you so much! 😍🥰🤩It really helped me in our division roadmap.
Thank you for doing this!
Thank you, it is a lifesaver, you are an Excel god!
Very useful tutorial. Great work Leila. Thanks
Perfect!!! Congratulation on your excellent work!
Super like !!!! This is exactly what I was looking for. Many of my team members do not have MS Project and I often need to show them the project progress in excel. This uses a really weird method of bars + scatter plot to achieve the plan vs actual chart ! Out of the box thinking !
You're very welcome!
Hi Leila.. great video. Love the chart tricks and hacks to get the EXCEL charting engine to produce your results. Very creative and impressive. Always something new and fun to learn from your channel. Thanks and Thumbs up!
Thank you for the kind words Wayne.
This is by far the best gantt chart I ever found for Excel.... Fantastic work and thank you very much for sharing!
Wow, thank you Sergio!
Ain't she the best guys...simple step-by-step instructions even I can understand :).
This video taught me so much, thank you
Thx for sharing. Loving it.
میدونی چیه؟ شما فوق العاده هستین. واقعا بهترین آموزشهای اکسل هستش که به عمرم دیدم.you know what? YOU ARE AMAZING . The best excel training vids ever seen, and trust me I have seen a lot
Aw, thank you! I'm glad you like my videos.
Wow impressive!! Gonna learn it later
I just want you to know that I started a new job today and they asked me to put together a timeline chart using Planned and updated timing with two bars for each task and your video saved me. Thank you very much.
Very useful... nice presentation... appreciate your work. THANK YOU VERY MUCH!
My pleasure. I'm glad the tutorial is helpful.
Super useful! Thank you.
Always creative Queen of Excel , thanks Leila
Trying my best :)
It was extremely helpful..Thank you !!
Great video, as usual, thanks for sharing. It's full of inspiring tips, my favourite one: error bars customization :)
Just what I needed. You're fabulous!
Glad you like it Marlon.
This video was so helpful! Thank you for making it so easy to understand
You're so welcome!
Superb u are.. I got my issue solved.. Love ur skills.. I struggled today a lot to show planned and actual in same chart but tried with stacked bar only.. Good 💡 to use scattered..
I did implement the former solution with the Actual or Plann-dropdown - but this is so much cooler. I could - though - suggest an option for the dateline, so I could present the progress by choosing the Gantt for last meeting and then the progress as it is today. Also - for the presentation - an option for "rolling out" the lines still in progress one at a time ... :). Also I back up What the Hmmm wants - because userfriendliness. But still - I love it.
Wow..... Just wow...
Brilliant! Thank you very much!
My pleasure Filippo. Glad you like it.
That's brilliant! Thanks for sharing!
You're very welcome Jean-Luc.
Thank you very much, I learn so much from you
Great tutorial. Thank you. Can you add milestones to this as well?
Amazing!
Awesome video. Thank you Leila.
You're very welcome Arnaud.
bit convoluted but masterful in the end. I am impressed again, Leila. thank you
Glad you like my version.
Love it. Thanks!!
My pleasure. I'm glad you like it.
Followed along and works like a charm... Great vids and tutorials...!
Great to hear!
Hi Leila … thank you for the lovely presentation … how about the relationship between task? In case some task is dependent on other?
Hi Leila, Thank You for the amazing work you do. I really appreciate your work as i have learnt a lot from your videos. I am creating a maintenance schedule for the 3 years. I have equipment names in column A, type of equipment in column B, and the various frequencies of maintenance per machine i.e., daily weekly, monthly, after 2 years etc. in column c. on column D I have the start date for each equipment. from column E up to APG are dates for the years starting 1/1/2022. I am looking for a code or a formulae that will mark an "x" corresponding to a date based on the maintenance schedule on column B. Also if you change the schedule on B e.g. from daily to weekly the "x" will change appropriately on the cell corresponding to those dates. Thank You In Advance
Thanks Leila. Very inspiring
My pleasure Robert. Glad you find it inspiring.
You are awesome!!
Thx a lot...a much needed output...
I am not a fan of Microsoft square bar when drawing tasks. Been trying to find a way to implement the rounded bar in Excel but to no avail. Thanks to your tips and tricks I am now able to implement the rounded bar throughout the whole project. Instead of using the stacked bars chart for the actual and progress, I use the technique that you share with the scatter chart. Once again thanks so much Leila
Seems like i have to learn this too. I thought i was done with project management toolset. Thanks Leila for dedicating your time
I hope it will be useful for you.
Absolutely Helpful video and a very clean gantt chart
I'm happy you like my version.
@@LeilaGharani yes thx alotttt
You did great work thanks
This is brilliant, I don't even need MPP for the regular project plans, plus the visuals are much better.
I'm glad the tutorial is helpful.
Elegant - great solution with many useful tips included as always! :-D
I'm glad you like it Christian.
Really creative, and excellent tutorial!
Glad you like it Hubert.
This is magic!
Thank you leila.
You are the best thank you so much
Very nice teaching, with beautiful toune, love you...
Glad you like it.
Aww thank you this is useful. If i can't make req, im a beginner and still learn how to make chart like schedulling assistant in outlook calendar.
Kudos for the Video clip! Forgive me for butting in, I would love your thoughts. Have you tried - Weydaniel Organized Dominator (search on google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates without the normal expense. Ive heard some decent things about it and my mate at last got great success with it.
Leila, you are a genius.
Great tutorial! Thank you. Can you make another one using google sheet and includ milestones? Very apreciated!
Leila you saved my life so many times.. what a great video and presentation
My pleasure, Jason!
Excellent.. Good thinking and good work
Superb Video with clear /concise instructions. Thanks
My pleasure James. Glad it's useful.
this is next level! thanks.
My pleasure. I hope it's useful for you.
Simply awesome
Good video, do you plan on creating another reporting class on Udemy? If so I’m ur first student
Next video creating this in BI
Thank you Leila, great video. You can make a video about "earn value" in Excel, is very common in Project management.
I did not use it yet but I'll put it on my list. Thanks for the feedback.
@@LeilaGharani Rather then Doing it on Excel , You Would have used MicroSoft Project Software
You're simply awesome
awesome work and thanks for sharing 🙂
Tanks. Smart and wonderfull