# How To Create A Gantt Chart Template In Excel?

A Gantt chart is a popular project management tool that is used to visualize and track progress over time. It allows you to plan and manage projects effectively by providing a clear picture of tasks, timelines, and dependencies. Excel is a widely used software program that provides a user-friendly platform for creating Gantt charts. In this tutorial, we will guide you through the step-by-step process of creating a Gantt chart template in Excel. By the end of this tutorial, you will have a solid understanding of how to create a Gantt chart in Excel, including how to input project tasks and timelines, add dependencies, and customize the chart to suit your needs. Whether you are a project manager or a business owner, learning how to create a Gantt chart in Excel will help you manage your projects more efficiently and effectively.

## Create A Gantt Chart Template

Here we will first calculate the duration and completed percentages, then create a chart, and finally add it as a template. So let us see a simple process to learn how you can create a Gantt chart template in Excel.

### Step 1

Consider an Excel sheet where you have data similar to the below image.

First, to calculate the duration, click on an empty cell, in our case, cell D2, and enter the formula as = then click and click enter to get the first values, and drag down using the autofill handle.

Empty cell > Formula > Enter > Drag.

### Step 2

Now to calculate % completed, click on an empty cell, in this case cell F2, and enter the formula as =E2/D2*100. Click enter, then drag down using the autofill handle to get all the values.

Empty cell > Formula > Enter > Drag.

### Step 3

Then select the range of cells, including the header, and click on insert, then select stacked bar chart.

Select cells > Insert > Stacked Chart.

Then the chart will be created as shown in the below image.

### Step 4

Finally, right-click on the chart and select "Save as Template," then enter the name and click "Save" to complete the task.

Right click > Save as template > Name > Save.

## Conclusion:

In this tutorial, we have used a simple example to demonstrate how you can create a Gantt chart template in Excel to highlight a particular set of data.

Updated on: 13-Jul-2023

91 Views

##### Kickstart Your Career

Get certified by completing the course