A Gantt chart is a practical tool that helps project managers map out tasks over time, showing start and end dates, dependencies, and progress. It’s essential for keeping teams aligned, spotting scheduling conflicts early, and ensuring that every phase of a project stays on track. It's one of the most common formats for an Excel timeline used in project planning.
With a Gantt chart, you get a clear, at-a-glance view of your entire project timeline — making it easier to manage resources, deadlines, and stakeholder expectations.
Follow our step-by-step tutorial below to make a Gantt chart in Excel, or you can download a free Excel Gantt chart template to get a head start.
How to create a Gantt chart in Excel
Play Video
What is an Excel Gantt chart?
An Excel Gantt chart is a horizontal bar chart built inside a Microsoft Excel spreadsheet that maps project tasks against a timeline. Each bar represents a single task, with its position and length showing the start date, end date, and duration. When you line up every task on the same Excel chart, you get a visual snapshot of the full project schedule including what's happening now, what's coming next, and where tasks overlap.
A typical Excel Gantt chart includes these core components:
- Task names: a description of each activity
- Start and end dates: when each task begins and wraps up
- Durations: the total number of days (or weeks) each task requires
- Dependencies: which tasks need to finish before others can start
- Milestones: key deadlines or checkpoints that mark major progress
Options for making a Gantt chart in Excel
Microsoft Excel has a Bar chart feature that can be formatted to make an Excel Gantt chart. If you need to create and update a Gantt chart for recurring communications to clients and executives, it may be simpler and faster to create it in PowerPoint.
On this page, you can find each of these two options documented in separate sections. First, we will give you step-by-step instructions on how to create a Gantt chart in Excel by starting with a Bar chart. Then, we will also show you how to instantly create an executive Gantt chart in PowerPoint by pasting or importing data from an .xlsx file.
Which tutorial would you like to see?
Step-by-step tutorial: How to make a Gantt chart in Excel
1. List your project schedule in an Excel table.
a) The first step in learning how to create a Gantt chart in Excel is building a clean project data table. Break down the entire project into chunks of work, or phases. These will be called project tasks and they will form the basis of your Gantt chart.
b) In Excel 2013, 2016 and 2019, enter your data by listing the Start Date and Finish Date of each task, along with their duration (count of days required to complete that task). Make sure to include a brief description for each task, and then sort them in order, by placing the earliest start date first and the latest date last, as shown in the image below.
In this tutorial, we will convert this table into an Excel Gantt chart and then into a PowerPoint Gantt chart. Read on to learn how.
2. Begin making your Excel Gantt by setting it up as a Stacked Bar Chart.
a) Within the same worksheet that your Excel table is on, click in any blank cell — this is the starting point for creating a Gantt chart in Excel using the Stacked Bar method.
b) From the Excel ribbon, select the INSERT tab.
c) In the Charts section of the ribbon, drop down the Bar Chart selection menu.
d) Then select Stacked Bar, which will insert a large blank white chart space onto your Excel worksheet (do not select 100% Stacked Bar).
3. Add the start dates of your tasks to the Gantt chart.
a) Right-click the white chart space and click Select Data to bring up Excel's Select Data Source window.
b) On the left side of Excel's Data Source window, you will see a table named Legend Entries (Series). Click on the Add button to bring up Excel's Edit Series window where you will begin adding the task data to your Gantt chart.
c) Now we're going to add your task data.
i. First, we need to name the data (Series) we will be entering. 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.
ii. Staying in the Edit Series window, move down to Series value. This is where you will enter your Task start dates. It is easy to do. To the right of the Series values field you will see an icon with an arrow pointing up.
Click on the icon and Excel will open a smaller Edit Series window. Now simply click the first start date in your task table and drag your mouse down to the last start date. This highlights all of the start dates for your tasks and inputs them into your Gantt chart. Make sure you have not mistakenly highlighted the header or any extra cells.
iii. When finished, click on the arrow icon again. This will return you to the previous window called Edit Series. Once here, click OK. Your Gantt should now look like this:
4. Add the durations of your tasks to the Gantt chart.
a) Stay in the Select Data Source window and re-click the Add button to bring up Excel's Edit Series window. Here is where you will add the duration data to your Gantt chart.
b) In the Edit Series window, click in the empty field under the title Series Name and then in your task table again, on the column header that reads Duration.
c) Staying in the Edit Series window, move down to Series value and click once more on the spreadsheet icon with a black arrow on it (called Edit Series Button). Select your Duration data by clicking on the first duration in your project table, and drag your mouse down to the last duration so all durations are now highlighted.
d) To exit, click again on the small spreadsheet icon with the black arrow, which will return you to the previous window. Select OK and you should now be back in the Select Data Source window. Click OK again to update your Gantt chart which should now look something like this:
5. Add the descriptions of your tasks to the Gantt chart.
a) Right-click on one of the blue bars in the Gantt chart, then click on Select Data again to bring up the Select Data Source window.
b) On the right side of Excel's Data Source window, you will see a table named Horizontal (Category) Axis Labels. Select the Edit button to bring up a smaller Axis Label windows.
c) Again, click on the small spreadsheet icon. Then click on the first name of your tasks (in our example, the first task description is "Preparatory Phase") and select them all. Be careful not to include the name of the column itself. When you are done, exit this window by clicking on the small black arrow icon again.
d) Click OK and then OK again to exit the Select Data Source window. Now your Gantt chart should have the correct task descriptions next to their respective bars, and should look something like this:
6. Format your chart so it looks like a Gantt chart.
Up to this point, you have really built a Stacked bar chart. Now we need to format it so it looks like a Gantt chart. To do that, we must make the blue parts of each task bar transparent so only the orange parts will be visible. These will become the tasks of your Gantt chart.
a) To select all of the task bars at once, click on the blue part of any bar in your Gantt chart, then right-click and select Format Data Series, which will bring up the Format Data Series window in Excel.
b) In the Format Data Series task pane, click on the Fill & Line icon (it looks like a paint can) to get the Fill & Line options. Under Fill, tick the No Fill radial button and, under Border, choose the No Line option. Don't close the Format Data Series task pane because you're going to use it in the next step.
Your Gantt chart should now look like this:
c) You will probably notice that the tasks on your Gantt chart are listed in reverse, with the last task on top of the Gantt chart and the first task listed at the bottom. However, you can easily arrange them in counter direction in Excel.
i. To do so, click on the list of tasks along the vertical axis of your Gantt chart. This will select them all and it will also open the Format Axis task pane.
ii. Here, in the Format Axis task pane, click on the Bar Chat icon to expand out the Axis Options menu.
iii. In the Format Axis task pane, under the header Axis Options and the sub-header Axis Position, tick the checkbox called Categories in reverse order.
7. Finish your Gantt chart with these styling tips.
Now that you've finished creating a Gantt chart in Excel, you can further style it to optimize its layout and legibility. Here are a few suggestions in this respect.
c) Make the task bars on your Gantt chart thicker
Right-click on the first task bar and choose Format Data Series to open the Format Data Series control. Under the Series Options header, you will find the Gap Width control. Sliding it up or down will increase or reduce the size of the task bars on your Gantt chart. Play around until you find something that best works for you.
c) Make the task bars on your Gantt chart thicker
Right-click on the first task bar and choose Format Data Series to open the Format Data Series control. Under the Series Options header, you will find the Gap Width control. Sliding it up or down will increase or reduce the size of the task bars on your Gantt chart. Play around until you find something that best works for you.
d) Customize task bars and chart area
As a finishing touch, you may want to add a title to your Gantt chart, change the color of the task bars or use another type of text font. In our case, we chose to:
recolor the chart bars from orange to a dark blue by double-clicking on any of the bars, going to the Fill & Line section of the Format Data Series pane on the right, and using the Fill color option menu;
use Bold font for the text of the task descriptions. If you want to do the same, simply click on the titles to select them all, and then press Ctrl + B;
add a title to the graphic by selecting the chart area, clicking on the “+” button in the upper right corner, and then ticking the box in front of Chart Title. This will insert a text box at the top of your Gantt in which you need to double-click in order to continue typing in the name for your visual.
With these finishing touches, your Excel gantt chart is ready for client presentations or team reviews.
Download Excel Gantt chart template file
To help you get started quickly, we have included a practical Excel Gantt chart template that you can download for free to learn how to create Gantt charts in Excel.
Get this free Gantt chart template
Free Excel Gantt chart templates
Whether you're managing a complex project or mapping out a simple Excel schedule, these free Excel Gantt chart templates give you a head start. Each template is fully customizable: just enter your data and you have a professional Gantt chart visual ready to share.
Project Gantt chart template for Excel
Best for: Project managers tracking tasks, dependencies, and milestones across the full project lifecycle.
Template features: A versatile Excel Gantt chart template with pre-built columns for task names, start dates, end dates, and durations. Ideal for teams who need a clear visual of the project schedule without spending time formatting charts from scratch. Import into Office Timeline for a polished PowerPoint version.
Simple Gantt chart template for Excel
Best for: Anyone who needs a quick, no-frills Gantt view of a short project or task list.
Template features: A clean, minimal template for creating a Gantt chart in Excel in minutes. Perfect for status updates, internal check-ins, or whenever you need a visual summary without the overhead of a full project management tool.
Construction project Gantt chart template for Excel
Best for: Construction managers and contractors coordinating multi-phase builds with sequential dependencies.
Template features: Map out every phase of your build, from permitting to punch list, on a clear Excel timeline template. This template highlights task durations and workstreams so you can identify scheduling conflicts before they become costly delays.
Agile sprint Gantt chart template for Excel
Best for: Scrum masters and agile teams tracking sprints, releases, and iteration milestones.
Template features: An agile-friendly Gantt chart Excel template structured around sprints rather than traditional project phases. Track sprint goals, ceremonies, and release dates in a single view.
Step-by-step tutorial: How to make a Gantt chart in PowerPoint
PowerPoint is a more graphical tool and a better choice for making Gantt charts that will be used in client and executive communications. If your Excel Gantt chart needs to look polished for executives, PowerPoint is a stronger presentation layer. Office Timeline is a PowerPoint add-in that makes and updates Gantt charts by importing or pasting from Excel.
You can copy-paste, import and refresh the data from your Excel tables in PowerPoint. In the steps below, we will demonstrate how to turn the Excel table you created above into a PowerPoint Gantt chart by using Office Timeline’s free 14-day trial.
1. Open PowerPoint and paste your table into the Office Timeline wizard.
a) Inside PowerPoint, navigate to the Office Timeline tab and click the New button.
This will open a gallery that will allow you to choose a style or template for your Gantt chart.
Copy your project's details, including Start Date, End Date and Description, from the Excel table you made earlier. You can copy them all at once but be sure not to copy the title.
c) Copy your project's details, including Start Date, End Date and Description, from the Excel table you made earlier. You can copy them all at once but be sure not to copy the title.
d) Now simply paste the data into PowerPoint using the Office Timeline Paste button. Then, make any edits you wish (change colors or shapes, add or remove items, etc.) and click Create.
2. Your Excel table will be converted into a PowerPoint Gantt chart.
a) Depending on the style or template selected, you will have a Gantt chart that looks like this:
b) From here, you can easily customize the Gantt chart further, adding milestones, formatting fonts and colors, and adding various details like percent complete or notes. It is easy to do in Office Timeline. In our example, we used Office Timeline to add milestones, move task titles and date texts, change shapes, and add percent complete.
Download PowerPoint Gantt chart template file
If you’d like to use the Gantt chart created in this guide as a template to help you move faster, you can download the file below, free of charge.
Get this free Gantt chart template
How to make a PowerPoint Gantt chart from Excel in under 2 minutes
Play Video
FAQs about making Gantt charts in Excel
Here are the answers to the most frequently asked questions in relation to making Gantt charts in Microsoft Excel.
To make a Gantt chart, follow these 7 steps:
- List all project tasks. Break your project into individual tasks or deliverables (also called a Work Breakdown Structure).
- Set start and end dates. Assign a start date and duration to each task.
- Identify task dependencies. Determine which tasks must finish before others can begin (e.g., Task B depends on Task A).
- Assign owners. Designate a team member or resource responsible for each task.
- Decide your time scale. Use days, weeks, or months, depending on project length.
- Draw or build the chart. Plot each task as a horizontal bar spanning its start-to-end date on the timeline. Use tools like Excel or dedicated Gantt makers like Office Timeline.
- Update as the project progresses. Track completion by shading or filling each bar as work is done.
The result is a visual Gantt chart showing what needs to happen and when, making it easy to spot bottlenecks and delays at a glance.
To learn how to create a Gantt chart in Excel that you can use as a template in the future, follow the steps below:
- List your project data into a table with the following columns: Task description, Start date, End date, Duration.
- Add a Stacked Bar Chart to your Excel spreadsheet using the Chart menu under the Insert tab.
- Add the start and end dates of your tasks to your stacked bar chart.
- Add the duration of your tasks to the graphic.
- Add the task descriptions to your Excel stacked bar chart.
- Format the stacked bar chart to make it look more like a Gantt chart by turning the blue segment of the bars transparent.
- Improve the legibility of the Gantt chart by:
- bringing the task bars closer to the vertical axis of the chart;
- adjusting the density of the task dates;
- thickening the task bars to reduce the white space.
- Go to File → Save As and choose Excel Template (.xltx) to save your Gantt chart as a template.
As shown in the tutorial above, Excel doesn’t have any predefined Gantt chart templates per se, but it allows you to create a basic Gantt sample by manually formatting a stacked bar chart.
Alternatively, if you want to save time and make a Gantt chart faster, you can do so by importing or pasting your data from Excel into PowerPoint.
No, Excel doesn't have a built-in Gantt chart type. You can build one manually by formatting a Stacked Bar Chart (as shown in our tutorial), but every element — task bars, date ranges, formatting — has to be set up by hand. If you're looking for a faster way to create an Excel Gantt chart, Office Timeline lets you paste or import your Excel data directly into PowerPoint and generates a polished Gantt chart in under two minutes. You keep full control over styling, colors, and layout without the manual formatting overhead.
