Project Tracker Spreadsheet With Gantt Chart: How to Build

Yes. In Microsoft Excel for Microsoft 365, a project tracker spreadsheet can show task names, owners, start and finish dates, progress, and a Gantt-style timeline. The simplest version uses a date grid and conditional formatting to shade the cells between each task’s start and finish dates; it is flexible, but it is not a dedicated built-in Gantt chart type.

What a project tracker and Gantt chart show

A project tracker is a structured list of work. It records what needs to be done, who is responsible, when the work is planned, and whether it is on track. A Gantt chart adds a time-based view: each task appears as a horizontal bar spanning its scheduled dates. Together, the table and timeline help a team see both task-level details and the overall shape of a project.

For example, a small website launch might include writing page copy, designing the layout, building the site, reviewing it, and publishing it. A tracker can show that copywriting is assigned to Maya and due on April 10, while the Gantt view makes it easy to see that design starts before writing is fully complete. That overlap may be intentional, or it may reveal a dependency that needs discussion.

A Gantt bar shows a planned time span; it does not automatically prove that work is progressing or that a task is blocked. Keep useful tracker fields alongside the timeline, such as status, completion percentage, and a short note about the next action. This distinction prevents a colorful chart from giving a false impression of project health.

Plan the spreadsheet layout

Start with one row per task and one column per piece of information. A practical first worksheet can use this structure:

Task: a specific deliverable or action, rather than a broad label such as “marketing.”
Start date and finish date: the planned calendar dates for the task.
Duration: the number of calendar days from start through finish, if that measure is useful.
Owner: the person accountable for moving the task forward.
Status and progress: for example, Not started, In progress, Blocked, or Complete, plus a percentage if the team can estimate it consistently.
Dependency or notes: what must happen first, a risk, or the next action.

Put the timeline dates in row 1, beginning in column G, and put project tasks in rows 2 onward. In this example, column A is Task, B is Start, C is Finish, D is Duration, E is Owner, and F is Status. The date grid begins at G1. Keep dates as actual Excel dates, not text that merely looks like a date; actual dates can be sorted and compared reliably.

Use Excel’s table feature for the task list: select the task range and choose Insert > Table, then confirm whether the range has headers. Tables make filtering and adding rows more convenient. You can freeze the header and task-identifying columns using View > Freeze Panes, so names and dates remain visible while you scroll across a long timeline. If you want to convert the range to a table, keep the timeline grid outside the table so its formatting and date columns remain manageable.

Calculate dates and duration

Enter the task’s start and finish dates in B and C. With a start date of April 6, 2026, in B2 and a finish date of April 10, 2026, in C2, the calendar-day duration is five days because both the first and last dates count. With start dates in B2:B20 and finish dates in C2:C20, enter this in D2 and fill it down:

=C2-B2+1

For the example dates, the result is 5. This formula counts calendar days, including weekends. If your team plans only on weekdays, a workday duration is a different measure; Excel’s NETWORKDAYS function can count weekdays, but holidays must be supplied separately if they should be excluded. Do not mix calendar-day bars with a duration column that counts only working days without labeling the difference.

To create the timeline, type the first date in G1 and enter later dates across row 1. With the first timeline date in G1, enter this in H1 and copy it right:

=G1+1

If G1 contains April 6, 2026, H1 displays April 7, 2026, when formatted as a date. Format the timeline headings with a compact date format so the sheet does not become unnecessarily wide. A weekly timeline can be useful for longer projects, but its bars need rules that match the weekly date intervals; a daily grid is easier to set up and is clearer for short work.

Create the Gantt-style bars with conditional formatting

Select the timeline cells for the task rows, such as G2:AZ20, adjusting the last column and row to fit your plan. On Windows, choose Home > Conditional Formatting > New Rule, then select the option to use a formula to determine which cells to format. With start dates in column B, finish dates in column C, timeline dates in row 1, and the first task on row 2, use:

=AND(G$1>=$B2,G$1<=$C2)

Choose a fill color and apply the rule to the selected grid. The dollar signs matter: the row reference in G$1 keeps the date header on row 1 as the rule moves down, while $B2 and $C2 keep the start and finish columns fixed as it moves across. Excel shades a cell when its column date falls on or between the task’s start and finish dates. For a task running April 6–10, the five corresponding daily cells are shaded.

On Excel for Mac, conditional formatting is also available from the Home tab; the rule dialog may look different, but the same formula logic applies. Excel for the web supports conditional formatting too, although some editing options can vary by release. If a bar does not appear, check that the dates are numeric Excel dates, the rule’s applied range starts at the cell used in the formula, and the start date is not later than the finish date.

Use a consistent color for planned work, and consider a separate visual cue for completed or blocked tasks. Avoid giving every status a different bar color if the result becomes hard to read. A small legend and a clear status column often communicate more than a complicated palette. If you add additional conditional-formatting rules, review their order in Home > Conditional Formatting > Manage Rules; overlapping rules can produce unexpected fills.

