Excel Gantt Chart Tutorial: Build a Project Timeline

To make a Gantt chart in Excel, list each task with a start date and finish date, place project dates across columns, and use conditional formatting to fill the cells that fall within each task’s dates. For a conventional chart object instead, insert a stacked bar chart using start dates and task durations, then hide the start-date series.

What an Excel Gantt chart shows

A Gantt chart maps project work against a calendar. Each row represents a task, and a horizontal bar shows when that task starts and finishes. The chart makes timing and overlap easier to see than a list of dates alone. It is useful for a launch plan, event schedule, home renovation, or other project with a defined sequence of activities.

Excel does not have a single built-in Gantt chart button. A common approach is to adapt a stacked bar chart, while another is to create a calendar grid and color cells with conditional formatting. The grid is straightforward to customize and can show task details directly beside the timeline. The stacked bar approach creates a chart object that can be resized or copied into a presentation. Neither method automatically manages project dependencies like dedicated scheduling software.

Prepare the task table

Start with one row per task and keep the data consistent. For this tutorial, use these columns in a blank worksheet: A for Task, B for Owner, C for Start, D for Finish, and E for Duration. Put the headings in row 1 and tasks in rows 2 through 6. Example tasks are Kickoff, Design, Draft, Review, and Launch. Enter real Excel dates in columns C and D, such as January 5, 2026, rather than date-like text that Excel may not recognize.

For this example, use these date ranges: Kickoff, January 5 to January 5; Design, January 6 to January 8; Draft, January 9 to January 14; Review, January 15 to January 16; and Launch, January 19 to January 19. The gaps and overlaps in a real plan should reflect the work, not just make the chart look tidy. A task’s finish date is usually inclusive in a simple calendar-grid chart: a task starting and finishing on the same day occupies one date cell.

With start dates in C2:C6 and finish dates in D2:D6, enter =D2-C2+1 in E2 and fill it down through E6. This returns calendar-day durations: the example rows return 1, 3, 6, 2, and 1 days. The plus one counts both the start and finish dates. If you instead want elapsed days between the dates, omit the plus one, but make sure that convention matches how you plan to display the bars.

Build a date-grid Gantt chart

In the grid method, the task table stays in columns A:E and the timeline begins in column G. Use row 1 for the timeline dates and rows 2 through 6 for task bars. Leave column F as a visual spacer if desired. Set the first date in G1 to the earliest task start date. With dates in C2:C6 and the first timeline date in G1, enter =MIN($C$2:$C$6) in G1. For the sample tasks, the result is January 5, 2026.

With G1 holding the first date, enter =G1+1 in H1, then drag the fill handle right to extend the calendar. For example, filling through AA1 creates a daily timeline through January 25, 2026. Format the date headings so they are readable: select G1:AA1, then use Home > Number Format to choose a date format, or open Format Cells with Ctrl+1 on Windows and choose a suitable date format. A concise format such as 5-Jan uses less space than a full date.

To color the task cells, select G2:AA6 and choose Home > Conditional Formatting > New Rule. Select Use a formula to determine which cells to format. With task start dates in column C, finish dates in column D, timeline dates in row 1, and the selected range beginning at G2, use =AND(G$1>=$C2,G$1<=$D2) as the rule formula. Choose a fill color and confirm the rule. Excel adjusts the relative references across the selected grid: each cell is filled when its column date is on or after that row’s start date and on or before its finish date.

The example fills one cell for Kickoff, three for Design, six for Draft, two for Review, and one for Launch. If the rule colors every cell, check that the start and finish entries are actual dates, that the rule applies to the intended range, and that the formula uses the correct row and column references. If dates are stored as text, convert them to dates before troubleshooting the rule.

Make the timeline easier to read

Use formatting to support the schedule rather than decorate it. Widen the task column, keep date columns narrow but legible, and use a consistent bar color. Add borders or subtle alternating row fills if they help readers follow a task across the sheet. Freeze the task labels while scrolling by selecting G2 and choosing View > Freeze Panes > Freeze Panes; this keeps the rows above and columns to the left visible. To keep only the heading row visible instead, choose View > Freeze Top Row.

Consider marking weekends or important dates so the calendar does not imply that every day is a working day. The basic rule above includes every calendar day between start and finish. That is appropriate for elapsed-time plans, but it may overstate work duration when tasks run only on weekdays. One simple option is to keep the calendar-day display and label the schedule clearly. Another is to build a weekday-only timeline, which requires generating dates that skip weekends and matching the task logic to that calendar. Avoid mixing weekday durations with a daily calendar without explaining the difference.

For a progress indicator, add a percent-complete column and make a separate visual convention for completed work. For example, you can use a second conditional-formatting rule with a different fill on completed dates, but the rule must account for progress and the order of rules. A simpler small-project option is to add a status column such as Not started, In progress, or Complete and use its text alongside the bars. Do not treat a colored bar as proof that a task is actually complete; update the status from project information.

