How to draw Gantt Charts in Excel 2003

By | February 7, 2009 at 10:27 am | 2 comments | Diary | Tags: ,

I’m not an Excel user, out of the whole Microsoft Office suite I can say that I only use Microsoft Word 90% of the time, I even hardly use Powerpoint nowadays much less Excel. Then the request came up from my boss, ‘draw me a Gantt Chart of the schedule’, back in uni days you had specialized tools for doing this, Microsoft Visio, Microsoft Project and some web based project management systems. However in a typical office workstation you don’t have these tools, and all you have is the Microsoft Office suite. So I tried my look looking for ways to draw Gantt Charts in Excel, the manual way was possible with just keying in the dates, tasks and coloring the cells, but was not practical and cumbersome to do.

Lucky a few searches on Google came up with the following tutorial on YouTube which was rather helpful, and the end result of the chart was pleasing. I would like to share this video tutorial to those who might be facing the same situation, do let me know if you have a better way of doing this.

About the Author

seraph

Web Designer by profession with over 6 years of experience in various industries such as education, corporate and creative. I also love photography and currently a part-time wedding and portrait photographer with over 4 years experience. I have a passion for art, design, video games and anything visually attractive. Visit www.aperture.my for my photography portfolio.

2 Comments

  1. Calvyn (3 years ago)

    this is a very good tutorial, I need to bookmark this video :P , next time when people asking me how to create, I still can refer back :D

    • Seraph (3 years ago)

      yeah it’s interesting, I never knew Excel could do this either, do bookmark it :) it would be better if you bookmarked my page as well :D Haha!!

Comments

© 2012 Penangite. All rights reserved.