Excel Gantt Chart Schedule: Create and Track Projects

An Excel Gantt chart schedule is a task list paired with a date-based timeline, where colored cells show when each task starts and finishes. In Microsoft Excel for Microsoft 365 on Windows, enter task names, start dates, and finish dates, create a row of dates across the sheet, then use Home > Conditional Formatting > New Rule to color timeline cells that fall within each task’s dates.

What an Excel Gantt chart schedule shows

A Gantt chart turns a project plan into a visual schedule. Tasks appear as rows, calendar dates run across columns, and horizontal bars show the planned span of each task. For example, a website project might list research, design, development, and testing in separate rows. The bars make it easier to see which activities overlap, when the project begins and ends, and where a gap or crowded period may exist.

Excel does not have a dedicated Gantt chart type in its standard chart menu. A common approach is to build the schedule directly in worksheet cells and use conditional formatting to draw the bars. This is flexible: task names and dates remain ordinary data that can be sorted, filtered, edited, and summarized. The trade-off is that you must set up and maintain the timeline and formatting yourself.

A Gantt chart is a planning view, not a guarantee that dates are achievable. It can display the plan, but it does not automatically resolve resource conflicts, calculate every dependency, or alert a team when a task is late unless you build those checks into the workbook.

Set up the task and date columns

Start with a simple table. Put headers in row 1 and one task per row below them. For a small project, use columns A through E like this:

A: Task — a concise activity name, such as “Approve wireframes.”
B: Start — the planned start date, stored as an Excel date rather than text.
C: Duration — the number of calendar days, if you plan to calculate the finish date.
D: Finish — the planned finish date.
E: Complete — optional progress entered as a percentage, such as 40%.

For example, enter “Approve wireframes” in A2, a start date in B2, and 4 in C2. If the duration means calendar days and the start day counts as day one, use this formula in D2, assuming the task start date is in B2 and its duration in calendar days is in C2: =B2+C2-1. With a start date of 1 June and a duration of 4, the finish date is 4 June. Copy the formula down for the other tasks. Format the date columns as dates so Excel displays them clearly.

Calendar days include weekends. If your duration is measured in Monday-to-Friday workdays instead, use WORKDAY. With the start date in B2 and the number of working days in C2, enter this formula in D2: =WORKDAY(B2,C2-1). For a one-day task, the result is its start date; weekends are skipped when the task spans them. To exclude a holiday list in J2:J20 as well, use this formula with the same task layout and holiday dates in J2:J20: =WORKDAY(B2,C2-1,$J$2:$J$20). Check that the holiday range contains actual Excel dates, not text.

Create the timeline and colored task bars

Reserve row 1 from column F onward for the timeline. In F1, enter the earliest start date for the project. One way to calculate it is to use the task start dates in B2:B20. With those dates in place, enter this formula in F1: =MIN($B$2:$B$20). In G1, with the first timeline date in F1, enter =F1+1, then copy G1 to the right for as many days as you want to display. Format the timeline cells as dates. You can widen the columns or use a short date format to keep the schedule legible.

To draw the bars, select the grid where task rows meet timeline dates—for example, F2:AZ20—and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Assuming timeline dates are in row 1, task start dates are in column B, and finish dates are in column D, enter this formula: =AND(F$1>=$B2,F$1<=$D2). Choose a fill color and confirm the rule. Excel adjusts the references across the selected grid: the timeline row stays fixed, while the task row changes for each row. Cells whose dates fall between the task’s start and finish are colored.

In this example, F:AZ is simply a display range; it may not cover every project. Extend the selected grid and timeline far enough to include the latest finish date. A rule only formats cells in its applied range. If you add tasks later, extend the rule to their rows as well, or convert the task table to an Excel Table and manage the schedule range deliberately.

Show progress and working days

Progress is useful when it is clearly distinguished from the planned duration. One option is to add a second conditional-formatting rule that uses a darker fill for the portion of a task bar considered complete. With start date in B2, finish date in D2, completion percentage in E2, and timeline dates in row 1, this formula marks dates from the start through the calculated progress point: =AND(F$1>=$B2,F$1<=$B2+ROUNDUP(($D2-$B2+1)*$E2,0)-1). Apply it to the same timeline grid and give it a darker fill than the overall task bar. Put the progress rule above the general bar rule in Manage Rules so the darker fill takes precedence. Enter completion as a percentage from 0% to 100%; this display is an estimate based on elapsed task days, not a measure of effort or value delivered.

For tasks that run only on workdays, decide whether the timeline should still show weekends. A calendar-day timeline can include weekend columns even when a task’s finish date uses WORKDAY; those cells may be colored as part of the task’s date span. To make nonworking days visually distinct, shade weekend columns with a separate conditional-formatting rule or use a weekly timeline. A weekly view is less detailed but can be easier to read for projects that last several months.

Excel’s WORKDAY and WORKDAY.INTL functions can calculate a finish date that skips nonworking days. WORKDAY uses Saturday and Sunday as the weekend. WORKDAY.INTL lets you specify a different weekend pattern, which can help with schedules that use different workweeks. Make the team’s definition of a workday explicit: a formula cannot infer local holidays, company shutdowns, or an individual’s availability unless those dates are supplied.

