Use Excel to create a project management Gantt chart. An Excel 2007 version of this video is also in my channel.
Video Rating: 4 / 5
Using Excel 2007 to create a Gantt chart–a popular project management tool
Video Rating: 4 / 5
Making a Gantt Chart with Excel
thanx ,you got me 10 marks for my report
@Oliverdixon111 Other countries use Month/Day/Year as well, nothing big.
Thank you sooooooo much for putting this on you tube,ur a *star* Easy step by step guide, some differences on layout on my version of excel; but managed to figure it out. Well done!!
THANK YOU! I have a really hard time with this stuff and your video is SO helpful.
No chart wizard in Excel 2010.
boo.
thanks! very helpful!
Excellent video. Clear and comprehensive. I was able to follow the instructions and create a Gantt chart in spite of using a newer version of Excel. Thank you very much.
Excellent video. Clear and comprehensive. I was able to follow the instructions and create a Gantt chart in spite of using a newer version of Exel. Thank you very much.
Useful stuff! Cheers for sharing!
ur a great guy!! thanks
How do you do that date sum thing? Teach me how to make one. =)
Well done dudexx
How would i put two bars on one line, for example starting task 1, but going back to it on a later date, would mean two bars are present on one line. How would i be able to do that?
excellent
good for basic users
Thank you. I learned new tricks.
@mruddhav maybe it was uploader’s competitor to vote didlike
Yantram a Architectural Rendering Studio – Architectural 3d Visualization Company offering services like 3d Rendering, render companies, 3D Renderings, Photorealistic design, Interior 3D Rendering, Conceptual 3D Rendering, 3d Renders, 3drandring design firms.
well done, thank you for posting.
Thanks a lot! This is a great tutorial to save a lot of money in purchasing Gant plot software by using the existing EXCEL software.
Thank you SOoooooooooooooooooooo Much
What a great tutorial!
Thank you so much!!! I was required to make one of these for a class and had no idea what I was doing. You instruction completely helped even though I have a newer version of Excel. THANKS AGAIN!
You sire, deserve a nobel prize for saving computers from being smashed around the world.
@iliiilili Go die in a hole.
thank you for taking the time =)
thank you.it helps me for creating my gantt chart !!
Extremely helpful. Thanks.
im trying to change the dates in a gantt chart, i’m just traying to make the lenght of it 2 months longer but i cant get the dates to show up on the chart, it jus ends on a random date and does not show all the chart
Thank you so much. I am making a Gantt chart regarding anticipation inventory to be used in a power point presentation for my Supply Chain Management course.
@pagalvin1 p.s managed to get the scale to show each day of the week.
@pagalvin1 Sorry for the late reply. Eh I’ve had a look and I can’t seem to figure out how to achieve this. I know you can label the Major Axis lines differently than the Minor Axis lines, so you can make them bold/different colour etc to make them stand out, however my scale shows every 5 days instead of every 7, so doing this would not make any sense. However I am going to try and make the scale every seven days, thanks for the idea and I’ll get back to you if I can make it work!
thaaaaaaaaank you! I was actually recommended by my professor to watch you so you’re making a big impact on the lives of not-so-savvy Excel college users. xD
@benbmyers thanks, that work perfect. do you know by any chance how to add in a line to show the end of a month or the end of a week? that would also be a great help
@pagalvin1 Yeah I got it. Whilst in the ‘Format Axis’ for the dates, simply change the Major unit from ‘Auto’ to ‘Fixed’. I changed it from 10 to 5.0, and that gave me a smaller scale and made the dates easier to read. After that I had to change the text to appear vertically because it was still too bunched together when horizontal. Hope this helps, if not give me another shout and I’ll get back to you!
@benbmyers hey, i dont know how to do this but did you find out? i really need to sort this out or else the shit will be hitting the fan. please get back to me if you know/ thanks
Thank you
Extremely helpful..thanks for the video..
thanks for the help!
@benbmyers Never mind, got it!
Cheers for the help mate, Great vid
Hi. Great video. One problem though, I’m creating a Gantt chart that goes on for around 3 months. As I need to use this chart in a report I need to have a smaller scale on the dates. As of now the chart displays the date every ten days and I was wondering if you know of a way to show the date more accurrately, such as every day. Thanks!
Thanks for the guide!
Thank you so much
Thank you very much this was amazingly helpful and easy to follow, if we ever meet I’m buying you a drink.
Awsome ..U made my day !!
thanks alot your a legend!!!
*throws roses at rrphillips feet* Thanks so much. I’m at work and I was wondering the best way to convey a schedule with overlapping action items!! Where do send the check?
I can’t thank you enough
you are a hero man…