Gantt Chart Excel Tutorial - How to make a Basic Gantt Chart in Microsoft Excel 2016

hello everyone and welcome to another video tutorial today we will be talking about how to build a Gantt chart in Microsoft Excel 2016 the first thing that we're gonna want to do is calculate the duration for each task we're gonna do that in column D so go ahead and label that duration and then simply take the difference between the two dates and we want that for each task so just drag that down next we're gonna want to actually start building the chart and we're gonna do that with the start date data so highlight b1 to be nine click insert charts all charts bar and then stacked bar next we're going to want to include the duration data in the actual stacked bar chart so right click anywhere in the chart click select data add and then your series name will be duration your series values will be your duration values and since we're already here we can include the axis labels as well and those are just all of your tasks ok next we're going to want to click on our start date data in the actual bar chart which is all the blue and then click no filled ok after that we're gonna want to flip these tasks because we can see that Project kickoff should be our first task and it's actually all the way at the bottom so to do that you're just gonna want to right-click on the tasks click format axis and then categories in reverse order okay and then finally we just want to clean up this date range a bit right now if you didn't know this already Excel starts counting dates from 1 1 1900 and we can see that just by formatting this as either general or number we can see that it's a 1 and the way that we clean up this date is we pass in the minimum and maximum bounds that we want so the first thing we should do is just take our earliest start date and our latest end date and just format these is either a general or number okay and we're gonna want to pass in these values into our minimum and so our minimum is four to seven three six and our maximum is four to eight five zero okay and that just cleans up the date range a bit so there you have it here's your Gantt chart thank you for watching please make sure to like share and subscribe and go ahead and comment what you'd like to see next thank you

Channel: Pandi Mengri

Views: 1,011,254

Keywords: gantt chart excel, gantt chart excel 2016, gantt chart excel 2013, gantt chart excel 2010, gantt chart excel 2007, gantt chart for project management, gantt chart example, how to make a gantt chart, how to make a gantt chart in excel 2007, how to make a gantt chart in excel 2010, how to make a gantt chart in excel 2013, how to make a gantt chart in excel 2016, microsoft project gantt chart tutorial, how to make a gantt chart in microsoft project, ExcelIsFun, excel campus

Id: xsxi4qaEnOg

Length: 2min 36sec (156 seconds)

Published: Sun Oct 22 2017