This is where you will enter your Task start dates. Staying in the Edit Series window move down to Series value. Click and place your cursor in the empty field under the title Series name, then click on the column header that reads Start Date in your table. First we need to name the data (Series) we will be entering. Click on the Add button to bring up Excel's Edit Series window and here you will begin adding Task data to your On the left side of Excel's Data Source window you will see a table named Legend Entries (Series). Right-click the white chart space and click Select Data to bring up Excel's Select Data Source window. Select Stacked Bar which will insert a large blank white chart space onto your Excel worksheet (do not select 100% Stacked Bar).ģ. Add the start dates of your Tasks to the Gantt chart In the Charts section of the ribbon, drop down the Bar Chart selection menu. Then from the Excel ribbon, select the INSERT tab. In this tutorial, I will convert the following table into an Excel Gantt chart and a PowerPoint Gantt chart:Ģ. Begin making your Excel Gantt by setting it up as a Stacked Bar chartįrom the same worksheet that your Excel table is on, click in any blank cell. Make sure to sort these tasks in order, by placing the earliest start date first and the latest start date last. Also include a brief description of the task. In Excel 2007, 2010, 2013 or 2016, enter your data by listing the Start Date and Finish Date of each task, and also it's Duration (count of days required to complete that task). These will be called project tasks and they form the basis of your Gantt chart.

Download Excel Gantt chart template How to make a Gantt chart in Excel 1. List your project schedule in an Excel tableīreak down the entire project into chunks of work, or phases.

Microsoft office timeline 2013