Excel Gantt Chart Setup: Build a Project Timeline

To set up a Gantt chart in Excel, list each task with a start date and finish date, create a row of timeline dates, and use conditional formatting to shade the cells that fall within each task’s dates. This date-grid method is quick to update and needs no add-in; a stacked bar chart is another option when you want a conventional chart graphic.

What a Gantt chart shows

A Gantt chart places tasks down the left side and time across the top. A horizontal bar shows when each task is scheduled and how long it lasts. That makes it easier to see overlaps, gaps, deadlines, and the overall shape of a project than a plain list of dates.

Excel does not have a dedicated Gantt chart button. Instead, you can create one from ordinary worksheet cells using conditional formatting, or build one from a stacked bar chart. Neither method automatically understands project dependencies: if one task moves, Excel will not necessarily reschedule the tasks that depend on it. You need to model those relationships yourself or use project-planning software with scheduling features.

A Gantt chart is a visual schedule, not proof that the schedule is achievable. It does not show resource availability, uncertainty, or workload unless you add those details. For a small project, a task list and timeline may be enough. For a large project, use the chart as one view of a more carefully managed plan.

Prepare the task data

Start with one row per task and clear column headings. A practical layout for a small project is:

A: Task name
B: Start date
C: Finish date
D: Duration in calendar days
E: Percent complete, if you want to show progress

For example, a project might include “Draft outline,” “Review draft,” and “Publish.” Enter real Excel dates in the start and finish columns, rather than text that only looks like a date. If the finish date includes the final working day of a task, decide whether the chart should treat both the start and finish dates as included; the examples below use inclusive calendar dates.

With start dates in B2:B10 and finish dates in C2:C10, enter this in D2 and fill it down to calculate inclusive calendar-day duration:

=C2-B2+1

If a task starts January 6 and finishes January 10, the result is 5 days. The plus one matters because subtracting the dates alone gives the number of date boundaries between them, not the count of dates when both endpoints are included. If your team defines finish dates differently, use that convention consistently. Keep task names and dates together when sorting; sorting only one column can mismatch tasks with their schedules.

Build a date-grid Gantt chart

Leave a column or two between the task details and the timeline if that makes the sheet easier to read. In the first timeline heading cell, such as F1, calculate the earliest task start date. With task starts in B2:B10, enter:

=MIN($B$2:$B$10)

The result is the earliest date in the project. Format F1 as a date using Home > Number Format, or choose a date format in the Format Cells dialog. In G1, enter the next-day formula below, then fill it to the right for as many days as you need:

=F1+1

For instance, if F1 is January 6, G1 returns January 7. Continue across the sheet until the last date covers the latest task finish. You can show shorter headings by formatting the dates as day numbers or abbreviated dates, but retain actual date values: conditional formatting relies on date values, not labels typed as text.

Next, select the timeline cells that correspond to your task rows, such as F2:AZ10. Choose Home > Conditional Formatting > New Rule, then choose Use a formula to determine which cells to format. With dates in row 1, starts in column B, and finishes in column C, use this formula:

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

Choose a fill color and confirm the rule. Excel evaluates the formula for each cell in the selected range. The column reference for the timeline date moves across the grid, while the task’s start and finish columns stay fixed and its row changes. A cell is shaded when its date is on or after the task start and on or before its finish. That creates one bar for each task.

The exact right edge depends on how wide your timeline is. If the project spans more days than the visible columns, extend the date sequence and the conditional-formatting range. If the timeline is too wide to scan, consider showing weeks or months rather than every day, or use a chart with a date axis.

Format the timeline for readability

Formatting helps readers understand the schedule without changing the underlying dates. Use a consistent bar color, bold the task-name column, and give the date headings a contrasting fill. You can freeze the headings and task names with View > Freeze Panes so they remain visible while you scroll. On Windows, select the cell below and to the right of the rows and columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes.

Adjust column widths so task names are legible and timeline cells are narrow enough to show a useful span. Add borders sparingly; heavy borders around every daily cell can make a long schedule difficult to read. A vertical line for the current date can help with status reviews, but it is usually clearer to update that marker deliberately than to imply that the schedule changes itself.

For a project that lasts months, daily columns can make the worksheet unwieldy. A weekly view is possible, but decide what each date heading represents and keep the bar rule consistent with that choice. For example, a weekly cell could represent the week’s first day; tasks that start or finish during the week then require a rule that tests whether their date ranges overlap the whole week, not just that first day.

Show progress and milestones

To track completion, enter a percentage in column E for each task and format those cells as percentages. You can add a second conditional-formatting rule to show the completed portion of each scheduled bar. With start dates in B2:B10, finish dates in C2:C10, completion percentages in E2:E10, and timeline dates in row 1, apply this rule to F2:AZ10:

=AND(F$1>=$B2,F$1<=$B2+ROUND(($C2-$B2+1)*$E2,0)-1)

This rule shades the first portion of the scheduled dates according to the percentage complete. For a January 6–10 task at 60 percent, the duration is five days and the rounded completed portion is three days, so the rule shades January 6 through January 8. Treat this as a visual estimate of progress, not a measurement of effort: the formula assumes progress fills from the task’s start date onward.

