CP046: Gantt charts & project planning using Excel

In the 46th session of Chandoo.org podcast, let’s talk about gantt charts and project plans.

Gantt charts and project planning using MS Excel - Chandoo.org podcast - session 46

What is in this session?

In this podcast,

  • A brief intro to Excel 2016
  • What is a Gantt chart?
  • How Gantt charts can help us?
  • How to create Gantt charts in Excel
    • Using bar charts with invisible series
    • Using conditional formatting and formulas
    • Using ready-made templates
  • Resources on Gantt charts & project planning
  • Conclusions

Listen to this session

Click here to download the MP3 file.

Resources on Gantt Charts & Project Planning

Tutorials on how to create Gantt charts in Excel

Project Management Resources & Articles

Ready to use Excel Project Management Templates

Ready to use Excel PM Template pack from Chandoo.org

Transcript of this session:

Download this podcast transcript [PDF]

Are you a project manager? Tell us how you use Excel…

I use Excel to manage all my projects – work related, vacation, product launches, product comparison etc. If you are a project manager, what do you use Excel for? Please share your experiences and ideas in the comments section.

Subscribe to our podcast and get latest episodes automatically

Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you.

Other options to subscribe


Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

Written by Chandoo
Tags: , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

One Response to “CP046: Gantt charts & project planning using Excel”

  1. Hey Chandoo, this is awesome.

Leave a Reply

« »