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

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

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/gantt-chart-project-file

[@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!❤️

[@LeilaGharani]

Glad you like my version!

[@lynnmcfadden655]

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.

[@danielemerli9781]

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

[@LeilaGharani]

Thanks for the kind feedback Daniele. I'm glad I can provide some ideas for your own project.

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

[@LeilaGharani]

My pleasure Patrick. I'm glad you like the video.

[@edmundtumaca2334]

Another good lesson, job well done. You are always forever remembered. Thank you so much.

[@aryanziaie8016]

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

[@LeilaGharani]

Good to hear, thank you!

[@vernlong3537]

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

[@LeilaGharani]

Glad it worked out!

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

[@LeilaGharani]

They definitely do George!

[@mikerajaram1166]

Great tutorial! This was exactly what I needed for my project! Thank you!

[@ianpeters7683]

You have saved my life...thank you so much Leila...awesome work!

[@davidferrick]

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

[@LeilaGharani]

Thank you for the kind words David.

[@florian4200]

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.

[@LeilaGharani]

Thank you! 😃

[@katerina6495]

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 🤗

[@LeilaGharani]

Danke, liebe Katerina! 🤗

[@vasbairaktaris1946]

Congratulations! Perfect job! Thank you!

[@ckokse]

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

[@LeilaGharani]

Glad you like it.

[@speedylogic]

That error bar trick is brilliant!

[@LeilaGharani]

Error bars are totally underrated :)

[@ikhsansetiawan6663]

Hi Leila, thank you for the amazing work you do. 🙏

[@vps99999]

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 :)

[@LeilaGharani]

You're very welcome. I'm happy if it's applicable to your work.

[@johnborg5419]

Great Gantt Chart. The vertical Line marking Today is absolutely fantastic. Thanks Leila. This is very helpful.

[@LeilaGharani]

Glad you like this version of the Gantt Chart!

[@chrisnaidoo4596]

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

[@murdiaamrit]

Many many thanks to you Leila. This is immensely helpful. Keep making such videos

[@towfeek1338]

Your efforrs are always highly appreciated...

[@LeilaGharani]

I'm glad to hear that :)

[@sbarrak]

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

[@LeilaGharani]

Wow, thank you Sergio!

[@user-uy5kd9sb2q]

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.

[@tiagoportolon3336]

Quite helpful. Thanks for sharing your knowledge!

[@gopinath6765]

Thanks Leila for these many videos... Loved it...

[@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.

[@LeilaGharani]

Wow, thank you for the kind words 🙏

[@charlottemorris5287]

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.

[@josuedelmonde9688]

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.

[@mjay2526]

This is great! Will use this as a production planning tool. Thanks!

[@LeilaGharani]

My pleasure. I'm glad it's useful.

[@xavierzirate124]

This Gantt chart series is amazing, appreciate your videos definitely have learned so much from you

[@LeilaGharani]

Glad you like them!

[@AnupamBam]

Speechless! Thank you.

[@rauldevia6093]

Thank you, it is a lifesaver, you are an Excel god!

[@SalilTV]

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 !

[@LeilaGharani]

You're very welcome!

[@dragdrag1507]

Thank you for doing this!

[@riogracetemplado219]

Wow! This is so easy to follow. Thank you so much! 😍🥰🤩It really helped me in our division roadmap.

[@wayneedmondson1065]

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!

[@LeilaGharani]

Thank you for the kind words Wayne.

[@lawrencelim8324]

Wow impressive!! Gonna learn it later

[@saifabuaisheh7660]

It's really helpful! Thanks!

[@dennereitufmt4849]

Perfect!!! Congratulation on your excellent work!

[@user-eq7dk2lk2d]

Always creative Queen of Excel , thanks Leila

[@LeilaGharani]

Trying my best :)

[@diannedrechsler4792]

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.

[@LeilaGharani]

That's great Dianne. I'm glad you could apply it right away.

[@andrewbuswell2874]

Very useful tutorial. Great work Leila. Thanks

[@PowerofJohras]

Wanted to learn how to do this for a long time. Great video! Will really help me with time management for projects in school.

[@LeilaGharani]

I'm glad the tutorial is helpful Rasmus.

[@gdphilippe]

This video was so helpful! Thank you for making it so easy to understand

[@LeilaGharani]

You're so welcome!

[@JeanLucGARNIER]

That's brilliant! Thanks for sharing!

[@LeilaGharani]

You're very welcome Jean-Luc.

[@maroz9389]

This video taught me so much, thank you

[@marlonalegria8944]

Just what I needed. You're fabulous!

[@LeilaGharani]

Glad you like it Marlon.

[@leaholicrombie]

This really helped me! Thank you :)

[@noncandeggiare]

Brilliant! Thank you very much!

[@LeilaGharani]

My pleasure Filippo. Glad you like it.

[@sajidali75092]

the best tutorial ever. she's the best

