All you need to do is plug in your tasks and the dates, and you'll have a presentation-quality Excel gantt chart. Want to learn how? First, download the Excel gantt chart template, then watch the video above. How to create a gantt chart in Excel Want to learn how to build an Excel gantt chart from scratch? Follow along with the instructions below on how to create a gantt chart in Excel. Please note that we performed the following steps in Excel 2016, but the basic workflow should be the same in any version of Excel with minor changes. Prepare the Excel worksheet for your gantt chart Insert a stacked bar chart Format the gantt chart and its data Change the colors of your task bars 1. Prepare the Excel worksheet for your gantt chart Create columns for Task Name, Start Date, End Date, and Duration, and fill those cells with information from your project. Then, format the columns as the following: Task Name column = text Start Date and End Date = formatted as a date Duration column = number TIP: It's best to have the Duration field calculate the appropriate duration of the task based on the start and end dates.
Please note that has financial relationships with some of the merchants mentioned here. may be compensated if consumers choose to utilize the links located through the content on this site and generate sales for the said merchant. Disclosure: Not an access card.