How to Make a Gantt Chart in Excel with Progress Bars (actual, planned & percentage completed)
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
In this video, learn how to create a more complete Gantt chart that not only shows percentage completed for each task and conditionally formats the progress bars but also allows you to compare actual project plan to planned project plan.
Features include: automatic Gantt chart bars, automatic counting number of working days, automatic percent complete on Gantt bars, colored bars to indicate complete tasks and percentage completed.
⬇️ Download the free Excel Gantt chart template and edit to your own needs: pages.xelplus.com/gantt-chart...
Ideal for project management, this guide shows you how to build a dynamic Gantt chart that not only tracks task completion percentages but also adapts to changes in project timelines.
🔑 Key Points:
- Advanced Gantt Chart Features: Learn to create a Gantt chart that goes beyond basic functionalities, including conditional formatting for task completion and the ability to compare planned vs. actual timelines.
- Percentage Completion Tracking: Discover how to visually represent task progress with conditionally formatted bars, showing the extent of completion for each task.
- Flexibility for Project Changes: Understand how to modify the Gantt chart to reflect changes in task durations, start dates, and overall project planning.
- Utilizing Excel Charts and Functions: Gain insights into using stacked bar charts and arrow bars in Excel to represent tasks and their completion status effectively.
- Interactive Scenario Selection: Implement data validation to switch views between planned and actual project timelines seamlessly.
- Dynamic Axes and Labels: Learn how to make chart axes and labels dynamic, reflecting changes in the project plan directly on the Gantt chart.
Project Management Tool in Excel: This video is perfect for project managers, team leaders, and anyone looking to visually track project progress in Excel.
If you want to make a quicker Gantt chart to visualize your project before you start, check out this video: • How to Quickly Make a ...
Gantt chart is a great visualization tool for project planning. Use the template to define the start date for each task as well as the number of working days each task will take. We will use Excel's Work day function to calculate the end date. This way we can account for weekends and holidays. We do two version. One for budget and one for actual. This allows us to switch the view of our gantt chart between actual and budget.
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ 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
Пікірлер: 224
Grab the file I used in the video from here 👉 pages.xelplus.com/gantt-chart-full-file
Thank you for this video on Gantt charts. I'm a grad student and truly appreciate the breakdown in excel that you shared, and user friendly tips you provided.
Amazing! The Date formatting in charts is something I always had trouble with but you have helped unravel this mystery for me by not changing the serial numbers to actual dates...Very cool!
@LeilaGharani
7 жыл бұрын
Great. Glad to hear that.
Great chart! I like to add another series to the chart with a vertical error bar and an x value of =today() to help show how we are tracking to our plan each day. Excellent tutorial!
You are an Excel Goddess!!!!
Thanks Leila, really appreciate this. I love it!
Thank you for your videos. It's helping me to explore parts of Excel I wasn't coming across in my job but already I am excited to try out new techniques
It makes me feel at ease and smiling :) The reason is when you do need a fully dynamic Gantt Chart and such you just grab the dedicated planning software and do you job. But anyway, what I saw here is brilliant as usual. A piece of a trick for your prof scope in Excel. Thanx, Leila!
@LeilaGharani
7 жыл бұрын
Thanks Dmitry. Yes, it's more for Excel geeks like me who like to limit use of other software :)
Bravo! You are a guru. Thanks for presenting in such an understandable way.
Great Mentor, mam Leila Gharani. God bless you always.
Leila, I love you. Every video of yours is so insightful and superhelpful for my work:) Can't wait to set this up for a project of mine tomorrow. Thanks!
@LeilaGharani
6 жыл бұрын
Glad you like the videos! Thanks for the support & the feedback :)
Great presentation! Thank you Leila.
Outstanding video. You are my go to resource on KZread. Thank You for what you do!
@LeilaGharani
4 жыл бұрын
Great to hear!
Hands down best video on this topic in all the Web. Brilliant.. Thank you.
@LeilaGharani
4 жыл бұрын
Thanks for the kind feedback Hernan! Glad you like the video.
Very simple explanations, this much more helped for improving my excell skills
I appreciate the way you explained this in this vidio, it was great help though the formulas took long to understand, thanks expect more such vidios
Thank you so much for sharing!
Wow it really looks great, thank you!
Definitely an Excel Goddess!!!!
This is great thank you!
I just love this woman😍
so lovely. thanks Laila you are great teacher
Wow, this is Excellent tutorial. Thank You
Brilliant. Thank you Leila. I will use your idea to create one suitable for my work.
Excellent tutorial video, that's exactly what was i after
Superbly Explained.
Thank you It's really helpful
I just learned alot for free from your tutorial vids!
This is super helpful!
Thank u very much, it's exactly that I need
Very creative presentation using very advanced Excel techniques.
@LeilaGharani
6 жыл бұрын
Thank you Hattem.
Fully thank you for your video training that it is super useful to my jobs
Thank you , it was really helpful
Thank you...This week I'll show you to my teacher of "Organización y Estructura"
@LeilaGharani
6 жыл бұрын
Thanks Carlos - appreciate the support.
Leila, thanks for such amazing interactive Gantt Chart
@LeilaGharani
7 жыл бұрын
You're welcome Vida.
Thanks very very much. I just find this that very important for my job . I got ur channel in time. God bless to shared such useful knowledge with us. May Allah grand to more knowledge.
@LeilaGharani
7 жыл бұрын
Thank you Salih. Appreciate the kind words. Glad to hear you find the videos useful for your job.
Really really helpful. Thank you very much. I have subscribed, start watching other tutorials and look forward to more interesting ones.
@LeilaGharani
4 жыл бұрын
Welcome aboard!
Thank you so much. It's very helpful for me.
@LeilaGharani
6 жыл бұрын
Glad to hear that. Thank you for your support.
Wow so nice thanks a lot!
Brilliant as usual, thanks :)
@LeilaGharani
7 жыл бұрын
You're welcome Karim :)
Thank you so much and this is very helpful
Wow, you are amazing, thank you!
@LeilaGharani
6 жыл бұрын
Ohhh thank you Jacqui! Glad you like the video :)
well explain.. thank you and more power to you!!
@LeilaGharani
5 жыл бұрын
You're very welcome. Glad you like it Joel.
Great job. Your truly awesome.
@LeilaGharani
7 жыл бұрын
Thanks Craig. Glad you like it :)
fantastic!
Thank you Leila
This was great!! I've learn a ton from your You Tube Videos. Thank you.
@LeilaGharani
3 жыл бұрын
You are so welcome!
@gavintomlinson777
3 жыл бұрын
@@LeilaGharani You made me a hero to the finance team.
thanks, this was helpful ..... u just saved my life :)
@LeilaGharani
7 жыл бұрын
You're very welcome Yasser :)
Thank you very much.... that's a quick release of dynamic Gantt video as as per my request..... really helpful.... thanks again..... I also requested for dynamic map tutorial. it would be really great if you can upload dynamic map tutorial too..
@LeilaGharani
7 жыл бұрын
You're welcome. Sure. Have already added it to my list - should be in the next weeks...
@bharadhanenenu
7 жыл бұрын
thank you very much......
Thank you.
Fantastic video
@LeilaGharani
6 жыл бұрын
Thank you! I'm glad you like it.
Thanks for very useful CLIP
@LeilaGharani
6 жыл бұрын
You're welcome.
Thank you
Thanks leila
Great as usual. Hope you are well. As a project manager I usually need to show the difference from actual and plan! I mean i should see them both at the same time to figure out if i within , behind or ahead from plan! This could be done by adding a series to the chart as I think. In addition what about using the conditional formatting to cells instead of chart ? What are the advantages and disadvantages? ( space or numbers of cells , colors for formatting, dynamic issues, ... etc) Keep up the good work.
@LeilaGharani
7 жыл бұрын
Hi Abdelrahman, Thanks for your input. To get the graphs right beside or on top of each other, I would probably duplicate it - i.e. create one just for Actual - then duplicate and replace series with the plan one. To get them in one graph, I'd probably put them on top of each other - by taking away the fill color and possibly making the plan series more transparent so it doesn't distract too much from actual. Generally, I prefer to work with charts when I can - this way I have an object that sits on top of the cells - with conditional formatting cells method, I have to make sure the cell widths always remain the same, otherwise the visualization would be impacted....
Amazing
very nice
Good Evening Leila, Your videos are well thought out, perfectly presented, very insightful. Question: If possible, how can this be modified to show the Critical Path?
Great graph as always! Is it possible to divide this chart to use only three days and breakdown to hours?
thanks
Great video! Really show what you did and how to make it yourself, however how would I change this to work by weeks instead of dates?
Wow!! Thank you. :) any way you can show us how to create a collapsed view of the planned durations + percent complete? I’m trying to show a row for each project (broken out by dependent phases/task) and which allows me to include multiple projects, 1 for each row. Dashboard format...you’re the best!
Hi Leila, great tutorial, do you have any videos for adding dependency lines at all?
Please make video on ... how to make gantt chart without use of chart. Thanks for sharing your awesome knowledge. my favorite mentor is Leila .
This is "Grand"chart !!! explained simple way
@LeilaGharani
7 жыл бұрын
"Grand Gantt Chart" - that's what I should have named it :). Glad you like it.
very nice explanation Leila, I liked very much. Can we also create reports with Excel?
Hi Leila. Tremendously enjoy your excel series. In an excel Gantt chart, is there way to display the current cumulative total percentage of the progress? Thank you for all the spreadsheet tutorials in your channels
Hi, thank you for the tutorial, it's very helpful. However, I would like to make a Gantt Chart to compare two methods for a project. Do you think it's possible to show for each tasks the time it's took with method 1 and method 2 ?
You're the best! I'd like to see your take on using a "Named Formula" within the Name Manager, where you create a new named item, that is just a formula so you can use that name as a shortcut to nest that formula within another. In the Microsoft Calendar Template, this is used as "JanSun1", "FebSun1, etc...
@LeilaGharani
5 жыл бұрын
Many thanks for the feedback Adam. I'll think about it.
Hello Leila, I watch and learn from most of your videos. It would be really great if you can upload another video of Gantt chart with resource allocation.
@LeilaGharani
6 жыл бұрын
Hi Magdolina - thanks for your suggestion. Do you mean to simply add the person's name for each task to the chart or also be able to filter or highlight a person and get their tasks?
@magdolinagomes6485
6 жыл бұрын
yes
Hi Leila your videos are really awesome. It really helps me learn new things and polish the old ones. Regarding gantts, i have this scenario though, that instead of tracking days, im tracking sales per person on a time range. Is it possible to do it on gantts? Thanks! and More power.
Hi Leila. Great video. Perfect speed, video and sound quality. The Task titles in the chart are out of alignment. How can I right align them?
WOOOOOOOOW THAT WAS F*CKING AWESOME!!!!!!!!!!!!!!!!!!!!!! GOD BLESS YOU GIRL MAY GOD POUR YOU A MILLION BLESSING THIS WAS REALLY AWESOME THANK YOUUUU!!!!! (AND THANK YOU TO MICROSOFT TOO THE BEST THING THAT EXISTED HEHE)
Thank you for such great chart, I would like to know how show the finish date on the chart?
Hi Leila, Thank you vrey much for the informative video, It helped a lot with office work. In my work, I have to sometimes hold some activities for some time and then again start after few days, so do you have something that can help me show it on gantt chart?
thanks allot
@LeilaGharani
7 жыл бұрын
You're welcome.
Thank you Leila! Is there an option to set the minimum and maximum values automatically, e.g. 30 days before the earliest date, and 30 days after the latest date? Can I reference these values when formatting the Axis Bounds Min/Max?
Super. Thank you. If we want to show both plan and actual together on the chart, can you please show that?
Hi Leila my name is Alan! Thank you very much for the videos on Gantt charts with Excel. Nothing to difficult but the way you put yourself across was very good for me... simple and to the point, softly and no bravado! I have one question though if you could please help me? Where you changed the Y axis task name to include the (**WD) formulae to show number of the work days for each task in the description, how can I edit the formulae (syntax) to display only the (**WD) in RED BOLD text and, the rest of the task description in BLACK text? Sorry, I'm sure its very simple but I am a newbie! Thank you!
I came to this from the more recent of Leila's gantt charts, all good instruction. I was just wondering about dependencies. That is, an activity starting at the completion of a predecessor, or even multiple predecessors. For just one predecessor, a simple calculation would do it, but if there is more than one? I guess a 'max' function of the identified predecessors. I'll get onto it and see what I can do.
Thank you for sharing your knowledge. Really appreciate. I have enrolled for our course also in Udemy. Can you explain, how to show the break in the schedule.. for example the work is started and then there was a gap due to some issues and it resumed after a week. How to show the split like they show in MS project.
Hi Leila, great tutorial! Many thanks. I'm using Excel 2013. For some odd reason at min 6:51 I wasn't getting the same result, the chart came out odd every time. I've tried several options and eventually the only one that worked for me was to select the "Data Prep." table first and then the "Task" list. Many thanks.
@LeilaGharani
6 жыл бұрын
You're welcome Ricardo --- hmmm interesting that Excel 2013 didn't pick it up. Glad you found a way :)
I love the video. Question, how would you go about adding the percentage inside the bar chart? I tried adding the labels but if is pulling the # of days.
Thanks and it's awesome.. Can I show a actual abd planned in same chart
Thanks for the video. Is there a way to add dependencies in the gantt chart through arrows?
Thanks a lot for the video very useful ! What if we have multiple countries in drop down instead of "plan" & "actual"? The if statement in the prep data won't work. How to set up the similar thing for multiple countries?
Great explanation.. If i need to add dependencies which points through arrows between tasks? Will that be possible to create in excel?
Thank you, Leila. How can I change the date on the x-axis? E.g. to quarters?
Thanks for pivot table . Is there any table or chart regarding planing .suppose we have 100 acitvities and all activities time shedule is different .supose one activity schedule is after 35 days .so is there any provision excel by which we can get its alarm 5 days earliar and marked with different color.
Hi, great chart ! Can it predict end date using % done job?
Its good work , but its better if you can linked and dependant tasks
This is another excellent trick to draw a bar chart. Is it possible to link with one task to another as tasks are inter linked?
Thanks for such awesome video saved me from my Boss ;but getting error while displaying graphs for actual & plan it is showing same graph ;for simple chart it worked
Leila, excellent narration and reference material. I am struck, while inserting the completion data. I am getting the completion information for plan data. Is this fine to show up. Thanks
excellent tutorial, How can I display Start & End dates on the tasks bar (like value)
Hello Leila :) I have a querry regarding Gantt Chart. How can i display time taken by a specific task ( if its achieved within the planned time it should show 1 color & if it exceeds the planned time it should flag in red color.) is there any specific formula for showing this..? Also can i co relate the % of task completion with above task.
This a great.....but can you show a bar chart showing actual dates start earlier.
Can you make it dynaminc to be able to select month and year? Maybe also be able to show different views, like daily, weekly and monthly?
Thank you very much for all your videos, Leila! It's been almost 2 weeks now that I can't plot time (not date) into my Gannt chart. Setting min and max bound on horizontal axis won't work for me, as I am setting a dynamic chart range like in your video published on Jul 6, 2017. How can I get my x-axis plot the time correctly on a stacked bar chart?
@LeilaGharani
5 жыл бұрын
hmmmm...I'm not sure about this..
Hi Leila, I've used your Gantt chart and I find it great ! I have a question , can we introduce dependency between different tasks so task 3 can't start before task 1 and 2 have completed. then the next part is how we can do it visualy . I will welcome your suggestions.
@LeilaGharani
6 жыл бұрын
That's great! .... hmmm... I'll think about this and let you know.