How to Make a Simple Gantt Chart in Excel | TeamGantt

00:00 - Introduction
00:29 - Add tasks and dates to the Excel worksheet for your gantt chart
01:07 - Apply an automatic formula to calculate task duration
01:40 - Insert a Stacked Bar Chart from the Insert menu
01:56 - Set up your Excel gantt chart data
02:37 - Add the project title to your chart
02:47 - Change the chart date range to your project start and end dates
03:44 - Format the horizontal axis as dates
03:59 - Set your Excel Gantt chart at weekly intervals
04:19 - Reorder tasks, and move the date axis to the top of your gantt chart
04:32 - Format your stacked bar chart to look like a gantt chart
04:51 - Change taskbar colors for a customized look
05:36 - Create a free gantt chart online with TeamGantt

In this video, we created our gantt chart using Microsoft Excel 365. But you can use the steps in this tutorial to make a gantt chart in any version of Excel on a Mac or PC. Follow along, and you'll have a customized gantt chart up and running in no time!

Want an even more powerful solution that’s easy for anyone to use? Try TeamGantt.

------------

Don't forget to check out our website where you’ll not only find our project management software, but tons of project management education. We offer free weekly live classes, on-demand master classes, templates, guides, a blog, a podcast...and more.

And follow us on all our social channels so you don't miss out on any of our content!

[chuckreel]

That was a truly outstanding video. The instructions were clear and the annunciation was excellent! While I have been grateful for tutorial type information in YouTube on multiple occasions the two areas I mentioned above are frequently very lacking and really reduce the value of some of the available material. GREAT JOB!

[xgpefmy]

That was perfect. I did it with you step by step and finally, DONE. Thank you again

[mikkeljensen]

can you do the same thing, but with time