Gantt Chart Maker Excel Template: Build a Project Plan

Charts & pivot tables · Updated November 20, 2026

Yes. You can make a Gantt chart in an Excel template by listing tasks, start dates, and durations, then using conditional formatting to shade the dates each task spans. In Microsoft Excel for Microsoft 365 on Windows, a simple version needs no add-in or chart object; the bars update as you change task dates or durations.

What an Excel Gantt chart template does

A Gantt chart lays project tasks against a calendar. Each task appears as a horizontal bar: its position shows when it starts, and its length shows how long it is scheduled to take. Excel does not provide a dedicated Gantt chart type in the same way it provides a column or line chart. Common Excel templates instead use a date grid with conditional formatting, or a stacked bar chart configured to hide the series that represents the start date.

A date-grid template is often the easiest place to begin. It keeps task names and dates in ordinary worksheet cells, so you can sort, filter, edit, and format the plan without building a chart axis. You can make the grid yourself or look in Excel under File > New and search for Gantt templates. Available templates can vary by account, installation, and region, so a search result is not guaranteed.

Set up the task table

Start with a blank worksheet and create a small task table. For a basic schedule, use these columns:

  • A: Task — a concise activity name.
  • B: Owner — the person or team responsible, if useful.
  • C: Start — the scheduled start date, entered as an Excel date.
  • D: Duration — the number of calendar days the task occupies.
  • E: Finish — a calculated final date.

Put headings in row 4 and tasks in rows 5 through 20, for example. Keep one task per row and enter durations as positive whole numbers. If a task begins on January 5 and lasts three calendar days, its finish date is January 7: the start day is counted as day one. That inclusive convention is why the finish calculation subtracts one. Format columns C and E as dates, and D as a number.

With each task’s start date in C5 and its duration in D5, enter this in E5 and fill down: =C5+D5-1. For a start date of January 5, 2026, and a duration of 3, the result is January 7, 2026. Check that dates are real Excel date values rather than text; text that merely looks like a date may not calculate as expected.

Create the calendar timeline

Reserve columns G onward for the timeline, leaving column F as a visual gap if you like. Put the first date in G4, then add one day per column to the right. A formula can select the earliest task start automatically. This assumes the task start dates are in C5:C20; enter the formula in G4, then format the cell as a date. If the earliest start is January 5, 2026, the result is that date.

With start dates in C5:C20, enter =MIN($C$5:$C$20) in G4. In H4, enter =G4+1 and fill right for as many days as the project horizon requires. If the project starts on January 5, 2026, H4 returns January 6, 2026. The dollar signs keep the source range fixed when you copy the formula. If the task list is empty, MIN can return an unexpected date-like value, so add tasks before relying on the timeline or enter the first timeline date manually.

Format the timeline headings as dates. A compact format such as d-mmm can make daily columns easier to read, while a format including the year is safer when the plan crosses into another year. Widen columns enough to show the headings, and use a consistent timeline interval: daily columns for short projects, or weekly columns for longer plans. For a weekly view, use a single date per week as the column heading and adjust the bar rule to match the week’s start and end; a daily rule copied unchanged will not represent a whole week accurately.

Shade task bars with conditional formatting

The bar is a visual fill applied when a timeline date falls between the task’s start and finish dates. First select the full date grid, such as G5:AZ20, adjusting the last column and row to fit your plan. In Excel for Microsoft 365 on Windows, choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter the rule below, select a fill color with Format, and confirm. The references assume timeline dates are in row 4, task start dates are in column C, finish dates are in column E, and the selected grid begins at G5.

For the selected range G5:AZ20, use =AND(G$4>=$C5,G$4<=$E5). Excel evaluates the date at the top of each column against the start and finish dates for that row. The dollar sign before 4 holds the timeline row steady as the rule moves down; the dollar signs before C and E hold the date columns steady as it moves across. The row numbers remain relative so each task gets its own dates.

After applying the rule, cells from January 5 through January 7 will be shaded for a task that starts January 5 and finishes January 7. If no bars appear, check the rule’s Applies to range, verify that the date headings and task dates are numeric dates, and confirm that finish dates are not earlier than start dates. If the range starts somewhere other than G5, revise the formula references so they correspond to its top-left cell.

Make the template easier to use

Formatting can make a simple schedule much more readable without changing its calculations. Consider these practical improvements:

  • Use bold or a contrasting fill for the header row, and distinguish weekends with a separate conditional-formatting rule if the daily grid is wide.
  • Apply filters to the task table so an owner or workstream can be shown on its own. Keep the date-grid columns outside the filtered task table if filtering would otherwise hide part of the timeline.
  • Freeze the task headings while scrolling. Select G5, then choose View > Freeze Panes > Freeze Panes to keep the rows above and columns to the left visible. Menu labels can differ slightly across Excel platforms.
  • Use a clear fill for task bars and a different style for milestone dates. Avoid too many colors; if color communicates task status, include a text status column as well.
  • Set a useful print area and landscape orientation if people need a paper copy. A long daily timeline may need to be split across pages, so check Print Preview rather than assuming the whole schedule will fit.

