An Excel Gantt chart template lays out project tasks against dates, using horizontal bars to show when each task starts and how long it lasts. You can download a ready-made workbook or create a simple version in Microsoft Excel for Microsoft 365 by entering task dates and applying conditional formatting to a date grid.
What an Excel Gantt chart template shows
A Gantt chart is a schedule displayed as a timeline. Tasks appear in rows, dates run across columns, and a bar marks the dates assigned to each task. A template is the spreadsheet structure and formatting that make this view easier to create and update; it does not automatically know your project plan or resolve every scheduling decision.
Most useful templates include a task name, a start date, a duration or finish date, and a timeline. More detailed versions may also include an owner, status, percentage complete, priority, or predecessor task. For example, a small website project might list content approval, page design, development, and review. Bars make it easier to see overlapping work and gaps than a plain list of dates does.
Excel can make this visual with a formatted cell grid or with a stacked bar chart. A cell-grid Gantt chart is often easier to adapt for a compact project schedule; a chart-based version may be preferable when you need a conventional chart object for a report. Neither format replaces a project-management system when the plan requires extensive dependency management or automatic rescheduling.
How to choose a template
Choose a template based on how you will maintain and share the schedule, not just on how polished its preview looks. A one-page work plan with a dozen tasks has different needs from a multi-team project with hundreds of linked activities.
- Check the time scale. Daily columns suit short projects. Weekly or monthly columns keep a long-range plan readable, but show less detail.
- Look for editable inputs. Start dates, durations, and task names should be easy to distinguish from calculated fields and decorative formatting.
- Check the date logic. Confirm whether duration means calendar days or working days, and whether the finish date is inclusive.
- Inspect the status design. A progress indicator can be useful, but it should not be confused with the planned duration bar.
- Consider sharing and maintenance. A template with complicated formulas, macros, or many hidden sheets may be harder for colleagues to update.
Excel’s File > New page lets you search available templates, and Microsoft also publishes Excel templates online. Names and availability can change, so inspect the workbook after opening it: verify its date range, formulas, and instructions before entering project information. Make a copy first if you want to preserve the original template.
Plan the worksheet layout
A straightforward daily Gantt sheet can use columns A through D for task information and columns E onward for the timeline. Put task names in A, start dates in B, durations in C, and finish dates in D. Use row 1 for the timeline and rows 2 through 20 for tasks. Add labels in row 1 for the task-information columns, then enter actual Excel dates across the timeline header.
For this layout, treat duration as a count of calendar days, including both the start and finish dates. A task that starts June 8 and lasts five calendar days therefore finishes June 12. If your project uses working days, weekends and holidays need separate handling; do not label a calendar-day calculation as a working-day schedule.
With the task start date in B2 and its calendar-day duration in C2, enter this in D2 to calculate the inclusive finish date:
=B2+C2-1
For a start date of June 8, 2026, and a duration of 5, the result is June 12, 2026. Format B and D as dates, and make sure C contains a positive whole number. Copy the finish-date formula down the task rows. You can also omit column D if you do not need to display a separate finish date.
Build the Gantt chart with conditional formatting
In E1, type the first date you want the timeline to show. With the first timeline date in E1, enter this formula in F1 to make the next column one day later:
=E1+1
Copy F1 to the right across the timeline. The dates should advance by one day per column. Format the header cells as dates, and widen the columns enough to read the labels. If the project extends beyond the displayed dates, extend the timeline before relying on the chart.
- Select the task-and-date grid E2:AZ20, or select the equivalent range for your worksheet.
- On the Windows ribbon, choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.
- For a selected range beginning at E2, with dates in row 1, start dates in column B, and durations in column C, use this rule formula:
=AND(E$1>=$B2,E$1<=$B2+$C2-1)
Choose a fill color, confirm the rule, and check a few rows against their start and finish dates. The formula tests whether each timeline date falls between that task’s start date and inclusive finish date. The dollar signs keep the date row and task-input columns fixed as Excel applies the rule across the selected grid, while the row number changes for each task.
On Excel for Mac, conditional formatting is also available from the Home tab; the precise dialog appearance can differ by release. In Excel for the web, basic conditional formatting is available, though the rule-editing controls may differ from desktop Excel. If a rule is difficult to configure in the browser, open the workbook in the desktop app.
Customize the timeline and make it readable
Formatting turns a correctly calculated grid into a schedule people can scan. Keep the task-information columns visible while scrolling across dates: in Excel for Microsoft 365 on Windows, select the first timeline column or the cell immediately below and to the right of the rows and columns you want to keep visible, then use View > Freeze Panes > Freeze Panes. On Mac, Freeze Panes is also on the View tab, though the menu layout may differ.
- Use a clear, consistent date format such as a short month and day, and make the header row visually distinct.
- Shade weekends with a separate conditional-formatting rule if a daily calendar is crowded; keep the task-bar color easy to distinguish from weekend shading.
- Use a small number of colors with an explained meaning, such as one color for planned work and another for a flagged task.
- Add a title, project owner, and an as-of date so readers know what schedule they are looking at and when it was last reviewed.
A long project can become unwieldy if each day gets a column. Switch to weekly or monthly periods, or show a rolling window around the current work. The trade-off is precision: a monthly bar shows the broad plan but not the exact day a task begins. Avoid shrinking columns until dates and task labels are unreadable.
Show progress, milestones, and dependencies
A planned bar and a progress indicator represent different information. If a task was scheduled for ten days and is 40 percent complete, its planned bar still spans the scheduled ten days; progress describes how much work is done, not how much time has elapsed. A simple template can include a separate percentage-complete column and a status field, with updates made by the project owner.
Milestones are usually events with no duration, such as approval or launch. A duration-based rule will not draw a bar for a zero-day task. Represent a milestone with a symbol or a separate marker rule, and explain the symbol in a legend. Alternatively, model it as a one-day item if that suits the schedule, while making clear that the one-day bar is a display choice rather than a claim that the event takes a full day.
Dependencies describe work that must happen before other work can start. A basic cell-grid Gantt chart does not automatically move later tasks when a predecessor changes. You can add a predecessor column for reference, but dates still need review or formulas designed for the project’s scheduling rules. For a plan with many linked tasks, resource assignments, and frequent changes, a dedicated project-management tool is generally more suitable than manually maintaining a spreadsheet.
Common problems and how to prevent them
If bars do not appear, first check whether the start and timeline entries are real Excel dates rather than text. Then verify that duration cells contain numbers, that the conditional-formatting range includes the intended grid, and that the rule refers to the correct input columns and header row. A rule written for E2 will not work as intended if the selected range starts in a different column and the reference was not adjusted.
Other frequent problems include:
- Off-by-one finish dates: Decide whether the start day counts toward duration. The example formula above uses inclusive calendar days.
- Hidden work outside the window: A task may be scheduled correctly but start before or finish after the visible timeline.
- Unexpected weekend bars: The basic rule counts calendar days, so bars include Saturdays and Sundays when the dates fall within a task’s span.
- Overwriting formulas: Separate input columns from calculated columns, use clear headings, and consider protecting formula cells if many people edit the file.
- Conflicting colors: Several overlapping conditional-formatting rules can make the meaning unclear. Review the rules and document the color scheme.
When dates or task durations change, check both the displayed bars and any separate finish-date calculations. A chart that looks plausible can still be wrong if a copied formula points to the wrong row or if someone typed a date as text.
When Excel is enough—and when to use another tool
Excel is a practical choice for a small, relatively stable schedule, especially when the people involved already use spreadsheets and need a customizable summary. It is also useful for a first draft: task owners can review dates in a familiar format before a team commits to a more structured system.
Its limitations matter as complexity grows. A manually maintained sheet can make it difficult to track dependencies, resource conflicts, change history, notifications, and multiple versions of a plan. A project-management application may provide these functions directly, but can require setup, training, or a paid plan. A paper timeline or a simple task list may be adequate for a very small effort that does not need a visual calendar. Choose the simplest option that keeps dates and ownership clear.
Frequently Asked Questions
Does Excel have a built-in Gantt chart?
Excel does not provide a dedicated Gantt chart type in the same way it provides standard chart types. You can create a Gantt-style view with conditional formatting or adapt a stacked bar chart, and you can start from an available template.
Where can I download an Excel Gantt chart template?
Search from Excel’s File > New page or look for Excel templates on Microsoft’s template site. Availability can change, so check that a template opens in your version of Excel and inspect its formulas and date assumptions before using it.
Can I make a Gantt chart in Excel without a formula?
Yes. You can color timeline cells manually, but the bars will not automatically follow task dates. Conditional formatting uses a formula to update the bars as dates change, which is more practical for a schedule that will be revised.
Can an Excel Gantt chart skip weekends?
The basic example in this guide uses calendar days and includes weekends. A workday-based schedule needs a different date setup and rules for nonworking days; decide how holidays are handled as well, rather than assuming the calendar-day template excludes them.
Can Excel automatically reschedule dependent tasks?
A simple Gantt template will not automatically reschedule a network of dependent tasks. You can add formulas or update dates manually, but plans with many dependencies are often easier to maintain in project-management software.
Related
- Excel Shortcut for Inserting Rows Above or Below
- Excel Shortcut to Go to a Specific Column in Seconds
- Excel Shortcut to Insert a Cut Row
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Pivot Tables: How to Edit and UpdateTo change a pivot table in Google Sheets, click a cell inside it to open the Pivot table…
- Excel Gantt Charts: What’s Built In and How to Make OneExcel does not include a dedicated Gantt chart type, but you can make a Gantt chart with its…
- Google Sheets Chart With Two Y-Axes: Setup and TipsYes. In Google Sheets, you can put one data series on a second, right-side y-axis: open the chart…
- Excel Sparklines: Meaning, Types, and How to Use ThemExcel sparklines are miniature charts placed inside individual worksheet cells to show a small set of data as…
- Copy Sparklines from Excel to PowerPoint: Best MethodsTo copy sparklines from Excel to PowerPoint, select the cells that contain them, use Excel’s Home > Copy…
- Build an Org Chart From Excel Data: Steps and OptionsYes. You can build an org chart in Excel by choosing Insert > SmartArt > Hierarchy > Organization…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.