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!
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!
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.
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!
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.
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....
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
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!
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.
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.
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?
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...
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..
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.
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.
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.
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
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!
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.
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!
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, 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?
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
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?
Hi Leila. You have around ten activities in your schedule. I want around a 100. And when i try to create the chart, only half of the Y axis activities are being shown. I made sure that "specify interval unit" is 1 under axis options. Could you please help me find a way around it?
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?
Hey Leila.. Am a great fun n am becoming Excel pro coz u. I want to add completed percentage data label onto the garnet. My boss wants both colors.( completed n uncompleted) and percentage data labels onto the garnet chat already made
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 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?
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.
Grab the file I used in the video from here 👉 pages.xelplus.com/gantt-chart-full-file
Great Mentor, mam Leila Gharani. God bless you always.
Outstanding video. You are my go to resource on UA-cam. Thank You for what you do!
Great to hear!
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!
Great. Glad to hear that.
Bravo! You are a guru. Thanks for presenting in such an understandable way.
Hands down best video on this topic in all the Web. Brilliant.. Thank you.
Thanks for the kind feedback Hernan! Glad you like the video.
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!!!!
I just love this woman😍
Great presentation! Thank you Leila.
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.
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!
Thanks Dmitry. Yes, it's more for Excel geeks like me who like to limit use of other software :)
This was great!! I've learn a ton from your You Tube Videos. Thank you.
You are so welcome!
@@LeilaGharani You made me a hero to the finance team.
Superbly Explained.
Very creative presentation using very advanced Excel techniques.
Thank you Hattem.
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.
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....
Definitely an Excel Goddess!!!!
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
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!
Glad you like the videos! Thanks for the support & the feedback :)
Brilliant. Thank you Leila. I will use your idea to create one suitable for my work.
Wow, this is Excellent tutorial. Thank You
Very simple explanations, this much more helped for improving my excell skills
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.
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.
Welcome aboard!
Fully thank you for your video training that it is super useful to my jobs
Please make video on ... how to make gantt chart without use of chart. Thanks for sharing your awesome knowledge. my favorite mentor is Leila .
I just learned alot for free from your tutorial vids!
Leila, thanks for such amazing interactive Gantt Chart
You're welcome Vida.
This is super helpful!
Thank you 😊. This video helped me a lot
Glad it helped!
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
so lovely. thanks Laila you are great teacher
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.
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?
yes
Thanks Leila, really appreciate this. I love it!
Wow so nice thanks a lot!
Excellent tutorial video, that's exactly what was i after
Wow it really looks great, thank you!
Thank you...This week I'll show you to my teacher of "Organización y Estructura"
Thanks Carlos - appreciate the support.
Thank you Leila
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...
Many thanks for the feedback Adam. I'll think about it.
fantastic!
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..
You're welcome. Sure. Have already added it to my list - should be in the next weeks...
thank you very much......
This is "Grand"chart !!! explained simple way
"Grand Gantt Chart" - that's what I should have named it :). Glad you like it.
Great job. Your truly awesome.
Thanks Craig. Glad you like it :)
Brilliant as usual, thanks :)
You're welcome Karim :)
well explain.. thank you and more power to you!!
You're very welcome. Glad you like it Joel.
Thank you so much for sharing!
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?
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.
Super. Thank you. If we want to show both plan and actual together on the chart, can you please show that?
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.
You're welcome Ricardo --- hmmm interesting that Excel 2013 didn't pick it up. Glad you found a way :)
Thank you.
Thank you
Hi Leila, great tutorial, do you have any videos for adding dependency lines at all?
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.
Thank you so much. It's very helpful for me.
Glad to hear that. Thank you for your support.
Thank you It's really helpful
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
This is great thank you!
Fantastic video
Thank you! I'm glad you like it.
thanks, this was helpful ..... u just saved my life :)
You're very welcome Yasser :)
Thank u very much, it's exactly that I need
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
Thanks and it's awesome.. Can I show a actual abd planned in same chart
Its good work , but its better if you can linked and dependant tasks
excellent tutorial,
How can I display Start & End dates on the tasks bar (like value)
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?
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!
Wow, you are amazing, thank you!
Ohhh thank you Jacqui! Glad you like the video :)
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.
very nice
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!
Hi, great chart !
Can it predict end date using % done job?
Thanks for very useful CLIP
You're welcome.
Amazing
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.
This a great.....but can you show a bar chart showing actual dates start earlier.
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
Thanks for the video. Is there a way to add dependencies in the gantt chart through arrows?
Great explanation.. If i need to add dependencies which points through arrows between tasks? Will that be possible to create in excel?
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?
very nice explanation Leila, I liked very much. Can we also create reports with Excel?
Thanks leila
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
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?
Hi Leila,
Could we put a formula in column I (percentage completion)? If so, what would that be?
Is it possible to put some vertical lines there?? just for visual guide.
Hi Leila. You have around ten activities in your schedule. I want around a 100. And when i try to create the chart, only half of the Y axis activities are being shown. I made sure that "specify interval unit" is 1 under axis options. Could you please help me find a way around it?
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?
Leila I have a question is there a way to stop the green bar if you have completed the task early?
Hey Leila.. Am a great fun n am becoming Excel pro coz u. I want to add completed percentage data label onto the garnet. My boss wants both colors.( completed n uncompleted) and percentage data labels onto the garnet chat already made
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?
You should create Gant chart in office 365
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 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?
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.
The markers for planned dates are appearing far from the plan and progress bars , instead of appearing right beneath. How do I fix this?
I'm using a TABLE format with header, i want to make headers with dynamic dates - can I do that?
Great graph as always!
Is it possible to divide this chart to use only three days and breakdown to hours?