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!
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!
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.
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 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
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....
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.
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!
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..
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?
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.
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.
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 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.
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, 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 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 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. 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 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 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
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.
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)
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.
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
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 ?
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?
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?
Grab the file I used in the video from here 👉 pages.xelplus.com/gantt-chart-full-file
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.
Great Mentor, mam Leila Gharani. God bless you always.
You are an Excel Goddess!!!!
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 :)
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.
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!
Outstanding video. You are my go to resource on RUclips. Thank You for what you do!
Great to hear!
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.
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
Bravo! You are a guru. Thanks for presenting in such an understandable way.
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....
I just love this woman😍
Definitely an Excel Goddess!!!!
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.
Superbly Explained.
Great presentation! Thank you Leila.
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 :)
Very creative presentation using very advanced Excel techniques.
Thank you Hattem.
Thank you Leila
Very simple explanations, this much more helped for improving my excell skills
Excellent tutorial video, that's exactly what was i after
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.
I just learned alot for free from your tutorial vids!
Thank you 😊. This video helped me a lot
Glad it helped!
Brilliant. Thank you Leila. I will use your idea to create one suitable for my work.
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
Wow so nice thanks a lot!
Thanks Leila, really appreciate this. I love it!
Wow, this is Excellent tutorial. Thank You
Thank you...This week I'll show you to my teacher of "Organización y Estructura"
Thanks Carlos - appreciate the support.
Please make video on ... how to make gantt chart without use of chart. Thanks for sharing your awesome knowledge. my favorite mentor is Leila .
fantastic!
This is super helpful!
Fully thank you for your video training that it is super useful to my jobs
Leila, thanks for such amazing interactive Gantt Chart
You're welcome Vida.
Really really helpful. Thank you very much. I have subscribed, start watching other tutorials and look forward to more interesting ones.
Welcome aboard!
This is "Grand"chart !!! explained simple way
"Grand Gantt Chart" - that's what I should have named it :). Glad you like it.
so lovely. thanks Laila you are great teacher
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.
Wow it really looks great, thank you!
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......
Thank you so much for sharing!
Thank you , it was really helpful
Brilliant as usual, thanks :)
You're welcome Karim :)
This is great thank you!
Thank you.
Great job. Your truly awesome.
Thanks Craig. Glad you like it :)
well explain.. thank you and more power to you!!
You're very welcome. Glad you like it Joel.
Its good work , but its better if you can linked and dependant tasks
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
Amazing
very nice
Thank you It's really helpful
Thank u very much, it's exactly that I need
thanks
Thank you
thanks, this was helpful ..... u just saved my life :)
You're very welcome Yasser :)
Wow, you are amazing, thank you!
Ohhh thank you Jacqui! Glad you like the video :)
Thank you so much. It's very helpful for me.
Glad to hear that. Thank you for your support.
Fantastic video
Thank you! I'm glad you like it.
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 :)
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.
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?
Thanks for very useful CLIP
You're welcome.
Thanks leila
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 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!
Super. Thank you. If we want to show both plan and actual together on the chart, can you please show that?
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?
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?
Thanks and it's awesome.. Can I show a actual abd planned in same chart
Great explanation.. If i need to add dependencies which points through arrows between tasks? Will that be possible to create in excel?
very nice explanation Leila, I liked very much. Can we also create reports with Excel?
Hi, great chart !
Can it predict end date using % done job?
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
Great graph as always!
Is it possible to divide this chart to use only three days and breakdown to hours?
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 Leila, great tutorial, do you have any videos for adding dependency lines at all?
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. 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 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 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 another excellent trick to draw a bar chart. Is it possible to link with one task to another as tasks are inter linked?
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.
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)
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.
That's great! .... hmmm... I'll think about this and let you know.
excellent tutorial,
How can I display Start & End dates on the tasks bar (like value)
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 have a different planned/actual colored bar?
I fixed it with VBA, but if there is another way I would still like to know
Thanks for the video. Is there a way to add dependencies in the gantt chart through arrows?
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 ?
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?
You should create Gant chart in office 365
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?
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?
This a great.....but can you show a bar chart showing actual dates start earlier.
Thank you for such great chart, I would like to know how show the finish date on the chart?
thanks allot
You're welcome.