Represent dependencies without overstating them

Most projects contain relationships between tasks. A design review may need to finish before development begins, for example. A basic cell-based Gantt chart displays dates but does not automatically move dependent tasks when an earlier date changes. You can record a predecessor in another column, such as “Design review,” but that entry alone does not create a working dependency.

For a small plan, manually set the next task’s start date after checking its predecessor’s finish date. If you use formulas to link dates, document the logic and test how it behaves when durations change. More complex plans may require dependency types, lag time, resource assignments, and a critical-path calculation. Those needs are signs that a visual worksheet may be insufficient; a project-management application can model and update relationships more directly.

Also distinguish a task’s duration from its effort. A task scheduled across five workdays does not necessarily require five full days of labor. If several people share the work or a task is intermittent, the bar communicates its planned calendar span, not the number of hours spent. Add separate effort or owner fields if readers need that information.

Make the schedule readable and useful

A schedule is only helpful if people can scan it and understand what they are seeing. Use clear task names, consistent date formats, and a restrained color scheme. Keep the task list in chronological or workstream order rather than relying on bar color alone to communicate status. Add a legend if different fills represent planned work, progress, milestones, or delays.

Freeze the labels: use View > Freeze Panes so task names and headings remain visible while scrolling across a long timeline. Select the cell below and to the right of the rows and columns you want frozen before choosing the command.
Highlight milestones: represent a milestone as a one-day event or mark it with a separate symbol or color. Explain the convention so readers do not mistake it for a task with a longer duration.
Use filters carefully: Excel Tables can make task lists easier to sort and filter, but hiding task rows can make the schedule appear incomplete. Keep filters visible and tell readers when a view is filtered.
Prepare a print view: use Page Layout options to set orientation and scaling, and check Print Preview. A long daily timeline may print too small on one page; splitting it across pages or switching to weekly columns can preserve readability.

Avoid making every visual distinction depend on color alone. Include a status label such as “Not started,” “In progress,” or “Blocked,” and use readable contrast. This helps readers interpret the schedule when printed in grayscale or viewed by someone who has difficulty distinguishing colors.

Common problems and practical fixes

If the bars do not appear, first check that start and finish values are real dates. A value that looks like a date but is stored as text may not compare correctly with the timeline. Select the cells and inspect the formula bar; also verify that the conditional-formatting rule applies to the intended range and that its references match the actual columns and rows.

If every task appears on the same dates, check the row reference in the conditional-formatting formula. In the example formula, F$1 fixes the date-header row, while $B2 and $D2 fix the date columns but allow the task row to change. A misplaced dollar sign can cause Excel to compare every row with the same task’s dates.

If a bar ends one day too early or late, confirm how duration is counted. The formula for calendar days subtracts one because the start date counts as the first day. A duration of one therefore ends on the start date. If your organization defines duration differently, adjust the calculation and state the convention in the workbook.

If the schedule becomes slow or hard to maintain, reduce unnecessary formatted cells and avoid applying rules to entire columns when only a limited project range is needed. Review Home > Conditional Formatting > Manage Rules for duplicate or conflicting rules. When dates are updated frequently, keep the task data in a consistent table and make sure the timeline and rule ranges cover the new dates and rows.

When Excel is the right tool—and when it is not

Excel is a practical choice for a personal plan, a small team schedule, a classroom assignment, or a project where people need a familiar workbook and a simple visual overview. It is easy to tailor columns, add notes, and share a copy. It is also useful for a first draft before a team decides whether it needs a more formal planning system.

Its limits become important when multiple people need to edit a schedule at once, dependencies must recalculate automatically, resources must be balanced across projects, or status needs to connect to reporting systems. A workbook can be shared through Microsoft 365, but sharing does not turn conditional formatting into project-management logic. For a larger or changing project, compare the time spent maintaining the spreadsheet with the value of software designed for schedules, collaboration, and dependency management.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel includes templates that may be suitable starting points, depending on the templates available in your installation. The worksheet-cell method described here does not depend on a particular template and lets you control the task fields, dates, and formatting yourself.

Can Excel automatically update a Gantt chart when dates change?
Conditional formatting updates the colored bars when the dates in the task table change, provided the rule covers the relevant cells. It does not automatically reschedule dependent tasks unless you create formulas or other logic to calculate those dates.

How do I make a Gantt chart show only working days?
Use WORKDAY or WORKDAY.INTL to calculate finish dates that exclude nonworking days, and supply a holiday range if needed. You can also hide or visually de-emphasize weekend columns, but ensure the timeline’s display agrees with the date calculations and your team’s work calendar.

Can I show task completion in an Excel Gantt chart?
Yes. Add a completion-percentage column and use a separate conditional-formatting rule to color the completed portion of each bar. Treat that visual as a simple estimate based on the chosen date calculation; it may not represent actual effort or deliverables.

Why does my Gantt chart show dates but no bars?
Check that the start and finish cells contain valid Excel dates, the rule’s applied range includes the timeline grid, and the formula references the right columns. Also confirm that each finish date is on or after its start date and that the timeline extends far enough to include the task.

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.