How To... Create a Basic Gantt Chart in Excel 2013

How To... Create a Basic Gantt Chart in Excel 2013

Eugene O'Loughlin

11 лет назад

242,745 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@AdeKaryadi
@AdeKaryadi - 29.04.2021 07:49

amazing, nice tutorial

Ответить
@nenadsusic8276
@nenadsusic8276 - 09.03.2019 04:56

Hi Eugene. How do you add a progress line to show the time left on a task.

Ответить
@KoenHamkaas
@KoenHamkaas - 07.02.2019 13:43

Hi Eugene, is it possible to add another activity on the same line further in time? For instance Task F has a duration from 10-jan to 19-jan; but also a duration rom 14-feb to 23-feb. ? I tried a bit but I couldn't figure it out. Thank you, I am happy to hear from you. Regards, Koen

Ответить
@sujiselva8699
@sujiselva8699 - 08.11.2018 20:12

So can I use this to create my gaant chart

Ответить
@julenewestwater1310
@julenewestwater1310 - 01.04.2018 15:50

Thank You! You made it easy to follow along and I've done it :)

Ответить
@ascansaima
@ascansaima - 26.01.2018 15:16

Can you add additional tasks and will those also be reflected in the gantt portion? Thanks

Ответить
@lenhalz8086
@lenhalz8086 - 09.09.2017 20:50

good video, learned a lot

Ответить
@adrianyankov2209
@adrianyankov2209 - 22.06.2017 23:35

This did not work for me. There were activities with values which were not assigned to them.

Ответить
@farwabutt3233
@farwabutt3233 - 03.06.2017 23:21

nice & wonderfull work

Ответить
@tonderaimakumborenga2648
@tonderaimakumborenga2648 - 27.04.2017 18:45

thank you so much you are a star

Ответить
@ammaralsuleimani1213
@ammaralsuleimani1213 - 12.11.2016 01:21

hi dr. Eugene . thank for your video regarding ho to create a progress gantt chart in excel 2013 . i have small problem that i have excell 2013 chart direction coming from right to left . how i can but it vise versa. waiting u respond. thank you dearest dr.

Ответить
@Cherryblossam1
@Cherryblossam1 - 07.11.2016 01:18

Thank you very much this was so helpful 😊

Ответить
@manishkumarchd
@manishkumarchd - 02.09.2016 13:51

thnx Eugene

Ответить
@drallisimo34
@drallisimo34 - 03.07.2016 11:39

cool tutorial!!!

Ответить
@anting2783
@anting2783 - 30.05.2016 08:16

Hi Eugene,
can you tell me how can i make my horizontal axis labels like yours that the group‘s title are more front of the tasks ?
thanks!

Ответить
@jpreece18arsenal
@jpreece18arsenal - 25.04.2016 03:43

cheers Eugene!!

Ответить
@Amrac253
@Amrac253 - 28.03.2016 10:55

Thank you, it really helps.

Ответить
@debrajabs9523
@debrajabs9523 - 14.03.2016 08:53

Thanks for the easy to follow video. I had to do this for a class in EHR implementation. This was a link our instructor provided. You are a great instructor.

Ответить
@avarshdarji4897
@avarshdarji4897 - 06.03.2016 04:40

hey Dr E. when i selct the start date it just shows numbers like 4230,42340,42360... and not the dates as 4-Jan-16, 11-Jan-16, 18-Jan-16 ...... please help with this

Ответить
@atisoyin
@atisoyin - 02.02.2016 13:10

I have found this video very useful. As part of my specification courses, I have to create a Gantt chart for a project. Thank-you for coming to my rescue!!! God bless!

Ответить
@MultiMarou
@MultiMarou - 30.01.2016 00:14

Thank you very much for posting this video. Helpful and clear. Worked with Excel 2011 for Mac without a glitch. I can now progress faster on my bakery launch project.

Ответить
@medhamathur
@medhamathur - 16.01.2016 12:44

very helpful...thank you

Ответить
@malthegal5485
@malthegal5485 - 06.01.2016 00:04

Loved this! However, if I wanted to switch my duration from days to weeks, how would I reconfigure my chart?

Ответить
@LisaMVice
@LisaMVice - 16.12.2015 22:44

Eugene, how would I add a % complete to column E? Thanks so much, am really enjoying your help with Excel 2013!!

Ответить
@tinquangle
@tinquangle - 28.11.2015 06:41

arigatou :)

Ответить
@ejikec2545
@ejikec2545 - 17.11.2015 16:02