Excel for Mac also supports formulas and conditional formatting for this design. Ribbon organization and some dialog layouts can differ from Windows, and Excel for the web may present a simplified interface, but the core cell formulas work in current versions. If collaborators will edit the workbook in different versions, keep the template to common worksheet features and check its appearance in the versions they use.

Calendar days, working days, and dependencies

A frequent source of confusion is the meaning of duration. The basic formula above counts calendar days, including weekends. A three-day task starting Friday therefore finishes Sunday. That may suit a continuous operation, but it is not a three-working-day schedule for a Monday-to-Friday team.

For a plan based on working days, Excel’s WORKDAY function can calculate a finish date while excluding weekends. You can also supply a range of holiday dates as an optional argument. That approach needs a matching bar rule that treats the scheduled dates consistently; otherwise the displayed shaded cells may include weekend dates even though the duration excludes them. A simpler alternative is to keep the calendar-day grid and make weekends visually distinct, while clearly labeling the duration convention.

A bar chart also does not automatically establish task dependencies. If drafting should begin only after research is complete, the schedule needs a rule or process that links the draft’s start date to the research finish date. A static template will not reschedule every downstream task just because an earlier task slips unless you build those dependency calculations. For a small plan, entering and reviewing dates manually may be sufficient; for a complex schedule, dependencies, resources, and working calendars can become difficult to manage in a flat worksheet.

Choose a template that fits the project

Before selecting a template, check what it actually calculates. Some files include only a colored calendar grid; others have summary fields, status indicators, milestone rows, or formulas. A more elaborate layout is not automatically better if people cannot tell which fields they are expected to edit.

  • For a personal or small team plan: choose a lightweight daily or weekly grid with task, owner, start, and duration fields.
  • For a presentation: prioritize legible labels, a sensible date range, and restrained colors. Hide unused columns rather than shrinking text until it is unreadable.
  • For recurring project work: look for a structure that is easy to copy and reset, and document which cells contain inputs and which contain formulas.
  • For detailed scheduling: check whether the template supports working days, holidays, dependencies, and resource assignments. A basic bar grid may not.

Inspect formulas before entering important project information, especially in a downloaded workbook. Confirm that task rows and conditional-formatting ranges extend far enough, that blank rows do not create misleading bars, and that the date scale includes the complete schedule. Save a working copy before making structural changes, and avoid enabling macros unless you understand why the workbook needs them.

Excel Gantt templates compared with other options

A conditional-formatting template is flexible and familiar, but it is still a spreadsheet. It works well when a project has a manageable number of tasks and users want to edit the plan directly. Excel’s stacked bar chart approach is another option: it uses a hidden start-date series to offset a visible duration series. That chart can be easier to resize as a single graphic, but it usually takes more setup and may be less convenient for editing individual cells or showing a dense daily calendar.

Dedicated project-management software may be a better fit when a team needs automatic dependency scheduling, workload balancing, shared updates, alerts, or multiple project views. Those capabilities vary by product and plan. A spreadsheet is not inherently unsuitable, but a template should not be mistaken for a full scheduling system. Choose based on the work people need to coordinate, how often the schedule changes, and whether the workbook can be maintained reliably.

Common problems and how to avoid them

If bars shift or disappear, the cause is often a date stored as text, an incorrectly copied formula, or an incomplete conditional-formatting range. Check a sample date by changing its number format; if it does not behave like a date in calculations, re-enter it as a valid Excel date. Review Conditional Formatting > Manage Rules to inspect the rule and its Applies to range.

Another common problem is sorting only the task names or only one date column. Sort the complete task table so each task stays paired with its owner and dates. If the timeline formulas refer to a fixed start-date range, extend that range when adding rows; otherwise new tasks may not affect the first timeline date. Finally, protect the distinction between inputs and calculated cells: label them, use consistent formatting, and explain the duration convention so another person does not overwrite formulas or interpret the bars incorrectly.

Frequently Asked Questions

Is there a built-in Gantt chart maker in Excel?
Excel does not have a dedicated Gantt chart type in its standard chart list. You can use an Excel template, build a conditional-formatting date grid, or configure a stacked bar chart to create a Gantt-style view.

Can I make a Gantt chart in Excel without a template?
Yes. Create a task table, add a row of dates, and use a conditional-formatting formula to shade dates between each task’s start and finish. The method in this guide uses ordinary worksheet cells and formulas.

How do I show weekends in an Excel Gantt chart?
For calendar-day durations, weekends are part of the schedule and can remain shaded. To make them easy to identify, format weekend columns differently. For working-day durations, calculate dates using a working-day convention and make the visual rule consistent with it.

Can an Excel Gantt chart show task dependencies automatically?
Not in a basic template. It displays dates and durations, but it does not automatically reschedule dependent tasks unless you add formulas or use scheduling software designed to manage dependencies.

Why are my Gantt bars not appearing?
Check that start, finish, and timeline entries are real Excel dates, that the conditional-formatting formula points to the correct columns and header row, and that the rule applies to the whole intended date grid.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.