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

In this Microsoft Excel 2013 tutorial I show you how to make a basic Gantt Chart. This is a basic Gantt Chart that shows the time frame of a project and the time frame of the individual task that are to be performed. This Gantt Chart is basic so it doesn’t show the progress of the project. If you would like to see an Excel tutorial on how to create a Gantt Chart that shows the progress of a project you can find it by searching through my videos.

hjttp://roofstampa.com
http:/www.subjectmoney.com

hey guys welcome to Excel for noobs comm in this tutorial I'm gonna show you how to create a basic Gantt chart in Microsoft Excel 2013 now what a Gantt chart is is a chart that shows the timeframe of an overall project broken down by the each individual by each individual task then the project is to consist of showing the time frame that each task is to take from start date to finish all right so you can see here first we have to enter in our data into Excel before we can even create our chart so here I have three columns I have a task column these are all of my tasks tests one through eight the project is to consist of we have the start date these dates dates represent the day that each task is to start so task 8 will start on July 15th and then we have the days of complete column showing how long each project is to last so prom or each task is to last task 8 should last 12 days so if I starts on July 15th task 8 should urge task 8 should end on July 27th ok so we have our data now we can go ahead and get started creating our chart what we're going to do is click the insert button and and the chart the insert tab and in the charts group we are going to select our insert bar chart which is like a sideways bar chart basically okay so we click the insert bar chart and we are going to click on you can do either 2d stacked bar chart or 3d stacked bar chart so I'm going to click on the 3d stacked bar chart and then you can see that a blank chart area appears in the chart area I will now right-click and in the shortcut menu I'm going to click on select data ok so you can see the select data source dialog box appears you can also see that our chart area and select data source dialog box is kind of blocking our data over here so we're going to move that of the way but first let's enter in our first series right here in legend entries we're going to click the Add button and the edit series dialog box will appear with a box for series name and series name we're going to enter we're going to select the start date column header and then and series values are going to remove the default data and we're going we're going to enter in the we're going to select the range of cells that has our start dates and then we'll click OK ok now I'm going to click OK so I can move this out of the way and so I can also get this chart out of the way ok now in the blank area of the chart somewhere up here I'm going to right click again to get to the Select data source dialog box and you can see I'm clicking on select data and it appears just now I can access my data over here alright now we need to add a new series we're going to click the Add button and in series name I will select days to complete and series values again remove the default data and select the range of cells that has our days complete click OK and again we're back at our select data source dialog box now on the horizontal axis label click the edit button and I'm going to select task 1 through task 8 and click OK now we have all of our data so we can close our select data source dialog box ok so you can see that we're on our way to having a Gantt chart we're just going on ok you can see we're on our way to having a Gantt chart I'm just kind of resizing it now you can see a few problems our task right here in reverse order so we need to fix that we have these blue bars here which represent the start date and then we have our dates which there's a large gap see our project is going to start on May 22nd we don't really want our chart the bounds of our dates to go all the way to April 16th so we want to remove that we want this chart we want to remove those uh these boundaries these these gaps with dates so the first thing we're going to do is just get our we want to get our tasks in the right order so just click right here on the tasks and then right-click and click on format axis and the shortcut menu and then the the axis options will appear over here to the right the format axis dialog box and in axis position you're going to click categories and reverse order okay so the first problem is solved now let's get rid of these bars there's nothing going on during this time for these projects so we don't need any bars there to represent anything all we want is two we want bars that represent the task when they're going to be when they will the time frame of the task so we click on the bars which represent the start date and then we're gonna right click and then click format data series and the format data series dialog box appears we will click on the fill button and then we'll select no fill then we can close this all right final problem let's get rid of this gap in the dates so we just look to get rid of this padding of the date so I mean you can see it's more than a month the chart shows a date that's more than a month before I start date so let's get rid of that so we click on the dates let me right click and again select format axis okay you can see over here our bounds these are our dates these numbers represent our dates actually let me close this and kind of explain how dates work I'm going to copy this date and enter into another cell May 22nd or start date now I'm going to convert this to a number format and you can see that our dates are actually represented by a number and that's how it works dates in Excel are represented by a serial number system so the number the serial number for May 22nd 2013 is 40 1416 and that's where we want our chart to start so just we're going to keep that there so we remember that number so again click on the dates right click format access and then here and the minimum bound we will enter the date that we want our chart bounds to show so we're custom manually entering in that number which represents May 22nd 2013 and we hit enter and there you can see now our chart starts on May 22nd 22nd 2013 we can close that and then we remove this and now you can see that we have our Gantt chart here now all you have to do is you can change different formatting to the chart so we go to the design and we can change the layout I like this layout I can change the title and you can mess around and change the color and anything else you want to change alright thanks for watching guys now you know how to make a basic Gantt chart in Microsoft Excel 2013 don't forget to check out all of our other tutorials and we also have a more advanced tutorial on how to create a Gantt chart that is that automatically shows the progress of a project and each task it shows the day's completed of each task and it shows the days remaining for each task and it's automated using the now function and a nested-if function so be sure to look that up alright thanks for watching and have fun with it so

39 thoughts on “Gantt Chart Excel Tutorial – How to make a Basic Gantt Chart in Microsoft Excel 2013”

  1. Hi, is it possible to add another activity on the same line further in time? For instance Task F has a duration from 10-jan to 19-jan; but also a duration rom 14-feb to 23-feb. ? I tried a bit but I couldn't figure it out. Thank you, I am happy to hear from you. Regards, Koen

  2. i have row with numbers 1,0,1,1,1,0,1,0,0,1,1,1,1 who is even longer if i look in history. is there any whey in excel what can help me find next number according of previous data, maybe there is some macro who can read history data and when it ends continue independently to make numbers according of previous data. Or you know better whey how i can get solution of this problem. hope you can help me. Thank you for your other videos they are really useful.

  3. Lovely Video clip! Sorry for chiming in, I would appreciate your thoughts. Have you considered – Weydaniel Organized Dominator (erm, check it on google should be there)? It is a great one off product for getting 7000 plus project management and business templates without the headache. Ive heard some super things about it and my cousin after many years got excellent results with it.

  4. Great video content! Sorry for the intrusion, I would appreciate your thoughts. Have you tried – Weydaniel Organized Dominator (erm, check it on google should be there)? It is a good one off guide for getting 7000 plus project management and business templates without the normal expense. Ive heard some amazing things about it and my buddy at very last got astronomical results with it.

  5. Appreciate video content! Excuse me for chiming in, I am interested in your opinion. Have you ever tried – Weydaniel Organized Dominator (search on google)? It is an awesome one off guide for getting 7000 plus project management and business templates minus the headache. Ive heard some pretty good things about it and my cousin after a lifetime of fighting got amazing results with it.

  6. When my group gave me a role to do a Gantt chart I nearly quit college,.. but when i watched this and did mine I was thrilled as to how my Chart came out… Thank you so much, stress reliever….!!!!

Leave a Reply

Your email address will not be published. Required fields are marked *