Please am having problem copying my finished chat from excel to word page. can you help out with that please

Ответить
@ejikec2545
@ejikec2545 - 17.11.2015 15:56

Just exactly what i needed. Thanks Eugine

Ответить
@beastmanbeastman
@beastmanbeastman - 04.11.2015 04:06

THANKS!

Ответить
@hanacz
@hanacz - 28.10.2015 14:41

Thank you for this tutorial!

Ответить
@dang3rxdanger
@dang3rxdanger - 13.10.2015 07:57

Thank you so much for making this awesome tutorial. It was so easy to follow and made making a Gantt chart extremely easy. I really appreciate it!

Ответить
@BHJX999
@BHJX999 - 07.10.2015 06:32

Hi Eugene,
do you have weekly, plan and actual gantt chart tutorials?

Ответить
@muhammadomar6794
@muhammadomar6794 - 11.09.2015 18:52

Tq sir. Love from malaysia

Ответить
@Sam-fc1rf
@Sam-fc1rf - 15.08.2015 14:28

Thanks so much Eugene, other tutorials were too long or too difficult to follow but yours was so easy and simple! Please continue making good content!  
:)

Ответить
@mikeboi0
@mikeboi0 - 12.08.2015 18:51

This tutorial made me look smart in class haha thanks

Ответить
@arturogr2b9
@arturogr2b9 - 11.08.2015 03:08

Needed to send a gantt chart to my manager and your video saved my life in minutes!!!... God bless you!!

Ответить
@TheMohabs
@TheMohabs - 11.08.2015 01:44

Hi Eugene! Thanks for a great video. Quick question for you - My date axis is still representing value instead of actual dates. What should I do to look them like yours?

Ответить
@NKOTBJovifangirl
@NKOTBJovifangirl - 24.07.2015 20:18

You're a life saver Eugene. this is exactly what i was looking for to complete one of my reports for college. Thanks for posting this tutorial It helped.

Ответить
@dhityaunggul7494
@dhityaunggul7494 - 20.07.2015 09:02

It's very helping me !!! Thanks for share the guide :)

Ответить
@josefinkannin1234
@josefinkannin1234 - 06.06.2015 22:00

Hi Eugene,
Thank you for providing this helpful tutorial. I was wondering, after you've created the list of tasks and bar chart, is it possible to go back and add more tasks? Will the bar graph info automatically be created if you do this?

Ответить
@leetaing3100
@leetaing3100 - 20.05.2015 01:54

Hi Eugene

a lot of thanks to this video tutorial, i've found it absolutely valuable.
However, i am not sure how did you group the information, like breakdown the initiating task into smaller peaces of task. 

Thanks in advance

Ответить
@sigridekman2446
@sigridekman2446 - 19.05.2015 11:12

Thank you so much! Great tutorial.
One question I have: Is there any way one can factor in to exclude weekends in the date calculations? Eg an activity is set to take 10 days (but won't run over the weekend). How does one "split it up" to be reflected in the Gannt chart? Does one have to do it manually by adding the weekend days, or is there a way of doing it automatically?

Ответить
@Gwynbobs
@Gwynbobs - 13.05.2015 23:36

absolute legend! thank you so much

Ответить
@katiebridger4215
@katiebridger4215 - 06.05.2015 16:24

Brilliant video - very clear and easy to follow. Thank you.

Ответить
@RiazShah90
@RiazShah90 - 14.04.2015 04:26

Great video tutorial Eugine!
I have a question, I followed all your steps but all the words on my chart are still aligned to the right. I want my titles (Like initiating, planning, executing) to align left like yours to differentiate between the subtopics but all of them automatically aligned to the right even though I've set it otherwise on my table. Is there anything I can do to align the titles to the left?

Ответить
@younusabdus-samad3445
@younusabdus-samad3445 - 07.04.2015 19:29

great video, 10/10

Ответить
@sharonlambert5377
@sharonlambert5377 - 02.04.2015 05:39

awesome luv it many thanks

Ответить
@BeatSebastian
@BeatSebastian - 27.03.2015 18:41

Thank you so much for making this video. Making a Gantt was the easiest thing... Thanks

Ответить
@SarahJones-gu2zv
@SarahJones-gu2zv - 10.03.2015 15:38

Brilliant, many thanks for making this.

Ответить
@kataonly9233
@kataonly9233 - 09.03.2015 17:08

Thank you so much for the help !! Its extremely resourceful ! I saved money , time and my hair by watching this video !
Merci Beacoup !

Ответить