[@PeliculasOnline2017]

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.✅

[@ajnasu5099]

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.

[@dbcwest7711]

Thx for sharing. Loving it.

[@SolidHyunkel]

Super useful! Thank you.

[@arnaudseguin6404]

Awesome video. Thank you Leila.

[@LeilaGharani]

You're very welcome Arnaud.

[@jiash1]

No words to say... you are really great ..

[@sharifulalam6427]

Very useful... nice presentation... appreciate your work. THANK YOU VERY MUCH!

[@LeilaGharani]

My pleasure. I'm glad the tutorial is helpful.

[@alainbryson]

Followed along and works like a charm... Great vids and tutorials...!

[@LeilaGharani]

Great to hear!

[@behrangchaloushi7235]

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

[@LeilaGharani]

Aw, thank you! I'm glad you like my videos.

[@franciscojrlarita441]

Thank you very much, I learn so much from you

[@aahanavikram07]

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

[@LeilaGharani]

Like they say: If you can think it, you can do it :)

[@edwardharrison715]

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!

[@at-excel]

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

[@LeilaGharani]

😂

[@yulinliu850]

Love it. Thanks!!

[@LeilaGharani]

My pleasure. I'm glad you like it.

[@gpalchik1]

Wow..... Just wow...

[@robertakwasiadjei8223]

Thanks Leila. Very inspiring

[@LeilaGharani]

My pleasure Robert. Glad you find it inspiring.

[@colecoleman1499]

Seems like i have to learn this too. I thought i was done with project management toolset. Thanks Leila for dedicating your time

[@LeilaGharani]

I hope it will be useful for you.

[@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?

[@MedStudentMedhat]

Absolutely Helpful video and a very clean gantt chart

[@LeilaGharani]

I'm happy you like my version.

[@MedStudentMedhat]

@@LeilaGharani yes thx alotttt

[@claudemirpedro3190]

Amazing!

[@jasonhamika8133]

Leila you saved my life so many times.. what a great video and presentation

[@LeilaGharani]

My pleasure, Jason!

[@HubertKirchgaessner]

Really creative, and excellent tutorial!

[@LeilaGharani]

Glad you like it Hubert.

[@ChengVincentckf]

This is magic!

[@rez2109]

Thank you Leila, I am your fan from Malaysia.

[@LeilaGharani]

Thanks for watching!

[@jamesmiller4114]

Superb Video with clear /concise instructions. Thanks

[@LeilaGharani]

My pleasure James. Glad it's useful.

[@SainathShindehello]

Awesome, Just perfect and Thanks a lot.

[@LeilaGharani]

Most welcome!

[@nawad58]

Leila, you are a genius.

[@ejdz21280]

You are a true genius!

[@LeilaGharani]

I'm happy to hear that Eric 😊

[@jrobinson8898]

You are awesome!!

[@shubhsjbp]

This is brilliant, I don't even need MPP for the regular project plans, plus the visuals are much better.

[@LeilaGharani]

I'm glad the tutorial is helpful.

[@ommenourel3ine186]

Thank you leila.

[@onlinebusinessguide8966]

You did great work thanks

[@mostafa4321]

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

[@LeilaGharani]

Glad you like my version.

[@yurd563]

Thanks for video!

[@LeilaGharani]

You're very welcome.

[@babu_frik]

this is next level! thanks.

[@LeilaGharani]

My pleasure. I hope it's useful for you.

[@ChristianAndreassen]

Elegant - great solution with many useful tips included as always! :-D

[@LeilaGharani]

I'm glad you like it Christian.

[@nikotra]

Great video, as usual, thanks for sharing. It's full of inspiring tips, my favourite one: error bars customization :)

[@freelancer6170]

Excellent.. Good thinking and good work

[@ChallengeEzgi]

You are the best thank you so much

[@CreativFarmGal]

Thank you!!!!

[@TravelandLifeBD]

Thx a lot...a much needed output...

[@daves4026]

awesome work and thanks for sharing 🙂

[@sarfarajkureshi6569]

Very nice teaching, with beautiful toune, love you...

[@LeilaGharani]

Glad you like it.

[@99425894]

Simply awesome

[@nimanaghipoor9709]

perfect training, nice voice, and pretty teacher

[@LeilaGharani]

I'm glad to hear that :)

[@sharleneolivier8145]

BRILLIANT

[@deborahsastrias6398]

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?

[@prabodhpatil225]

Very impressive. this will be very usefull to me as I am handling Projects with excel. I thought I was an excel expert till I saw your videos. I have become a fan of your videos. definitely will be recommending this to my colleagues. Thanks So Much Leila..

[@LeilaGharani]

My pleasure. I'm glad to hear the videos are useful.

[@heobingo]

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

[@larsholck]

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.

[@FulvioGaggioli]

You are really good!

[@farooqbashir4111]

Very Good. Thank You