This opens the Select Data Source dialog. Let’s populate the chart with our task data. The new chart will be a block of white space, like this: Step 3: Add start dates to the chart Next, click on Insert tab > Bar Chart > Stacked Bar Chart. Instead, we’ll create one using a stacked bar chart.
Here’s a sample worksheet for a simple construction project: Step 2: Set up a stacked bar chartĮxcel does not come with an inbuilt Gantt chart template. Each task should be defined with a task name, start date, and duration (the number of hours, days, weeks, or months it’s going to last). It takes eight steps to make a Gantt chart in Excel.
Let’s get into it! How to Make a Gantt Chart in Excel: Step-by-Step Guide Make a Gantt chart in Excel in eight steps.If you’re interested in functionality rather than the look of your Gantt Charts, read on to learn how to: And the charts aren’t great looking.īut even though Excel doesn’t create the prettiest charts, it helps you get the job done. It isn’t easy and quick (as you’ll see next).
Although it comes with limitations, creating a Gantt Chart in Excel is still the go-to charting method for many professionals.
