Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)

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.

🔍 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!

🚩Let’s connect on social:

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

[lynnmcfadden]

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.

[Oppadu]

Super clean and readable gantt chart EVER ! Thank you so much and can see how much effort you've put to create this chart!❤️

[ckokse]

Holy moly! Did not think this is even possible with Excel.

[WiebelWie]

People often use colored cells and stuff to show progress in Excel, but this is dynamic and user-friendly. I love the video! Thanks!

[aryanziaie]

I've been working in project management field for more than 12 years and I confirm this was AWESOME!!!

[behrangchaloushi]

میدونی چیه؟ شما فوق العاده هستین. واقعا بهترین آموزشهای اکسل هستش که به عمرم دیدم.you know what? YOU ARE AMAZING . The best excel training vids ever seen, and trust me I have seen a lot

[karhukivi]

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!

[dragonintheroom]

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.

[DavidSanders-qe]

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.

[danielemerli]

It's been 4 years since I've been (I hope) an advanced Excel user, and I've never find a YouTube 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 YouTube home gave me a lot of great ideas to complete it.
Thanks a lot and keep up the good work!

[AlanSpybey]

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?

[davidferrick]

I'm always blown away at how good your tutorials are.

[aahanavikram]

There's always a way in excel to do anything.. loved it ...

[at-excel]

Great explanation! Excel can do it all! Except good coffee and calculate correctly. Looking forward for November!

[chrisnaidoo]

Ain't she the best guys...simple step-by-step instructions even I can understand :).

[florian]

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.

[sbarrak]

This is by far the best gantt chart I ever found for Excel.... Fantastic work and thank you very much for sharing!

[sajidali]

the best tutorial ever. she's the best

[vernlong]

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!!

[mostafa]

bit convoluted but masterful in the end. I am impressed again, Leila. thank you