![excel 2016 gantt project planner tutorial excel 2016 gantt project planner tutorial](https://3.bp.blogspot.com/-CISsTrSBaE0/VuCB04AMJRI/AAAAAAAAEiw/VJ8PVUUzWZ8/s1600/Project-Tracker-Excel.png)
![excel 2016 gantt project planner tutorial excel 2016 gantt project planner tutorial](https://i.pinimg.com/originals/e1/e8/b6/e1e8b6ec6975bc5c2817002e97ac80e5.jpg)
![excel 2016 gantt project planner tutorial excel 2016 gantt project planner tutorial](https://www.heritagechristiancollege.com/wp-content/uploads/2019/05/free-excel-gantt-chart-template-2016-of-excel-gantt-chart-template-2016-of-free-excel-gantt-chart-template-2016.png)
The MS Project Gantt Chart has the dates at the top of the chart, not the bottom. Now don’t leave the Format Axis dialog box as we can do the next part as well.ī) Select the Number options on the left, and then choose the Date Category on the right and select a short date format from the Type picklist. Also, change the major unit equal to 7 so that it shows weekly dates. Then from the Axis Options on the left, change the Minimum to the same number as your earliest Project Plan Task Start Date in a number format that you see in the Fill series. Your Excel Gantt Chart will now look like this:Īlmost done as it looks like a Gantt Chart, but we need to fix the Axis formatting in the next tutorial steps.Ī) Right click on the Horizontal Axis on the bottom and click on “Format Axis…” Right Click on the Fill data series in the Excel Chart and select “Format Data Series…” from the Pop-up Menu:įrom the Format Data Series dialog box, you should select the Fill Options on the left and then choose “No Fill” on right. This step makes it look very close to a Microsoft Project Gantt Chart. The next step is where your Excel Gantt will really take shape. Then go to the Insert Ribbon and in the Chart Group, Select a 2-D Stacked Bar Chart from the Bar Button. Highlight the Gantt Chart data range including the column headers from Cell E2:G6. Your final Gantt Chart Data area should look like this: You need to highlight your Fill series and change the Number Format to General or Number.
![excel 2016 gantt project planner tutorial excel 2016 gantt project planner tutorial](https://soulcompas.com/wp-content/uploads/2020/07/gantt-project-planner-excel-template-download.jpg)
IMPORTANT: This is an important step when building your Gantt Chart Data Area. I am creating a range outside of your project plan for the Excel chart so that it is easier to graph, but it is not necessary.Ī) Create a column of data called “Task Name” and then copy the Task Name from your project plan data in the spreadsheet.ī) Create a column of data called “Fill” and then copy the Start Date from your project plan data in the spreadsheet.Ĭ) Create a column of data called “Days” and then put in a formula that Subtracts your task Start Date from the Finish Date (in the graphic below the formula for cell G3 =C3-B3. In order to make a Gantt Chart, you need to create a different range that you will use for the Excel Gantt Chart. So create some sample data like this to try it out: But if you try and graph it now, it won’t give you what you want. You will probably have data that looks like this and you want to create a Gantt Chart. So how do we and how can you do this? Read this tutorial to find the 7 easy steps.ĥ) Change the Horizontal Axis Minimum, Major Unit and Number FormatĦ) Change the Vertical Axis to Category in Reverse Orderħ) Chart Clean Up: Remove the Chart Legend and the Vertical Gridlines Here is a sample of a Gantt Chart from Microsoft Project : So it is a natural to consider how you too can make a Gantt Chart in Excel. They also love Microsoft Excel, Charts and Graphs. Project Managers and Executives love Gantt Charts.