Excel does not include a ready-made Gantt chart type, which makes the chart feel harder than it needs to be. You still have several solid ways to build one inside Excel, from Microsoft templates to stacked bar charts, worksheet grids, Copilot, and add-ins.
Start with the template option if you need a project timeline fast. Use the manual methods when you want more control over dates, bars, formatting, and task order.
1. Start with an Excel Gantt template
This fixes the fastest path problem when you want a working project timeline without building the chart yourself.
- 1.Open Excel.
- 2.Go to File > New.
- 3.Click the Search for online templates field.
- 4.Search for Gantt.
- 5.Choose a Gantt chart template.
- 6.Select Create.
- 7.Replace the sample task names, start dates, durations, status or progress fields, and timeline scale with your own project details.
2. Open Microsoft Create in your browser
For Excel on the web, go to the Microsoft Create Gantt charts page and select Start with a template. Pick Simple Gantt chart, Agile Gantt chart, Gantt project planner, or View all templates, then choose Use this template or Edit. Enter your task names, starting dates, durations, status or progress, and adjust the timescale.
3. Build one with a stacked bar chart
This fixes Excel's missing Gantt chart type by turning a regular stacked bar chart into a Gantt-style timeline.
- 1.Create a worksheet with task names, start dates, and durations.
- 2.Select the data range.
- 3.Go to Insert > Recommended Charts.
- 4.Choose a Stacked Bar chart.
- 5.Select the first data series, which is the start-date part of the bar.
- 6.Go to Format > Shape Fill > No Fill.
- 7.Delete the legend or chart title when you do not need them.
- 8.Control-click or right-click the vertical axis.
- 9.Choose Format Axis..., then set Axis position > Categories in reverse order.
4. Make a timeline grid with conditional formatting
A cell-grid Gantt chart puts the timeline directly into worksheet cells. Create task columns for task names, start dates, and end dates or durations, then add timeline date headers across the sheet. Select the timeline cells and go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format, then enter a TRUE/FALSE formula, adjusted to your sheet. If column C holds an end date, use =AND(E$1>=$B2,E$1<=$C2). If column C holds a duration in days instead, use =AND(E$1>=$B2,E$1<$B2+$C2) - Excel stores dates as serial numbers, so comparing a date directly against a plain duration number leaves every cell unfilled. Choose Format > Fill, pick a color, and confirm with OK.
5. Speed it up with Quick Analysis
This fixes the extra clicking when you want to reach formatting options faster.
- 1.Select the timeline cells in your sheet.
- 2.Click the Quick Analysis button, or press Ctrl+Q.
- 3.Open Formatting.
- 4.Choose a formatting option.
- 5.For a real date-range Gantt grid, finish with Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.
6. Ask Copilot in Excel to help
- 1.Open the workbook that contains your task table.
- 2.Select the Copilot icon in the lower-right corner of Excel.
- 3.Ask Copilot to build a data table and stacked bar chart, generate a Gantt chart from the task table, extend timeline columns, create task-dependency columns, or customize the time scale.
- 4.Review, edit, and verify the result before using it.
Copilot in Excel requires an eligible license and a supported Excel app, and availability can still vary with your organization's settings. Microsoft counts these as eligible: a Microsoft 365 Personal or Family subscription with an AI credits plan, a Microsoft 365 Premium subscription, a commercial Microsoft 365 Copilot subscription, or a Copilot Chat-eligible business or enterprise subscription. If the Copilot icon is missing, check your app version, license, network, and privacy settings. On Microsoft 365 Personal, Family, and Premium, Copilot in Excel also needs AutoSave turned on, which means saving the workbook to OneDrive first - it does not work on unsaved files.
7. Add a Gantt chart add-in
- 1.In Excel desktop, go to Home > Add-ins > More Add-ins.
- 2.Use the Store tab or search box to find a Gantt add-in, such as ProjectSheet - Gantt chart.
- 3.Select the add-in.
- 4.Choose Add, Try, or Buy, then follow the prompts.
- 5.Open it later from Home > Add-ins or My Add-ins and follow the task-pane workflow.
8. Remove an add-in you no longer need
To remove an Office add-in, use Home > Add-ins > More Add-ins > My Add-ins, select the add-in, then choose Remove > Remove. For an Excel add-in on the ribbon, right-click the add-in on Home and choose Remove Add-in. For a COM add-in, use File > Options > Add-ins > Manage > COM Add-ins > Go. Clearing the checkbox and selecting OK only unloads the add-in from memory - its name stays in the list and the files stay on your computer. To drop it from the list and delete it from your computer, select the add-in name in the Add-ins available box and choose Remove.
9. Skip the built-in Gantt chart hunt
- 1.Do not look for a built-in predefined Gantt chart type in Excel.
- 2.Microsoft says Excel does not have one.
- 3.Use a Microsoft Gantt template, Microsoft Create template, stacked bar chart, conditional-formatting grid, Copilot, or an Office add-in instead.
Frequently Asked Questions
Can I create a Gantt chart in Excel for free?
Yes. Use Excel for the web templates with a Microsoft account or Microsoft 365 account. Microsoft also provides official Excel pages for web access, mobile access, sign-in, subscriptions, and app downloads.
Which Excel versions support these Gantt chart methods?
Microsoft lists the template and stacked bar chart methods for Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, and Excel 2016. Excel 2019 and Excel 2016 appear for Windows only, with no Mac entries.
Should I use a template or make the chart manually?
Use a template for the fastest result. Build the stacked bar chart manually when you want to control the data range, chart formatting, and task order yourself.
Can my workplace block Gantt chart add-ins?
Yes. Microsoft 365 admins can control Office Store add-in access and deploy approved add-ins centrally. Microsoft says deployed Office Add-ins can take 24 to 72 hours to appear.
