I have some projects that do not have dates yet, so the chart creates dates as far back as the year 1900, which shows the project as tiny blips. I had to fix that by selecting the dat axis at the bottom, right-click "Format axis", go to the "Format axis" tab (looks like a graph - the right-most one after "Fill & line", "Effects", and "Size and Properties"), expand "Axis Options", and in the "Bounds" --> "Minimum" value I put a recent date - "1/1/2023". Then it showed up fine. This was great! Thanks so much!

This is one of the best for beginner Gantt chart creators. Would love to see more complex scenarios going forward.

@innovative_learner

3 жыл бұрын

Thank you very much 😊.

@gordonresquer4604

2 жыл бұрын

@@innovative_learner , sir if I change the column tasks to Employee and start / end date to start / end TIMES (to reflect duration of a job assignment during the day) as an example, could I have. Employee1 have several job assignments/tasks on one line?

This is such a good tutorial for people who are not familiar with using excel. Very easy to follow and really well explained. Thank you so much :)

@innovative_learner

2 жыл бұрын

Thank you very much.

Best Gantt chart tutorials I’ve seen

YOU THE MAAAAAN, thank you so much for your help!!! This is a quick way to generate a Gantt Chart with decimal values, and so neat as well! 😄🎉🙌

@sellingouts3022

2 жыл бұрын

Thank you very much

@innovative_learner

2 жыл бұрын

Thank you very much

Surprisingly simple way of doing Gantt chart, great work!

@innovative_learner

2 жыл бұрын

Thanks :-)

Very well explained. Looks like a piece of cake to make a Gantt Chart now. Thank you so much

This was so much easier to follow than the pdf provided by the class! Thank you!

@innovative_learner

2 жыл бұрын

Thank you very much. You might also like my other new video on Gantt chart at kzread.info/dash/bejne/a5mluruHl9evcaQ.html

it is nice one tq

Excellent video ! I learnt how to make the chart from scratch ......thank you

Easy and simple, thank you very much!

Awesome. Thanks. The bottom horizontal bar also needs the data to entered in reverse order. How do you do that?

There is always some Indian dude helping out with computer-related stuff. Thanks, Man.

wow!! thank you so much, i struggled so hard to make this, watched about 7 videos until i found this video!! youre the best man

@innovative_learner

Жыл бұрын

Thank you very much. Please subscribe, share and like...

I've watched several videos for help with Gantt charts and yours was the first that I was actually able to follow and apply. Thank you!

@innovative_learner

2 жыл бұрын

Thank you very much. It's a pleasure for me to hear my video was helpful for you.

this is an amazing tutorial, thank you! your presentation was perfect and so easy to follow.

@innovative_learner

2 жыл бұрын

Thank you very much. You might also like my other new video on Gantt chart at kzread.info/dash/bejne/a5mluruHl9evcaQ.html

Thanks for the video. it was easy to follow and understand. did my first Gantt chart learning from the video

Very informative tutorial. Thank you for sharing.

Best video ever about this topic !!! Thank you so much.

Mate you are an absolute legend, will be praying for your good health you studmuffin. May Allah grant you eternal passage through the gates of heaven on the prophets shoulders

Very concise and easy to apply. Thank you so much.

@innovative_learner

2 жыл бұрын

You are welcome. Thank you very much.

Amazing video! Now I can do my project planning properly.

Fantastic Tutorial. Thank you so much!

this SAVED ME, thank you senpai

Thank you so much! This was very helpful and easy to understand. Much appreciated!

@innovative_learner

2 жыл бұрын

Thank you very much

Very well explained. Thank you☺️

Very nice, crisp and clear. Thanks a ton

@innovative_learner

2 жыл бұрын

Thank you very much.

you are an absolute genius !!

Thank you very much for this awesome lesson.

@innovative_learner

2 жыл бұрын

Thank you very much 😊

Thank you so much! This is the best one I found!😀

Very good tutorial! Thank you so much.

Is there a way to color code the bars depending on who manages it?

Wow man, you are one creative genius. Thank you.

@innovative_learner

2 жыл бұрын

Thank you so much

thank you. this video is really helpful and easy to follow. kudos

Very helpful, thank you!

@innovative_learner

3 жыл бұрын

Very happy to know you found it useful. Please like, subscribe and share to support my channel. Thank you very much.

That's an awesome video!! The chart looks amazing! I have a question if the task has been finished in non-consecutive days, how should it be caught by this Gantt chart? Thank you very much!

@innovative_learner

2 жыл бұрын

Thank you very much. You might also like my other new video on Gantt chart at kzread.info/dash/bejne/a5mluruHl9evcaQ.html

really great video!!done my assignment just in few minutes!!

@innovative_learner

2 жыл бұрын

Thank you very much 😊

Easy to follow. Thanks!

@innovative_learner

3 жыл бұрын

Thank you very much 😊.

Thanks man! Very useful!

@innovative_learner

3 жыл бұрын

Thanks. Pls subscribe to support my channel.

straight to the point you saved me... Thank you!! Consider me a subscriber cant wait to check out more of ur content

@innovative_learner

3 жыл бұрын

Thank you very much

Very helpful! Thank you

This is very good tutorial . thank you very much.

@innovative_learner

2 жыл бұрын

Thank you very much.

This was very helpful. Thanks

Awesome explanation..Thank you so much.. Found it very useful✨

Thank you! Found this very helpful

THANK YOU !! This was veryyyy helpful!

@innovative_learner

3 жыл бұрын

Thank you very much.

@sangeetajadhav5491

3 жыл бұрын

try bb yyyyyyuû

The best explanation🤘🏼🤘🏼

HELPFUL. Thanks!

