To make a Gantt chart template in Excel, list each task with a start date and finish date, put project dates across a row, then use conditional formatting to shade the cells where each task is active. In Microsoft Excel for Microsoft 365 on Windows, this creates a flexible project plan without a dedicated Gantt chart feature or a separate add-in.
What an Excel Gantt chart template includes
A Gantt chart is a schedule shown as horizontal bars against a calendar. Each row represents a task; its bar starts on the task’s start date and ends on its finish date. A useful Excel template combines that timeline with the information people need to coordinate work, such as task owner, duration, status, and dependencies.
A simple worksheet might use these columns: A for task, B for owner, C for start date, D for finish date, E for duration, and F for predecessor. Put the timeline dates in row 4, starting in G4, and list tasks from row 5 down. For example, a project might include “Approve requirements,” “Create draft,” and “Review draft.” The first task’s finish date can help determine when the next task begins.
The timeline can show calendar days, weeks, or months. Daily columns are useful for short projects; weekly or monthly columns are easier to read over longer periods. The template does not decide whether a date is realistic or whether a task is complete. Those details depend on the estimates and updates entered by the project team.
Build the task table and timeline
Start with a blank workbook or an existing project-planning template. Give the worksheet a clear project name, freeze the task labels if the schedule will be wide, and use actual Excel date values in the start, finish, and timeline cells. Dates stored as text can look correct but fail in date calculations or conditional formatting.
- Enter a short, specific task name in column A, an owner in B, and start and finish dates in C and D. Use one row per task or milestone.
- In E5, calculate the inclusive calendar-day duration with
=D5-C5+1. With a start date of January 5, 2026, and a finish date of January 9, 2026, the result is 5 days. Copy the formula down for the other task rows. - Enter the project’s first date in G4. Enter
=G4+1in H4 and fill it right to create consecutive daily dates. Format the date row as a readable short date, such as d-mmm. - Adjust the timeline’s end date to cover the planned work. For a schedule longer than a few weeks, consider using weekly columns or a separate overview sheet rather than squeezing hundreds of daily columns into one view.
The duration formula counts both the start and finish dates, which is appropriate for a calendar-day bar that includes those dates. If the schedule should count working days instead, use =NETWORKDAYS(C5,D5) in E5. With the same Monday-to-Friday example dates, it returns 5 working days. NETWORKDAYS excludes Saturdays and Sundays by default; a holiday range can be supplied as its optional third argument when the worksheet includes one.
Show task bars with conditional formatting
Conditional formatting colors timeline cells when their dates fall within a task’s start and finish dates. This approach is convenient because changing a task date updates the bar automatically. It also keeps the task labels and date grid in one worksheet.
- Select the timeline area for the task rows, for example G5:AJ24. The example assumes row 4 contains dates and rows 5 through 24 contain tasks.
- On the Windows ribbon, choose Home > Conditional Formatting > New Rule, then select Use a formula to determine which cells to format.
- Enter
=AND(G$4>=$C5,G$4<=$D5)as the rule formula. Choose a fill color in the formatting dialog and confirm the rule. - Check that the rule applies to G5:AJ24. The relative column reference G changes across the timeline, while the row reference 4 stays on the date header. The task-row reference changes as the rule is applied down the grid.
In the example, if row 5 starts January 5 and finishes January 9, the cells whose header dates fall from January 5 through January 9 are shaded. If a bar does not appear, check that the dates are real date values, that the rule’s Applies to range includes the grid, and that the formula references match the actual header and task rows. Mac Excel offers conditional formatting through its Home ribbon as well, though dialog layout can differ. For a complex rule, use the desktop app if the controls in Excel for the web do not match the instructions.
Represent dependencies, milestones, and progress
A predecessor column records which earlier task must happen before another can begin. For example, “Create draft” may depend on “Approve requirements.” Excel’s basic conditional-formatting Gantt does not automatically reschedule dependent tasks when a date changes. The predecessor entry is a planning note unless you add and maintain formulas or use project-management software with dependency scheduling.
Milestones are events with little or no duration, such as approval or launch. A calendar-day duration formula returns one when the start and finish dates are identical. To distinguish a milestone visually, add a separate conditional-formatting rule or use a symbol in the task name; avoid implying that a one-day bar represents a multi-day task.
Progress can be tracked in an additional column, such as G for percent complete, if the timeline begins farther to the right. Keep progress distinct from planned dates. A shaded plan bar means work is scheduled, not necessarily finished. Teams can use a second color or a separate actual-start and actual-finish field, but should document what each color means so readers do not confuse the baseline schedule with current status.
Make the plan readable and maintainable
A Gantt sheet can become hard to interpret when every task, date, and status has a different color. Use one main bar color, reserve a contrasting color for milestones or critical deadlines, and provide a small legend. Choose task names that describe an outcome, such as “Publish approved webpage,” rather than vague labels such as “Website.” Group related tasks with headings or indentation, while keeping the underlying date rows consistent.
- Freeze the task labels so they remain visible while scrolling through a long timeline. In Windows Excel, select the cell just below and to the right of the area to keep visible, then choose View > Freeze Panes > Freeze Panes.
- Use consistent date formats and verify that the displayed timeline covers the full project. A hidden or omitted end date can make the final tasks appear to have no bar.
- Set print orientation and scaling deliberately. A wide daily schedule may be more useful as a workbook than as a single printed page; forcing it onto one page can make the text too small to read.
- Protect the meaning of formulas by distinguishing input cells from calculated cells, for example with subtle fill colors and a short note. If multiple people edit the file, agree on who updates dates and status.
After adding tasks or extending the timeline, inspect the conditional-formatting rule and its Applies to range. Excel may not include new rows or columns if they are added outside the formatted range. Tables can help manage task lists, but the timeline grid still needs its own range and rule coverage.
Choose a template that fits the project
A blank worksheet gives the most control, while a downloaded template may save setup time. Microsoft’s template availability and designs can change, so inspect any template before relying on it. Check whether it uses formulas, named ranges, macros, or external links; remove features the team does not understand or need. An .xlsx workbook cannot store VBA macros, while a macro-enabled workbook uses the .xlsm format. Do not enable macros from an untrusted source.
Match the time scale to the planning question. A daily view can help coordinate a two-week launch; a monthly view is often clearer for a year-long program. Add only fields that support decisions. A very detailed plan can consume time to maintain and create an impression of certainty that estimates do not justify. For uncertain work, show a range or review dates regularly rather than treating every forecast as fixed.
Also consider the audience. A project lead may need owners, dependencies, and status, while an executive summary may need only major phases and milestone dates. You can keep the detailed plan on one sheet and create a simplified summary on another. If the workbook will be shared, confirm that everyone has access to the file and knows whether edits should be made in desktop Excel or Excel for the web.
Excel Gantt charts compared with other tools
Excel is useful for a lightweight schedule, a one-off plan, or a team that already works in spreadsheets. The conditional-formatting method is transparent: dates and rules can be inspected directly. Excel also supports a different visual approach using a stacked bar chart, with a hidden start-date series and a visible duration series. That can produce a chart suitable for presentation, but it takes more chart formatting and may be less convenient for frequent task-level edits.
Excel does not provide a standard, one-click Gantt chart type in the usual chart list. A template built with conditional formatting or a stacked bar chart is a constructed worksheet, not a special project-scheduling engine. Dedicated project-management tools may offer linked dependencies, automatic rescheduling, resource assignments, notifications, and collaboration controls. Whether those features justify a separate tool depends on project complexity, team workflow, and the organization’s available software; pricing and included features vary by product and plan.
Common problems and practical limits
The most common errors are incorrect date values, inconsistent task rows, and conditional-formatting references that point to the wrong cells. A finish date earlier than its start date can produce a negative duration and no visible bar. Add a simple review step to catch reversed dates, blank owners, missing finish dates, and tasks that extend beyond the timeline. You can also apply data validation to date-entry cells, but validation cannot guarantee that an estimate is sensible.
Another misconception is that a Gantt bar proves work is on schedule. It only shows what the worksheet’s dates and rules describe. It does not verify that resources are available, calculate every downstream impact, or detect delays unless someone updates the plan and interprets the change. For a small project, a regular review may be enough. For interdependent work across many teams, manually maintaining an Excel schedule can become unreliable, and a tool that models dependencies may be a better fit.
Frequently Asked Questions
Does Excel have a built-in Gantt chart template?
Excel can open project-planning templates, but it does not have a standard dedicated Gantt chart type in its regular chart list. A common worksheet template uses dates and conditional formatting; a stacked bar chart is another Excel-based option.
How do I make a Gantt chart in Excel without a template?
Create task, start-date, and finish-date columns, place dates across a header row, select the task timeline grid, and add a conditional-formatting formula that shades dates between each row’s start and finish. The formula and cell references must match your worksheet layout.
Can Excel automatically move dependent tasks?
Not with the basic template described here. A predecessor column can document task relationships, but it does not automatically shift later dates. That behavior requires additional scheduling formulas or software designed to manage dependencies.
Should the duration include weekends?
Use calendar-day counting when weekends are part of the planned elapsed time. If duration means working days, NETWORKDAYS excludes weekends and can also exclude listed holidays. State which interpretation the plan uses so readers understand the numbers.
Can I use the same Gantt workbook on Mac or online?
Excel for Mac supports dates, formulas, and conditional formatting, though ribbon and dialog layouts may differ from Windows. Excel for the web can open Excel workbooks, but available editing controls can vary. Check the rule and displayed schedule after moving a workbook between apps.
Related
- Excel Named Ranges: How to Create and Use Them
- Excel Uppercase to Lowercase Shortcut: What Actually Works
- Excel Unmerge Cells Shortcut: Keys, Steps, and Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Line Chart: How to Add a Vertical Reference LineTo add a vertical line to an Excel line chart, use Insert > Shapes > Line for a…
- Can You Build an Org Chart in Excel? Steps & OptionsYes, you can build an organizational chart in Excel using SmartArt or by arranging shapes and connector lines.…
- Stacked Waterfall Chart in Excel: How It WorksExcel does not offer a built-in stacked waterfall chart: its native Waterfall chart plots one series, not a…
- Excel Pivot Chart Example: Build a Sales DashboardAn Excel PivotChart example is a chart that summarizes sales by month and region, then lets you rearrange…
- Excel Pie Chart Legend on Slices: How to Add LabelsYes. In Excel for Microsoft 365 on Windows, select the pie chart, then choose Chart Design > Add…
- Sample Org Chart in Excel: Build a Clear HierarchyYes. In Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.