Excel Gantt Chart Sample: Build a Clear Project Timeline Fast

An Excel Gantt chart sample is a task list paired with a calendar timeline, where colored cells show when each task starts and finishes. In Microsoft Excel for Microsoft 365 on Windows, you can build one by entering task names, start dates, and durations, calculating finish dates, then applying conditional formatting to a date grid; the sample below gives you a practical starting layout.

What the sample shows

This example uses a small project with five tasks. Each row represents one task, and each column to the right represents one calendar day. The colored bars will span from the task’s start date through its finish date, making overlaps and the overall schedule visible at a glance.

Task	Start	Duration in calendar days	Finish
Kickoff	Jan 5, 2026	1	Jan 5, 2026
Requirements	Jan 6, 2026	3	Jan 8, 2026
Design	Jan 9, 2026	4	Jan 12, 2026
Build	Jan 13, 2026	8	Jan 20, 2026
Review	Jan 21, 2026	3	Jan 23, 2026

The dates are illustrative, not a recommended schedule. The duration column counts both the start date and finish date: a three-day task beginning Jan 6 ends Jan 8. This convention is why the finish-date formula subtracts one. If your organization defines duration differently, decide on that rule before filling in the workbook.

Set up the task data

Open a blank workbook and put the task information in columns A through D. Use row 1 for headings: Task, Start, Duration, and Finish. Add one task per row, beginning in row 2. Enter actual Excel dates in column B rather than text that only looks like a date; a date entered as text may not work correctly in calculations or conditional formatting.

Column A: concise task names, such as Requirements or Build.
Column B: the planned start date.
Column C: duration as a positive whole number of calendar days.
Column D: a calculated finish date.

For the example, place the five tasks in rows 2 through 6. Format columns B and D as dates using Home > Number Format, then choose a date format that is easy to scan. You can make the task list an Excel table with Home > Format as Table. A table makes it easier to add rows and maintain consistent formatting, although the timeline’s conditional-formatting range may need to be extended when new tasks are added.

Calculate finish dates

With start dates in B2:B6 and durations in C2:C6, enter =B2+C2-1 in D2, then fill the formula down through D6. For the Build example, B5 is Jan 13 and C5 is 8, so the formula returns Jan 20, 2026: Jan 13 counts as day one, and Jan 20 is day eight. Excel stores dates as serial numbers, so adding a number to a date advances it by that many calendar days.

Check that durations are greater than zero and that the finish date is not earlier than the start date. If a task lasts zero days, it may be better to show it as a milestone rather than treat it as a bar with a normal duration. This sample uses calendar days, so weekends are counted. If your team plans only on working days, see the scheduling note below before relying on the displayed dates.

Create the date timeline

Reserve row 1 from column E onward for daily dates. Enter Jan 5, 2026 in E1, then fill later dates across the row. One way is to enter the next date manually and drag the fill handle; Excel recognizes the sequence. To calculate each next day instead, with E1 containing Jan 5, 2026, enter =E1+1 in F1 and drag it to the right. F1 returns Jan 6, 2026. Format the timeline cells as dates, and make the columns narrow enough to display a useful span without crowding the task names.

For a short project, a daily scale is readable. For a schedule lasting several months, daily columns can make the sheet unwieldy. You can instead show week-start dates or month labels, but the bar logic must then match the timeline’s time unit. A weekly view needs a clear convention—for example, a week is shaded if it overlaps any part of a task—not simply a daily rule copied unchanged.

Display task bars with conditional formatting

Select the timeline cells for the task rows, such as E2:AC6 if your visible dates run from E through AC. On the Home tab, choose Conditional Formatting > New Rule > Use a formula to determine which cells to format. With dates across row 1, start dates in column B, and finish dates in column D, enter =AND(E$1>=$B2,E$1<=$D2) as the rule formula. Choose a fill color in the formatting options and confirm the rule.

For a cell such as E2, the rule checks whether the date in E1 falls on or after B2 and on or before D2. If both conditions are true, Excel colors the cell. The dollar signs keep the timeline date on row 1 and the start and finish columns fixed, while the row numbers can adjust for each task. Make sure the formula’s first cell, E2, matches the top-left cell of the selected range; using a different starting reference can shift the bars.

To improve readability, freeze the task names while scrolling: select E2, then choose View > Freeze Panes > Freeze Panes. You can also use borders or alternating row shading, but keep the bar color distinct from the rest of the grid. The conditional-formatting bar is a visual schedule, not a separate chart object, so changing the date grid or rule range affects what is shown.

Show progress, milestones, and ownership

