Building a Project Timeline in MS Excel

Below is a recent screencast I recorded showing how to build a project timeline (gannt chart style) using MS Excel. It's simple and easy and works great for porting it around to other office apps (eg. Word, PowerPoint). Let me know if you have questions by posting a comment and enjoy!

Excel Project Timeline


  1. Well done mate… you freakin rock!!!
    Was looking for something like this for a while now!!! Keep up the good work!


  2. Great tutorial. Do you know how to do this with older versions of Excel? My company has 2003 and I cant figure out for the life of me how to recreate that same format in it.

    Any help would be appreciated, as I have a project that I want to use it for.

  3. Is there a specific problem you’re facing when attmpting to do this in Excel 2003? I don’t have a instance of that running anywhere but if you have a specific problem I could try to help guide you through it…

  4. Excellent tutorial. You win the award for the most amount of useful information in the least amount of time. Exactly what I was looking for.

  5. Greeting from India. Fantastic article. Thanks a lot for your valuable time.


  6. Thank you for this web site post, I enjoyed its content and style. I came across this web site on Google and today have added it to my personal favourites features checklist. I will be sure to come once again quickly.

  7. Excellent weblog right here! Additionally your site a lot up fast! What host are you the usage of? Can I get your associate link to your host? I desire my web site loaded up as quickly as yours lol

  8. It’s actually a great and helpful piece of information. I am happy that you just shared this useful info with us. Please stay us informed like this. Thanks for sharing.

  9. Hello,
    Is it possible to have more categories with the same name for multiple projects on one timeline?
    For example in the Categories column: Planing, Development, Deployment, Support and than again above Planing, Development, Deployment, Support etc…?
    If if I do like this it does not work…

  10. I was suggested this blog through my cousin. I’m not sure whether this post is written by way of him as nobody else understand such specified approximately my trouble. You are amazing! Thank you!

  11. Hi Ben, this looks like a handy trick to quickly create a plan. However, the dates are calculated by addition, and this includes weekends. Is there some way we can make the dates weekday-only?

Comments are closed.