Show milestones and dependencies

A milestone is a point in time rather than a span of work, such as approval, a delivery, or a launch. In a calendar grid, enter the same date as both the milestone start and finish. The inclusive date rule then fills one cell. Give milestones a distinct row label or color so readers do not mistake the marker for a one-day task.

Dependencies describe relationships such as one task starting only after another finishes. A basic Gantt grid does not enforce them. You can document a predecessor in an additional column, but changing a date will not automatically recalculate dependent dates unless you add formulas or use a project-planning tool. If dates are formula-driven, be explicit about the assumptions—for instance, whether the next task starts on the following calendar day or the next working day—and check that holidays and weekends are handled as intended.

Create a stacked bar chart instead

For a chart object, use the task names, start dates, and durations as the chart’s categories and series. In this example, those are columns A, C, and E. Select the task names, then hold Ctrl on Windows while selecting the start-date and duration data, including the headings. Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. If Excel does not assign the task names as category labels or the two data series as intended, use Chart Design > Select Data to correct the series and category ranges.

The first visible series represents the offset from the chart’s date-axis origin to each task’s start date. Hide its fill so only the duration bars show: select that series, open Format Data Series, and set Fill to No fill. The duration series then appears positioned at the corresponding start date. Format the horizontal axis as dates and adjust its bounds if the chart includes too much unused time. The task order may appear upside down; select the vertical category axis, open Format Axis, and use Categories in reverse order if that better matches the task table. Chart commands can vary slightly as Excel updates, but the chart type and series logic are the same.

This chart is useful when you need to move or resize the visualization independently of the data table. It can take more adjustment than the conditional-formatting grid, particularly when setting date-axis bounds and keeping labels readable. It also does not turn the workbook into a dependency-aware scheduler. If dates change, check that the chart series still reference the correct cells and that the displayed date range still covers the project.

Update, print, and share the schedule

When dates change, update the task table rather than painting cells manually. The conditional-formatting grid recalculates from the dates, and the duration values recalculate if their formulas remain intact. Extend the timeline if a task moves beyond its last date column. For the stacked chart, verify the source ranges and axis bounds after a schedule change. Keeping a single clean data table as the source of truth makes both versions easier to maintain.

For printing, set the print area to include the task columns and the relevant timeline, then use Page Layout > Orientation > Landscape if the schedule is wide. Choose a scaling option carefully: fitting every date column onto one page may make text too small. Printing a shorter time window or splitting the schedule across pages can be more readable. Before sharing, include a clear project title, the date range, and a note about whether bars count calendar days or working days. In Excel for Microsoft 365 on Mac, the same general table, conditional-formatting, and chart approaches are available, though ribbon placement and dialog appearance can differ. Excel for the web supports many common formatting and chart tasks, but some detailed chart-formatting controls may be more limited than in the desktop app.

Limits and alternatives

Excel is a practical choice for a small schedule that one person or a small group can maintain. It is flexible, familiar, and easy to adapt to a custom report. Its weaknesses become more noticeable as a plan grows: manually maintained dependencies can go stale, multiple people may edit conflicting dates, and a large timeline can become difficult to read. A spreadsheet also cannot reliably tell whether a project is feasible just because all its bars fit on the page.

For a simple plan, the date-grid method is often the fastest starting point. Choose the stacked bar chart when a movable chart object matters more than a cell-based display. Consider dedicated project-management software when you need automatic dependency scheduling, resource allocation, shared updates, notifications, or workload views. You do not need to abandon Excel just because a project is important, but be realistic about who maintains the dates and how schedule changes are verified.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel does not provide a dedicated Gantt chart command, but Microsoft 365 may offer project templates through its template gallery. Template availability can vary. The conditional-formatting grid and stacked-bar method described above can also be built in a blank workbook.

Can I make a Gantt chart without formulas?
Yes. You can insert a stacked bar chart and enter start dates and durations as values, although calculated durations can make updates less error-prone. The calendar-grid method relies on a conditional-formatting formula to color the correct cells automatically.

Why does my Gantt bar start on the wrong day?
Check that the timeline headings and task dates are real Excel dates, not text, and confirm that the conditional-formatting rule begins with the same top-left cell as its applied range. Also check that the start and finish columns in the rule match your table.

How do I show weekends in an Excel Gantt chart?
The basic daily grid includes weekends because it advances one calendar day at a time. You can shade weekend columns with separate formatting or create a weekday-only timeline, but make sure your duration and bar logic use the same calendar convention.

Can Excel automatically move dependent tasks?
Not with a basic Gantt chart. The chart displays dates; it does not understand task relationships by itself. You can build formulas for a defined dependency model, but for complex dependencies, shared scheduling, or resource planning, dedicated project software is usually more suitable.

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.