Learn how to make a basic gantt chart in Excel, and download an automated Excel gantt chart template to save time: [ Ссылка ].
Watch this step-by-step tutorial to learn how to make a basic gantt chart in Excel from scratch. Or create a free gantt chart even faster with 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.
TeamGantt is a collaborative project scheduling tool that makes creating gantt charts as simple as drag and drop. It’s free forever, and you can make a gantt chart online in minutes! Sign up for your free account: [ Ссылка ]
------------
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!
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
