Gantt chart excel tutorial youtube. If you liked this video and want to see more content added to this channel contribute to my patreon account. Dates and times are stored as numbers in excel and count the number of days since january 0 1900. In this video i have explained how to make a gantt chart in microsoft excel. Add duration data to the chart.
A gantt chart in excel. You can use excel 2016 to create a gantt chart usin. In this excel 2016 tutorial you will learn how to make a gantt chart in microsoft excel 2016 step bystep. Excel gantt chart.
My gantt chart in excel tutorial is easy to learn and apply. As you can see in the screenshot below start date is already added under legend entries seriesand you need to add duration there as well. 15 jul 2017 end is the same as 42931. Demo on how to create a gantt chart in excel.
Right click anywhere within the chart area and choose select data from the context menu. Right click the dates on the chart click format axis and fix the minimum bound to 42887 maximum bound to 42931 and major unit to 7. Gantt chart tutorial in microsoft excel 2013excel gantt chart tutorialgantt chart tutorialhow to make a gantt chartin this tutorial we will show you how to c.