A basic Gantt grid answers when tasks are scheduled; it does not automatically say whether they are on track. Add columns for Owner, Status, or Percent Complete if the audience needs that information. Keep these fields separate from the date grid so that a colored schedule bar is not mistaken for proof that work has been completed. Update the status from project information, and include an as-of date when sharing a snapshot.

Milestones are usually zero-duration events, such as approval or launch. Since the sample’s bar rule expects a start and finish date, a milestone may not be visible as a useful bar. You can represent it with a symbol in the timeline, a separate milestone column, or a distinct rule that highlights the milestone’s date. Be explicit about the symbol’s meaning in a legend. Similarly, if you add a progress bar inside the scheduled bar, distinguish planned duration from completed work so readers do not confuse the two.

Working days, dependencies, and schedule limits

The example counts calendar days and does not calculate task dependencies. That makes it suitable for a simple visual plan, but it is not a full project scheduling system. If a task must begin only after another task finishes, Excel will not automatically move it when the earlier task changes unless you build a dependency formula or update the dates yourself. For a small plan, manual dates can be transparent; for a changing project, record dependencies and review downstream dates when the schedule changes.

For work schedules that exclude weekends, Excel’s WORKDAY function can calculate a finish date from a start date and a number of working days, and it can also account for a holiday list. Its day-count convention differs from the inclusive calendar-day example, so verify the desired treatment of the start date before replacing the formula. You may also need to use a working-day-aware rule for the bar display. A bar based on calendar dates can still shade weekends even when the work duration excludes them.

For larger projects, a spreadsheet can become hard to maintain: many tasks, linked dependencies, resource assignments, and frequent baseline changes increase the chance of inconsistent updates. Excel is useful for a lightweight plan or a shareable snapshot, but it does not provide every scheduling and collaboration feature found in dedicated project-management tools.

Common problems and practical checks

Dates appear as numbers: Excel may be displaying date serial values. Select the cells and apply a date format from Home > Number Format.
No bars appear: Check that start and finish cells are real dates, the selected conditional-formatting range includes the timeline, and the rule references the correct top-left cell.
Bars are shifted: Confirm the dollar signs in the rule formula and make sure the timeline dates are in row 1 while task dates are on the matching task row.
The last day is missing: Check whether the finish-date calculation and the rule both include the finish date. The sample’s formula and rule are inclusive.
New tasks are not colored: Extend the conditional-formatting rule’s Applies to range, or set up the range to cover the number of task rows you expect to add.
Weekend work looks misleading: Decide whether the schedule uses calendar days or working days, then make the duration calculation and displayed timeline consistent.

Before sharing the workbook, test a short task with a known start and finish date, inspect the first and last colored cells, and check the view at normal zoom. Add a small legend stating what the bars mean and whether weekends are included. These checks help prevent a polished-looking sheet from communicating an unintended schedule.

When to use a chart or another tool

The conditional-formatting layout above is often called a Gantt chart, but it is technically a date grid with formatted cells rather than a native, specialized Gantt object. That distinction is useful: grid cells are easy to edit and can be customized, while a standard chart may offer different visual controls but take more setup to align task labels with date ranges.

Choose the spreadsheet version when the schedule is modest, the audience already works in Excel, and people need to edit dates directly. Consider a dedicated project-planning tool if you need automatic dependency scheduling, resource workload views, shared updates, alerts, or a detailed baseline-versus-current comparison. A static image or PDF may be appropriate for a read-only report, but it will not update when the underlying dates change.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel includes templates that may be available through its template gallery, but the exact selection can vary. The sample here builds a Gantt-style view directly in a worksheet with task dates and conditional formatting, so you can adjust the layout yourself.

Can I make a Gantt chart in Excel without a template?
Yes. Enter tasks, start dates, and durations; calculate finish dates; add dates across the columns; and use a conditional-formatting formula to shade cells that fall within each task’s date range.

Can Excel automatically update dependent tasks?
Not from the simple sample alone. The dates are entered as a plan, so changing one task does not automatically reschedule later tasks. You would need to add dependency logic or update dates manually, and should check all affected tasks after a schedule change.

How do I make the Gantt chart show weeks instead of days?
Use a weekly timeline and decide how a task is represented when it overlaps only part of a week. A daily rule cannot always be transferred unchanged: weekly shading should reflect your chosen overlap convention, and the week labels should clearly identify the dates they cover.

Will this work in Excel for Mac or Excel for the web?
The worksheet formulas and conditional formatting concept are standard Excel features, though the ribbon layout can differ by platform and version. The steps above give the Microsoft 365 Windows path; on Mac or in Excel for the web, look for the equivalent Conditional Formatting controls if the command is arranged differently.

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.