Excel 2007 Tutorial 16: Gantt Charts

Excel 2007 Tutorial 16: Gantt Charts. Step by step description for creating a Gantt chart.

Don’t forget to check out our other video tutorials or share this video with a friend.

0 votes

Loading... 3,873 views

18 responses to “Excel 2007 Tutorial 16: Gantt Charts”

1. Alex Fox says:

   11/04/2013 at 2:02 pm

   SOOO HELPFULL!!!!!

   Reply
2. Emma Winfield says:

   11/04/2013 at 2:39 pm

   Brilliant tutorials, so helpful.
   I am fast becoming the Excel Guru at work!
   Thank you Rick! 🙂

   Reply
3. mrziz1984 says:

   11/04/2013 at 2:46 pm

   Thank you it was help-full l!!

   Reply
4. Dianne Manhertz says:

   11/04/2013 at 3:29 pm

   this saved me. thanks so much

   Reply
5. Xaldinwinddude says:

   11/04/2013 at 4:16 pm

   Wow, thanks a ton man, you saved my hide on a project for my class. Much obliged!

   Reply
6. VAZGO384 says:

   11/04/2013 at 4:41 pm

   thanks for the tutorial!

   Reply
7. nt hu says:

   11/04/2013 at 4:51 pm

   To correct this problem, you can type in different dates like “07/10/10”, “06/10/10”, and “08/11/10, etc . The dates will automatically change from general to date format. As you input the data while creating bar chart, they have values… Please note that all the dates you type like “08/15/10”, “09/15/10”, “09/20/10” , etc in the video, they will not automatically change into date format… and therefore you have to change them manually and it results into no value and no bar chart…

   Reply
8. nt hu says:

   11/04/2013 at 4:56 pm

   Therefore, you cannot set up a bar chart if you follow the video… so just take this an example as well…

   Reply
9. nt hu says:

   11/04/2013 at 5:27 pm

   If you type “06/01/10”, it will then automatically change to date like 06.01.10. the format of date depends on your settings. At this point, “06.01.10” has an value and you will see a bar while you inserting data. However, as you will also inserting data like”08/15/10″, “09/15/10”, “09/20/10”, etc, you will notice that there are no bars for these data since they have no value (please be remind that the value are “01/00/00″ for all of the data, i.e. =0”.

   Reply
10. sch001b0y says:

    11/04/2013 at 6:11 pm

    I got lost when creating the chart.

    Reply
11. gladiepoo says:

    11/04/2013 at 6:23 pm

    Wow. Each video keeps getting better and my mind is blown by the functions of Excel. Your videos are simple yet educational! Keep up the good work!

    Reply
12. tron6050 says:

    11/04/2013 at 6:24 pm

    you’re the best!

    Reply
13. fahadazam22 says:

    11/04/2013 at 7:03 pm

    thanks for putting this up

    Reply
14. tazvitya says:

    11/04/2013 at 7:29 pm

    thx dawg! i really appreciate it.

    Reply
15. innerwinner1 says:

    11/04/2013 at 8:27 pm

    This was GREAT! THANKS. The next thing I’d like to learn is how to add tasks that take place during each timeline. For instance, along the marketing timeline can you add more dates and labels for sub-tasks?

    Reply
16. Auktoriserad says:

    11/04/2013 at 8:59 pm

    This was nice

    Reply
17. JJTheBigDog says:

    11/04/2013 at 9:55 pm

    I tried this with Excel 2010. However when I type 06/01/10, Excel changes this all the time to 06.01.10. According to the Microsoft office page an autocorrect-button should appear on the screen, but that’s not the case. Now I hate MS office even more! Thanks for the tutorial though! I go spend some more time on google thanks to this great and very usefull autocorrect-feature ^^

    Reply
18. familytart says:

    11/04/2013 at 10:43 pm

    Awesome! You are the first person to take the time to show how to do it in Excel 2007! Thank you very much!

    Reply