Thank you very much. It was simple and less ambiguous.

Amazing, thank you very much!

@innovative_learner

2 жыл бұрын

Thank you very much 😊

Cheers, for a great video.

Thank you, I just finished my assignment. easy to understand

@innovative_learner

Жыл бұрын

Thank you very much. Please subscribe, share and like...

Implemented and learnt new things as well...Good job and keep them coming !!!

You're a life saver bro🤜🤛

Thanks . Simple and easy

Thank you very very much sir really very helpful 🙏🙏

So much grateful to you brother

@innovative_learner

3 жыл бұрын

My pleasure

This is the best tutorial ever

Thank you for doing this video that helps me a lot!!!

@innovative_learner

2 жыл бұрын

Thank you very much

Good one

Really Helpful. Thank you

@innovative_learner

3 жыл бұрын

You are welcome

Very helpful video

Great Effort Thank you so much

Very very Beautiful

Thanks man super helpful

BEST VIDEO EVER TYSM

@innovative_learner

3 жыл бұрын

Delighted to know you found it useful. Please subscribe to support my channel. Thank you very much.

Thank you so much!

Well Explained. Thanks Boss (Y)

@innovative_learner

3 жыл бұрын

Thank you very much :-)

Hi there, this is a great video. One question though, the table at the bottom looks like have the wrong order showing from task7 to task 1. Is there a way we can reverse it? Thanks!

@juliesalah2409

2 жыл бұрын

I would like to know as well. Thanks

@eribaik

9 ай бұрын

any solution?

Hello, is there a way we can have the data table in the bottom start with Task 1, instead of task 7?

@innovative_learner

3 жыл бұрын

Thanks for your question. Yes, it is possible to change order of table but you will, first, have to skip changing order of tasks in vertical column so in vertical axis Task-7 should be on the top and below it would be Task-6, -5, -4, -3, -2 and thus Task-1 will be on the bottom. This should still be perfectly fine as it would mean that your oldest task (Task-1) is on the bottom and other tasks are piling up thus your latest task (Task-7) is on the top. By doing so the data table will start with Task-1. Hope that helps. Thanks.

@eribaik

9 ай бұрын

right click at task 1-7 ->axis options-> axis position-> tick categories in reverse order

Hi, how do I reverse the order of the dates and the task numbers in the data table?

@innovative_learner

2 жыл бұрын

Thanks for your question. Yes, it is possible to change order of table but you will, first, have to skip changing order of tasks in vertical column so in vertical axis Task-7 should be on the top and below it would be Task-6, -5, -4, -3, -2 and thus Task-1 will be on the bottom. This should still be perfectly fine as it would mean that your oldest task (Task-1) is on the bottom and other tasks are piling up thus your latest task (Task-7) is on the top. By doing so the data table will start with Task-1. Hope that helps. Please let me know if that still doesnt answer your question and I will try my best to resolve your problem. Thanks.

Thank you so much, really well explained and helpful. All the best Nora

I did this job. thanks for your suggestion.

I think for Duration the formula should be =(enddate - startdate + 1). Otherwise, something that starts and ends on the same day will have zero days duration.

@Around_The_Home

2 жыл бұрын

@@christinaperkins7600 A one day task will begin and end on the same 1 day. Otherwise, it is not 1 day. Thus enddate and startdate will be the same. Therefore, =(enddate - startdate +1) will resolve to = 0 + 1 which will resolve to = 1. Hope this makes sense.

Thank you!!!!

Perfect tutorial

@innovative_learner

3 жыл бұрын

Thank you very much for appreciation and encouragement. Have a lovely day :-)

Thank you for the video

You are a big legendddd

Thank you !

Thank you!!

Thank you very much brother really helpful for me❤️

@innovative_learner

3 жыл бұрын

Thanks brother. Please let me know if you want any other type of video. Cheers.

@basantbhatta6378

3 жыл бұрын

@@innovative_learner can you help me making IoT based theft detection machine using Raspberry pi I want to know more about that available video in KZread give less knowledge 🙂

guuuuud

Thanks !

You are a genus

I'm stuck. I don't have that menu after right clicking on the blank chart.

Great

thank you!

Thank you so much brother

@innovative_learner

2 жыл бұрын

Thank you very much. You might also like my other new video on Gantt chart at kzread.info/dash/bejne/a5mluruHl9evcaQ.html

great video indeed! easy to understand!

Is there any way that we cannot count saturdays and sundays on the table and graph???

@innovative_learner

3 жыл бұрын

Hi, yes you can take care of the following things: 1. When choosing start date of a task, make sure you don't select weekends. All your start dates must be week days (Monday to Friday). Table only shows start date so if your all start dates are week days, you will not see weekends on your table. 2. In the graph, on the date scale, when you choose Minimum value for date, make sure it must be a week day. Once you do that, for the Major Unit, choose numbers that are multiples of 7 i.e. 7 or 14 or 21 and so on. In this way you will not see any weekend (Saturday or Sunday) on your graph. Hope that helps. Let me know if you are still not sure. Have a lovely day :-)

Thank you! I made it for 10min, other videos made me feel stupid😭

for the table underneath, can I have task-1 in the front ?

@innovative_learner

2 жыл бұрын

Thanks. You can do that if you first dont change the order of tasks in the vertical axis.

Thanks

thank share

Good for beginners, thanks a lot!!

@innovative_learner

3 жыл бұрын

Thank you very much.

Thank you sir

Thank you very much

@innovative_learner

2 жыл бұрын

Thank you very much too.

who want to reverse order, you can try right click at task 1-7 ->axis options-> axis position-> tick categories in reverse order

Thank u so much

THANX!

@innovative_learner

2 жыл бұрын

Thank you very much