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

  • Andres

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


  • MT

    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.

    • 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…

  • Jeff

    How do I do this to take into account of weekend?

  • 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.

  • Pingback: » Blog Archive » Want to do a project timeline without having to buy MS Project?()

  • lakshmi

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


  • Michael

    Excellent little lesson. Easy to follow and exactly the knowledge I needed. Great!

  • Ian

    Thank you! I really needed this lesson!

  • 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.

  • 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

  • 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.

  • JFL

    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…

  • 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!

  • Asad

    thanks for the tutorial, very informative

  • fernando

    but how to make a timeline project

  • Swamy Saran Atul

    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?