Keep the completed segment visually distinct from the remaining scheduled segment. In Conditional Formatting > Manage Rules, order the completion rule above the full-bar rule and use Stop If True for the completion rule if needed to prevent the full-bar format from covering it. Check the result after changing percentages, especially at 0 percent and 100 percent.

A milestone is usually a date rather than a duration. You can enter the same date as both its start and finish, which produces a one-cell marker in the date grid. Give milestone rows a distinct task label or color so they do not look like ordinary multi-day tasks. If the milestone falls outside the displayed date range, it will not appear, so make sure the timeline includes its date.

Dependencies, workdays, and schedule changes

A basic Gantt chart displays dates; it does not calculate dependencies. If “Review draft” must follow “Draft outline,” the chart will not move the review date when the outline slips unless you add formulas or update the dates. For a simple plan, add a predecessor column naming the task that must finish first, then review dependent dates whenever a predecessor changes. Avoid implying that a list of dates is automatically linked when it is not.

Calendar-day duration also includes weekends and holidays. That may be right for a delivery window, but it can overstate working time for a task performed only on business days. Excel’s NETWORKDAYS function can count weekdays between dates, and it can exclude a supplied holiday range. The visual grid still displays calendar dates unless you deliberately omit or visually distinguish nonworking days. Decide whether the chart represents elapsed time or working time before interpreting the bar lengths.

When dates change, the conditional-formatting bars update because they are based on the cells’ current values. The sequence of timeline dates does not automatically expand to cover a new project finish date, however. Extend the date headings and rule range when a schedule grows beyond the area already prepared. If you use formulas for dates, keep the formulas intact when copying or editing the schedule.

Common setup problems and fixes

No bars appear: Check that start and finish entries are real dates, that the rule covers the intended timeline cells, and that its references match the worksheet layout. A date stored as text will not compare like a date value.
Every row shows the same bar: Check the row reference in the rule. In the example, F$1 fixes the heading row while $B2 and $C2 lock the date columns but allow the task row to change.
Bars start one day late or end one day early: Confirm whether your finish date is inclusive. The example shades both the start and finish dates; another convention needs a corresponding change to the rule.
Dates appear as numbers: Excel stores dates as serial values. Apply a date number format to the heading cells rather than replacing the values with typed labels.
New tasks are missing: Extend both the conditional-formatting range and any formulas or date-range references that stop at the old final row.
Bars are hard to compare: Check whether the sheet is mixing calendar days and workdays, and make sure all tasks follow the same date convention.

To inspect the rules, choose Home > Conditional Formatting > Manage Rules. Set the display to the current worksheet if needed, select the rule, and check both its formula and the Applies to range. This is often faster than rebuilding a chart when a copied worksheet or inserted row has changed the selected range.

When a stacked bar chart is a better fit

The date-grid method is usually simpler to maintain and gives you a calendar-like view. A stacked bar chart can be a better choice when you need a chart object that can be resized, copied into a report, or presented with a conventional horizontal axis. It uses two series: a hidden offset from the project’s start date and a visible duration. The offset positions each task’s bar at the appropriate point along the date axis.

For this approach, arrange task names, start dates, and durations in adjacent columns, then insert a stacked bar chart using Insert > Insert Bar Chart > Stacked Bar. In the chart’s data settings, use task names as categories and the start-date offset and duration as the two series. Format the offset series with no fill so only the duration bars show, then format the horizontal axis as dates and reverse the category order if necessary to put the first task at the top. Exact axis formatting can take more adjustment than the date-grid approach.

Choose the grid when you want visible dates in cells, easy conditional formatting, and straightforward editing. Choose the chart when a clean graphic matters more than cell-level detail. Both approaches need accurate source dates, and neither automatically provides full project scheduling, resource leveling, or dependency management. For complex plans, dedicated project-management software may be more appropriate than a heavily customized workbook.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel does not provide a dedicated Gantt chart command on the ribbon, but Microsoft and other template providers may offer workbooks that use formulas, conditional formatting, or charts to create one. A template still needs its dates and rules checked against your project’s conventions.

Can I make an Excel Gantt chart without a formula?
You can shade timeline cells manually, but those bars will not reliably move when dates change. A conditional-formatting formula makes the bar respond to the task’s start and finish dates, which is why the date-grid setup is more maintainable.

How do I show weekends in an Excel Gantt chart?
The daily grid naturally includes weekends if its date headings include every calendar day. To make weekends easier to distinguish, format their columns differently or use a separate conditional-formatting rule. If your project uses working days only, make that clear rather than treating calendar-day bars as work estimates.

Can Excel automatically move dependent tasks?
Not with the basic chart setup. The date-grid rule only displays the dates it is given. You can build formulas to calculate dates from predecessors, but more complicated dependency types, resource constraints, and schedule changes can become difficult to manage in a spreadsheet.

Why does my Gantt chart show numbers instead of dates?
Excel stores dates as serial numbers, and the cell may be using a General or Number format. Select the date headings and apply a date format through Home > Number Format. The values can remain numeric internally while displaying as calendar dates.

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.