A basic Gantt chart template in Excel is a task list paired with a calendar grid, where colored cells show when each task is scheduled. In Microsoft Excel for Microsoft 365 on Windows, enter task names, start dates, and finish dates, then use conditional formatting to color the matching date cells; you can build the template without a special add-in.
What a basic Excel Gantt chart includes
A Gantt chart turns a project schedule into a visual timeline. Each row represents a task, and each column represents a day, week, or other time period. A horizontal bar across a task row indicates its scheduled duration. Unlike a simple list of due dates, the chart makes overlap and gaps between work easier to spot.
A useful starter worksheet has two parts: project information on the left and the calendar grid on the right. For example, set up these columns in row 4, then put the date headings from column F onward:
- A: Task name
- B: Start date
- C: Finish date
- D: Duration in calendar days, if useful
- E: Owner or status, if useful
- F onward: One column for each day or week in the schedule
Put the first task in row 5 and continue down the sheet. For example, a task called Draft outline might start on March 2 and finish on March 4. If the calendar headings include those dates, the chart colors three cells in that task’s row. The left-hand dates remain the source schedule; the colored bar is a visual representation of them.
Build the worksheet and date scale
Start with a blank workbook and type the column headings and task information. Enter actual Excel dates in the start and finish columns, not text that merely looks like a date. You can check by changing a cell’s number format: a genuine date will display differently, while text will not behave like a date in calculations or conditional formatting.
- Enter task names in A5:A20, start dates in B5:B20, and finish dates in C5:C20. Adjust the row count to fit your project.
- Choose the first date to display and type it in F4. Type the next calendar date in G4, select both cells, and drag the fill handle to the right to extend the sequence.
- For a weekly schedule, use week-start dates instead of daily dates. Enter the first week’s date in F4, the next week’s date in G4, select both, and fill right. Keep the dates consistent so each column has a clear meaning.
- Optionally calculate task duration in D. With a start date in B5 and finish date in C5, put this formula in D5 and fill it down:
=C5-B5+1. If B5 is March 2 and C5 is March 4 of the same year, the result is 3 calendar days because both endpoints are counted.
That duration formula counts calendar days, including weekends. For a workday-only duration, the answer depends on the project’s workweek and holidays; do not label a calendar-day count as working days. A basic chart can leave duration out entirely if the start and finish dates are enough for readers.
Color the schedule with conditional formatting
Conditional formatting creates the bars automatically from the task dates. Select the full date grid for your task rows, such as F5:AI20, before creating the rule. The exact range depends on how many days and tasks your chart contains. In Excel for Microsoft 365 on Windows, use Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.
For a daily calendar with date headings in row 4, start dates in column B, and finish dates in column C, use this rule formula:
=AND(F$4>=$B5,F$4<=$C5)
Choose a fill color, confirm the rule, and check that it applies across the selected grid. The references are deliberate: F changes as the rule moves across the calendar, while the 4 keeps the header row fixed; B and C stay as the date columns, while row 5 changes for each task. The test colors a cell when its column date is on or after that task’s start date and on or before its finish date. If a task runs March 2 through March 4, the three corresponding daily cells are colored.
For a weekly chart, decide what the bar means. A straightforward convention is to color a week when the task overlaps any day in that week. If F4 contains the week’s starting date and each later heading is seven days later, use this formula instead:
=AND(F$4<=$C5,F$4+6>=$B5)
It checks whether the week’s last date is on or after the task start and the week’s first date is on or before the task finish. A task that overlaps even part of a week will therefore color that week. Make the week-start convention visible in the heading or a note, so a bar does not imply more date precision than the schedule provides.
Format the chart so it is easy to read
Keep task names and dates visible while scrolling. To freeze the first four rows and first five columns, select F5 and choose View > Freeze Panes > Freeze Panes. The selected cell determines which rows above and columns to the left remain in place. If the chart is short, freezing panes may not be necessary, but it becomes valuable when a schedule spans many weeks or tasks.
Use a consistent date format in the header, such as abbreviated month and day, and widen the task-name column enough to avoid excessive clipping. A subtle fill for weekends or month boundaries can help distinguish time periods, but keep it visually lighter than the task bars. Add a title, project start date, and a small legend if more than one bar color has a meaning. For instance, use one color for planned work and a separate color only if you also create a clearly defined status convention.
Do not rely on color alone to communicate important status. Include text such as Not started, In progress, or Complete in a separate status column, especially if the file will be printed or viewed by people with color-vision differences. Use readable contrast, avoid a large palette, and check the worksheet in print preview if it will be shared on paper.
Choose daily, weekly, or monthly columns
The calendar scale should match the level of detail people need to manage. Daily columns suit short projects where a one-day shift matters, but the chart becomes wide quickly. Weekly columns work well for projects planned in broad phases and can keep a multi-month schedule compact. Monthly columns are suitable for a high-level roadmap, but they hide day-level timing and can make short tasks appear to last a whole month.
For example, a two-week event setup may need daily columns to show venue access, equipment delivery, rehearsals, and the event itself. A six-month software rollout may be clearer by week, with work grouped into research, design, build, and launch. If a task is shorter than the column interval, the bar still indicates overlap, not its exact length. Explain that limitation in the sheet rather than suggesting weekly blocks are precise daily plans.
Set the displayed range to include a little space before and after the scheduled work when useful. That gives the chart room for an early start or a revised finish, but an enormous unused calendar makes the active schedule harder to scan. You can add columns later by extending the date sequence and the conditional-formatting range.
Track progress without confusing it with the plan
A basic Gantt chart shows planned timing; it does not automatically prove that work is complete. Keep planned start and finish dates intact if you need to compare the original plan with actual performance. Add separate columns for actual start, actual finish, percent complete, or status when those details matter. Otherwise, changing a task’s dates to reflect new expectations can erase the history of the original schedule.
One simple approach is to retain the planned bar and use a status column for updates. Another is to build a second visual layer for actual progress, but that requires extra columns or additional formatting rules and clear instructions. Avoid implying that a partially filled bar is an accurate percentage complete unless the worksheet has a defined method for calculating and displaying that progress.
Review the schedule at an agreed interval and update dates based on confirmed information. If one task depends on another, record the dependency in a separate column or note. The basic template does not automatically move a later task when an earlier task slips, so someone must review the relationship and make the appropriate schedule change.
Common problems and practical fixes
- No bars appear: Check that the date headers and task dates are real Excel dates, the rule covers the calendar cells, and the formula refers to the correct header row and start/finish columns.
- Bars appear on the wrong rows: Confirm that the task’s start and finish references use the task’s row, as in $B5 and $C5, rather than locking the row number for every task.
- The finish date looks one day short: Check whether the schedule is using an inclusive finish date. The daily rule above includes both the start and finish dates.
- Only part of the chart changes: Extend the rule’s Applies to range when you add task rows or calendar columns. In Excel, open the conditional-formatting rule manager from Home > Conditional Formatting > Manage Rules.
- The chart is too wide to print: Use weekly columns, print in landscape orientation, or print only the active date range. Scaling a very wide daily chart onto one page can make its text unreadable.
Another frequent misconception is that a Gantt chart is automatically a project-management system. This simple worksheet visualizes dates, but it does not inherently manage workload, calculate a critical path, send reminders, or resolve resource conflicts. Those needs call for additional structure or a different tool.
When Excel is enough—and when to choose another tool
Excel is a practical choice for a small project, a one-off schedule, or a team that needs a flexible file and already uses spreadsheets. It is easy to tailor the columns, print a snapshot, and share a workbook. A simple template also helps people understand the plan without learning specialized software.
As a project gains many linked tasks, multiple owners, frequent changes, or a need for shared live updates, maintaining the chart manually can become unreliable. Dedicated project-management applications may offer dependencies, notifications, workload views, permissions, and change tracking. Those features are not guaranteed in every product, so compare the specific capabilities and costs before moving a workflow. A shared Excel workbook can still be sufficient when the schedule is modest and one person is responsible for keeping it current.
Frequently Asked Questions
Does Excel have a built-in Gantt chart template?
Excel may offer Gantt-style templates through its template gallery, with availability depending on the Excel version and connected template services. You can also make a basic chart in a blank workbook with a task table and conditional formatting, as described above.
How do I make a Gantt chart in Excel without a formula?
You can color date cells manually, but the colors will not update automatically when task dates change. Conditional formatting is the more maintainable option; its rule formula is entered once and then applied throughout the selected schedule grid.
Should the Gantt chart finish date include the last day of work?
Usually, yes: if a task runs from March 2 through March 4, treat March 4 as the final included date. The daily rule in this template uses that inclusive convention, so it colors three date cells.
Can I use weeks instead of days?
Yes. Create weekly date headings and use the weekly overlap rule. Each colored block then means the task overlaps that week; it does not mean the task lasts for all seven days.
Why does my Gantt chart not update when I change a task date?
Check that the changed value is a valid date, the conditional-formatting rule still applies to that cell, and the start date is not later than the finish date. If you added rows or columns, expand the rule’s Applies to range.
Can Excel show task dependencies in this basic template?
It can record predecessors in an extra column, but the basic chart does not automatically link tasks or reschedule them when a predecessor changes. You need to update affected dates yourself or use a more advanced scheduling approach.
Related
- Excel Merge Two Cells Into One Cell Without Losing Text
- Excel: Merge Data From Multiple Cells Into One Cell
- Excel Merge Cells Option Not Available? Causes and Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Adding Sparklines in Excel: Steps, Types, and TipsTo add a sparkline in Excel for Microsoft 365 on Windows, select the cell where it should appear,…
- Gantt Chart in Excel: How to Insert One Step by StepTo insert a Gantt chart in Excel, arrange each task with a start date and duration, then insert…
- Excel Trendline Equation Doesn’t Match Data?If an Excel trendline equation seems not to match your data, first check whether the chart label has…
- Excel Bar of Pie Chart: How to Configure ItTo configure a Bar of Pie chart in Excel for Microsoft 365 on Windows, select a category-and-value data…
- How to Change Legend Names in an Excel PivotChartTo change a legend name in an Excel PivotChart, rename the field caption or item that supplies the…
- Excel Pivot Chart: Remove “Sum of” From LabelsTo remove “Sum of” from a PivotChart legend label in Excel for Microsoft 365 on Windows, rename the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.