A project timeline Excel template with a Gantt chart can be built from a task list, start and finish dates, and a date-based grid: use conditional formatting to shade each task’s cells between its dates. In Microsoft Excel for Microsoft 365 on Windows, this creates an editable schedule without needing a separate chart object or specialized project software.
What an Excel Gantt timeline shows
A Gantt chart puts tasks in rows and time periods in columns. A colored bar marks when each task is planned to happen, so a reader can see the schedule’s sequence, duration, overlap, and empty periods at a glance. The underlying task list provides the details that a bar alone cannot communicate.
A practical starter template can use these columns:
- Task: A short, specific activity, such as “Approve wireframes.”
- Owner: The person or team responsible.
- Start: The planned first date for the task.
- Finish: The planned final date.
- Duration: The number of calendar days between the dates, including both endpoints.
- Status: A concise label such as Not started, In progress, or Complete.
Place a sequence of dates across the columns to the right of those fields. For instance, if the task information occupies columns A:F, the timeline can begin in column G. Each shaded cell then represents a day in that column’s heading. The chart is not a substitute for the source data: changing a task’s start or finish date should change its bar.
Set up the task list and timeline
Start with one row per task and consistent date values in the Start and Finish columns. In the example below, tasks are in rows 2 through 20, Start dates are in C, Finish dates are in D, and the timeline headers begin in G1. Replace the sample row limit with a range that suits the project. Enter dates as real Excel dates, not text that merely looks like a date.
With task start dates in C2:C20 and the first timeline heading in G1, enter =MIN($C$2:$C$20) in G1. This displays the earliest task start date; for example, if the earliest start is January 6, 2026, G1 displays January 6, 2026. With G1 holding that first date, enter =G1+1 in H1 and fill it right to create consecutive daily headings. The next heading is January 7, 2026. Format the headings as readable dates, such as “Jan 6,” while retaining the underlying date values.
If you prefer to show only the project’s active period, add a little space before and after the first and last tasks rather than starting the timeline at an unrelated date. A timeline that is too broad makes the task bars narrow and the worksheet harder to read. For a long project, a weekly or monthly view may be more useful than hundreds of daily columns, but a weekly view needs a rule that shades a week when it overlaps a task; it is not simply the same daily rule applied to wider labels.
Calculate task duration carefully
With a task’s inclusive Start and Finish dates in C2 and D2, enter =D2-C2+1 in E2 and copy it down. If the task starts January 6 and finishes January 8, the result is 3 calendar days. The added 1 counts both the start and finish dates. Without it, subtraction returns the elapsed difference of 2 days, which may not match how a schedule displays a task bar.
This calculation counts calendar days, including weekends and holidays. That is often appropriate for a visual timeline, where a task can span a weekend even if no work is performed on Saturday or Sunday. If the project tracks working days instead, define that convention explicitly and use a working-day calculation consistently; do not compare a calendar-day duration with a bar that is intended to represent only workdays. A milestone can be represented as a task with the same start and finish date, resulting in a one-day bar, or given a distinct symbol or format.
Make the Gantt bars with conditional formatting
Select the cells where the bars should appear, for example G2:AZ20, adjusting the final column to cover the project. On Windows, choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With the first task’s start and finish in C2 and D2 and the date heading for the first selected timeline column in G1, use =AND(G$1>=$C2,G$1<=$D2) as the rule formula. Choose a fill color and confirm the rule.
The rule is true when a column’s date is on or after the task’s start and on or before its finish. The dollar signs keep the date-heading row fixed while allowing the column to move, and keep the start and finish columns fixed while allowing the task row to move. For a task dated January 6 through January 8, the cells under those three dates are shaded; the January 5 and January 9 cells are not. If your selected range begins somewhere other than G2, adjust the references in the formula so they match its top-left cell.
Keep the fill color distinct from the worksheet’s ordinary cell formatting. Freeze or otherwise keep the task-name columns visible while scrolling across a long timeline, and consider using borders or alternating row shading to help readers track a bar back to its task. You can make the header row bold and use a different style for weekends, but avoid competing colors that make the schedule’s meaning ambiguous. The chart should remain understandable when printed or viewed without color, so retain clear task names and dates.
Show dependencies, milestones, and progress
A basic Excel Gantt grid shows timing, not necessarily task logic. If “Build landing page” cannot begin until “Approve wireframes” is complete, record that dependency in a separate Predecessor or Notes column. A bar chart alone does not enforce the relationship: moving the approval task will not automatically move the build task unless you add more scheduling logic. For a small plan, a predecessor ID and a review of dependent dates may be enough; for a schedule with many linked tasks, frequent changes, or resource constraints, a purpose-built project tool may be safer.
Milestones are important events rather than work spanning several days, such as a launch approval or delivery. Give them a separate label or formatting convention so readers do not mistake a one-day bar for an ordinary task. Similarly, a Status field does not automatically show how much of each bar is complete. If progress matters, add a numeric percent-complete column and a separate visual convention, or show completion text alongside the planned bar. Be clear about whether the bar represents the original plan or the latest forecast; overwriting the original dates can hide schedule changes.
Choose a template or make a custom one
An existing workbook template can save setup time, while a custom sheet gives you control over fields, date scale, and formatting. Excel’s available templates and their contents can vary by installation and account, so inspect any downloaded or built-in file before relying on it. Check what its bars mean, whether formulas cover all task rows, and whether dates are editable inputs or calculated outputs. A polished design is not proof that the schedule logic matches your project.
Before choosing, consider these factors:
- Project size: A short project with a modest task list usually fits a simple worksheet. Many teams, dependencies, or changing assignments can make maintenance difficult.
- Time scale: Daily columns suit short plans; weekly or monthly headings save space on longer ones.
- Audience: A team may need owners and status, while an executive summary may need only phases and milestones.
- Update process: Decide who can change dates, how often the schedule is reviewed, and how a revised plan is distinguished from the baseline.
- Sharing needs: Confirm that collaborators can open and edit the workbook in their version of Excel, and that formatting and formulas remain useful when it is shared.
For a reusable custom template, keep input cells visually distinct from formula cells, include a small legend, and add instructions for entering dates and status. Protecting formula cells can reduce accidental edits, but protection is not a substitute for keeping a backup or controlling who has access to the file.
Common problems and how to prevent them
Several ordinary spreadsheet issues can make a Gantt chart appear broken. Text dates may not compare correctly with real Excel dates, so check that both task dates and timeline headings behave as dates when formatted. A missing finish date can also create misleading results; require both dates before considering a task scheduled. If a bar is shifted by one day, review whether the finish date is inclusive and whether the formula’s references match the selected range.
- Bars do not appear: Check that the conditional-formatting rule applies to the full grid, that start and finish cells are populated, and that the formula references the first cell in the selected area.
- Every row looks the same: Check the row references in the rule. The task row should change as the rule is applied down the grid.
- New tasks have no bars: The conditional-formatting range may stop at the original last row. Extend the range when adding tasks, or build the sheet so its planned capacity includes extra rows.
- The timeline is too wide: Use a larger time interval, such as weeks, or split the plan into phases. Hiding columns can also make dates harder to interpret if the hidden period is not obvious.
- Dates change unexpectedly: Check whether a cell contains a typed date, a formula, or a copied value. Keep a saved baseline if preserving the originally approved schedule matters.
Also avoid treating a Gantt chart as a guarantee that a project is feasible. A spreadsheet can display overlapping assignments without warning that one person has been scheduled for simultaneous work. It does not automatically account for effort, availability, risk, or approval delays unless you build and maintain additional information and rules.
Excel versus other planning options
Excel is useful when a project needs a familiar, flexible schedule that people can edit and review as a workbook. It is especially practical for a small plan, a one-time timeline, or a report that needs custom columns. Its flexibility comes with responsibility: users must maintain dates, formatting ranges, and any dependency logic themselves.
A dedicated project-management application may be a better fit when the team needs automatic dependency scheduling, workload views, shared updates, notifications, or portfolio reporting. Those capabilities vary by product and plan, so compare the actual features, collaboration requirements, and cost before moving a schedule. Google Sheets can be a reasonable alternative when browser-based shared editing is central, though a workbook’s Excel-specific formulas or formatting may not transfer identically. For any tool, establish one authoritative schedule to avoid conflicting copies.
Frequently Asked Questions
Does Excel have a Gantt chart template?
Excel template availability varies, and some templates use different layouts or calculations. You can also make a straightforward Gantt grid from task dates and conditional formatting, then check that the rules and date scale fit your project.
Can I make a Gantt chart in Excel without a formula?
You can color cells manually, but the bars will not reliably follow date changes. A conditional-formatting rule tied to each row’s start and finish dates is a more maintainable way to make the display respond to updated dates.
Should Gantt chart duration include weekends?
That depends on what the schedule represents. The example duration counts calendar days inclusively. If you plan workdays only, state that convention and make sure the timeline and duration calculation reflect it.
Why does my Excel Gantt chart show no bars?
Check for real date values in the task and header cells, verify that the rule’s “Applies to” range covers the grid, and confirm that the references point to the first selected task row and timeline column.
Can Excel automatically move dependent tasks?
A basic conditional-formatting Gantt chart only displays dates; it does not reschedule dependent tasks automatically. You can build additional formulas or scheduling logic, but complex dependencies are often easier to manage in dedicated project software.
Related
- Password Protect an Excel Document to Open
- Password Protect an Excel File Before Opening It Safely
- Password Protect Excel Before Opening: How It Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Trendline Not Showing? Causes and Fixes in ChartsIf the Trendline option is missing in Excel, select a data series inside the chart, not the chart…
- Pareto Chart in Excel: Use Word Labels and CountsYes—an Excel Pareto chart can use words such as “Late delivery” or “Damaged item” as category labels, with…
- Extend a Trendline to the Y-Axis in ExcelTo extend a trendline to the y-axis in Excel, select the trendline, open Format Trendline, and increase Forecast…
- MS Excel Pivot Tables: How They Work and How to Use ThemA PivotTable in Microsoft Excel summarizes and explores data without changing the original records: select a clean data…
- How to Make a Line Graph in Excel With Data in a Few StepsTo make a line graph in Excel, arrange your data in columns with time periods or other categories…
- Google Sheets Chart Templates: How to Find and Use ThemGoogle Sheets does not have a dedicated gallery of reusable chart-style templates, but you can start with a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.