Make the tracker useful for real project work

The quality of the schedule depends on the quality of the task list. Break large deliverables into work that can be estimated and reviewed. “Build checkout” might be too broad, while “connect payment provider,” “test a failed payment,” and “review checkout on mobile” are easier to assign and update. Do not split work into tiny steps merely to make the chart look detailed; each row should represent a meaningful piece of work.

Agree on how the team will update status. One team may use a short set of named states; another may prefer a percentage complete. Percentages can create an illusion of precision, especially for complex work, so define what 50% means or use milestone-based updates. Add a last-updated date or a project review rhythm so readers can judge whether the information is current.

Dependencies matter because a Gantt timeline can show overlap without explaining whether that overlap is possible. Add a predecessor or dependency column when one task cannot start until another finishes. For instance, user testing may depend on a working build, while copy review could happen in parallel with development. Excel will not automatically reschedule dependent tasks in this simple setup; the project owner needs to update dates when plans change.

Useful maintenance habits include:

Filter by owner or status during check-ins, rather than maintaining a separate list that can drift out of date.
Record the reason for a major date change in a note or change log.
Keep a clear distinction between planned dates and actual completion dates if you need to compare estimates with outcomes.
Review the timeline range when the project extends beyond its final visible date column.
Use data validation for repeated status values, if consistent spelling is important. In Excel, select the status cells and choose Data > Data Validation.

When Excel is a good fit—and when it is not

A spreadsheet is often a reasonable choice for a small project, a personal plan, or a team that needs a transparent schedule without introducing new software. It is easy to tailor columns, share a familiar file, and make a one-off view for a meeting. Excel is particularly useful when the tracker is primarily a reporting document and one person or a small group is responsible for maintaining it.

A spreadsheet becomes harder to manage when many people edit it at once, tasks change frequently, or the plan needs automatic dependency scheduling, notifications, workload balancing, audit history, or portfolio-level reporting. A dedicated project-management service may offer these capabilities, though specific features depend on the product and plan. A conventional stacked bar chart is another option if a presentation needs a chart object, but it generally requires more setup and careful handling of hidden start-date series and axis formatting.

Before choosing a tool, ask how the plan will be updated, who needs access, whether dates must recalculate automatically, and whether the project contains sensitive information. A visually polished spreadsheet is not a substitute for clear ownership or an agreed process. For a small project, the simplest tool that people keep current may be more useful than a sophisticated system that nobody updates.

Common problems and practical limits

The most common issue is that bars fail to line up with their dates. Usually the timeline headers or task dates are stored as text, the conditional-formatting formula points at the wrong first cell, or the rule was applied to a different range than expected. Check one task manually: compare its start and finish with the visible date headings, then confirm that the conditional-formatting rule uses the first cell of the selected range as its relative reference.

Another frequent source of confusion is the meaning of a finish date. In this simple calendar-day example, a task ending April 10 includes April 10 in its bar. Some schedules use finish dates as boundaries instead, so a task finishing at the start of April 10 may not occupy that whole day. State the convention in the worksheet notes, particularly when dates are used for handoffs or external commitments.

Large daily timelines can become unwieldy: a year of days requires many narrow columns. Zooming out may make dates unreadable, and printing can split the chart across many pages. Use a weekly or monthly view for a long-range summary, or keep a detailed daily schedule on a separate sheet. Check print settings through Page Layout and Print Preview before distributing a hard copy. The spreadsheet’s visual bars also do not provide a complete record of decisions unless changes and explanations are recorded somewhere.

Frequently Asked Questions

Is there a free project tracker spreadsheet with a Gantt chart in Excel?
Excel may show templates when you choose File > New and search for terms such as project tracker or Gantt. The available templates can vary by version and account. You can also build the basic tracker described above in a blank workbook; whether Excel itself is included depends on the Microsoft 365 plan or license you have.

Does Excel have a built-in Gantt chart?
Excel does not provide a dedicated Gantt chart type in the standard chart list. A common spreadsheet approach is a date grid with conditional formatting, while a stacked bar chart can be configured to resemble a Gantt chart. The grid is often simpler to maintain for a lightweight tracker.

Can a Gantt chart show weekends?
Yes. A daily timeline built from consecutive calendar dates includes weekends, and the conditional-formatting rule shades them when they fall within a task’s dates. To show weekdays only, create a weekday-only timeline and adjust the date headings accordingly; the displayed duration and schedule convention should still be clear.

How do I show task progress in the Gantt chart?
Keep a separate progress or status field so the planned schedule remains distinguishable from actual progress. A simple tracker can use status text or a percentage column without changing the date bars. Showing progress as a second fill inside each bar requires additional formatting logic and a team-wide definition of what the percentage means.

Can Excel automatically move tasks when a dependency changes?
Not with the basic conditional-formatting tracker. The bars reflect the dates entered in the task rows; they do not calculate a project network or automatically shift dependent tasks. Update affected dates manually, or use project-management software when automatic scheduling and dependency handling are requirements.

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.