How to Make a Gantt Chart in Excel for Office 365 [2026]

Project plans can become confusing when tasks, dates, and dependencies sit in separate places. You may know what needs to happen, yet still struggle to see whether the schedule fits together.

That confusion becomes worse when a deadline moves. A simple list rarely shows which tasks overlap, where a delay begins, or how much time remains. Building a Gantt chart can feel complicated if you have never worked with Excel charts.

But here's the good news: you can create a clear Gantt chart in Excel for Office 365 by combining a task list with a stacked bar chart. I’ll show you the complete process, explain how to format it, and share practical ways to keep the timeline accurate.

How to Make a Gantt Chart in Excel for Office 365

A Gantt chart in Excel uses a stacked bar chart. The first series represents the number of days before a task begins, while the second series shows the task duration.

Here is the quickest approach:

1. Create columns for task names, start dates, end dates, and duration.
2. Calculate each task’s duration by subtracting its start date from its end date.
3. Insert a stacked bar chart using the start date and duration columns.
4. Hide the start-date series so only the task bars remain visible.
5. Reverse the task order and adjust the horizontal date axis.
6. Format colors, labels, gridlines, and titles for easier reading.

Step 1: Build the task schedule

Open Excel for Office 365 and create a simple schedule. Use one row for each task and give every column a clear heading.

Keep task names short enough to display beside the chart. If a task needs more explanation, add a separate notes column rather than making the chart label too long.

Step 2: Calculate task duration

In the first duration cell, subtract the start date from the end date and add one day:

=C2-B2+1

The +1 counts both the starting day and ending day. Without it, a task beginning and ending on January 6 would show zero days.

Copy the formula down the column. If your schedule uses working days instead of calendar days, use:

=NETWORKDAYS(B2,C2)

This excludes Saturdays and Sundays. You can also add a holiday range when your team needs more precise working-day calculations.

Step 3: Insert a stacked bar chart

Select the task names, start dates, and duration values. You can select separate ranges by holding the Control key while choosing each range.

Then follow these menu commands:

1. Open the Insert tab.
2. Choose Insert Column or Bar Chart.
3. Select 2-D Bar.
4. Choose Stacked Bar.

Excel will display two colored segments for every task. The first segment represents the waiting period before the task starts. The second represents the active task period.

Step 4: Hide the start-date series

Click the first series in the chart. This is usually the segment closest to the vertical axis.

Open the formatting panel and choose:

1. Fill & Line.
2. Fill.
3. No Fill.
4. Border.
5. No Line.

The invisible segment still controls each bar’s position. Hiding it creates the familiar Gantt effect, where every visible bar begins on its actual start date.

Step 5: Reverse the task order

Excel often places the first task at the bottom of a bar chart. That feels backward because project plans usually begin at the top.

To correct the order:

1. Right-click the vertical task axis.
2. Choose Format Axis.
3. Open Axis Options.
4. Select Categories in reverse order.

Excel may move the horizontal date axis to the top. If that happens, adjust the axis settings until the chart reads naturally from the first task at the top to the final task at the bottom.

Step 6: Set the date axis

Right-click the horizontal axis and select Format Axis. Adjust the minimum and maximum bounds so the chart begins near the first task and ends near the final deadline.

For example, if the project runs from January 6 to February 13, avoid showing several unused months around it. A narrow date range makes the schedule easier to inspect.

You can also change the major unit. A seven-day unit creates weekly spacing, while a one-day unit provides greater detail for short projects.

Step 7: Format the chart for daily use

Give the chart a useful title, such as Website Launch Schedule. Use one strong color for active task bars and a neutral background for the chart area.

Remove the legend if the hidden start-date series makes it confusing. You can also reduce chart clutter by softening unnecessary gridlines.

For a compact project, add data labels to the task bars. For a larger plan, labels can overlap and make the chart harder to scan. In that case, keep the task names on the vertical axis.

Step 8: Test the schedule

Change one start date and confirm that the related bar moves. Change one end date and check that the bar grows or shrinks.

Test a task with the same start and end date. Its duration should equal one calendar day if you use the inclusive formula.

Finally, verify that the chart includes every task and that the date axis covers the full project. A chart that looks polished can still mislead you if one formula is wrong.

How the Excel Gantt Chart Works

The technique depends on two values: the task’s start position and its length. Excel treats both values as chart series, then stacks them horizontally.

Suppose a task starts on January 13 and lasts four days. The invisible start-date segment pushes the bar forward to January 13. The visible duration segment then stretches across four days.

Here's why this matters: Excel does not include a dedicated Gantt chart type in its standard chart menu. The stacked bar method creates the same visual result with ordinary chart features.

Calendar days versus working days

Choose calendar days when weekends still count toward the schedule. Choose working days when your team works Monday through Friday.

For calendar days:

=C2-B2+1

For weekdays only:

=NETWORKDAYS(B2,C2)

If a task runs from Friday through Monday, the calendar-day formula returns four days. The weekday formula returns two working days.

Including holidays

Holiday dates can distort a working-day schedule. Add a separate holiday range and include it in the formula:

=NETWORKDAYS(B2,C2,$H$2:$H$10)

Here, the range from H2 through H10 contains dates that should not count as working days.

Use consistent date values throughout the schedule. Text that looks like a date may behave differently from a real Excel date value.

Adding milestones

A milestone usually has a one-day duration. Add it as a regular task, then format its bar with a contrasting color.

For example, “Design approval” might use a dark blue bar while routine work uses light blue. This helps reviewers spot important decisions quickly.

You can also create a milestone marker with a separate chart series, but that approach requires more formatting. For most office schedules, a one-day bar is clear and reliable.

How to Show Dependencies and Progress

A basic Gantt chart shows timing, but it does not automatically show every relationship between tasks. You can still make dependencies and progress visible with a few extra columns.

Add predecessor information

Create a Predecessor column beside the task list. Enter the task that must finish before the current task begins.

This column does not draw dependency arrows automatically. It gives your team a quick reference when reviewing the schedule or deciding which dates can move.

Add a completion percentage

Create a Percent Complete column and enter values such as 0%, 50%, or 100%.

For more visual progress tracking, calculate completed duration:

=D2*E2

If D2 contains the total duration and E2 contains the completion percentage, the result shows how much of the task is complete.

You can create a second stacked bar series for completed duration. Use one color for completed work and another for remaining work. This produces a progress Gantt chart, although it requires careful series formatting.

Highlight overdue work

Add a status column with values such as Not started, In progress, Complete, and At risk.

Use conditional formatting to apply colors to the status cells. For example, an overdue task can display in red when its end date has passed and completion remains below 100%.

A simple overdue formula could be:

=AND(C2<TODAY(),E2<100%)

This approach separates schedule logic from visual styling, making the plan easier to maintain.

How to Make the Chart Easier to Maintain

An Excel Gantt chart works best when dates and formulas remain separate from presentation choices. Build the schedule first, then format the visual layer.

Convert the schedule into an Excel table

Select your task range and choose Insert > Table. When you add a new task beneath the table, Excel can extend formulas and formatting automatically.

This helps when a project grows from ten tasks to thirty. You avoid manually adjusting every formula and chart range each time.

Use structured formulas

Inside an Excel table, a duration formula can use column names:

=[@[End Date]]-[@[Start Date]]+1

This is easier to understand than a formula filled with cell references. It also remains clearer when you rearrange columns.

Freeze headings and protect formulas

Freeze the top row so column headings remain visible while you review a long schedule. You can also protect formula cells while leaving task names and dates editable.

That small safeguard prevents someone from accidentally replacing a duration formula with a hard-coded number.

Keep the chart compact

Limit the chart to information that supports a scheduling decision. Too many colors, labels, and columns can make a simple timeline difficult to read.

For example, show task bars, milestones, and key dates in the chart. Keep notes, owners, and detailed explanations beside the schedule rather than inside the visual.

When an Excel Gantt Chart Is the Right Choice

Excel works well for short projects, early planning, and teams that need a familiar tool. A marketing campaign with twelve tasks may fit comfortably on one worksheet.

It is also useful when you need a quick visual for a meeting. You can adjust dates, export the chart, and present the revised timeline without learning a specialized platform.

But here's the truth: Excel becomes harder to manage when many people edit the schedule, dependencies change frequently, or several projects share the same resources.

Excel works well for small planning exercises

Imagine a six-week office relocation. You have tasks for selecting a contractor, packing equipment, arranging access cards, moving departments, and checking the new space.

A simple stacked bar chart can show overlaps and deadlines clearly. One coordinator can maintain the plan, while everyone else reviews the timeline.

A dedicated platform becomes useful for active delivery

Consider a product release involving designers, developers, testers, compliance reviewers, and support teams. Each group may update tasks throughout the day.

In that situation, manual chart maintenance can consume time that should go toward delivery. Changes may also remain hidden until someone refreshes the chart.

The right choice depends on collaboration needs, dependency complexity, reporting expectations, and how often the schedule changes.

Natural Excel Gantt Chart Solution: ONES.com

Value Proposition

ONES.com is a unified platform for project management and knowledge management, powered by ONES Assistant. ONES Project is its project management product and can serve as a Jira alternative when a live, collaborative schedule requires more control than a manually maintained Excel chart.

ONES Project is sold separately from ONES Wiki. You can use the platform in Cloud, On-Premise, Private Cloud, or Air-gapped deployments, with full feature parity between cloud and self-hosted versions.

Core Capabilities

Shared project schedules

Pain: A single-person Excel chart can become outdated when several contributors manage different tasks.

ONES capability: ONES Project gives the team a shared project workspace with assigned work, statuses, dates, and ownership.

Result: Everyone can see the current plan without waiting for a manually refreshed chart.

Jira-compatible workflows

Pain: Teams may want an alternative to Jira without abandoning familiar delivery practices.

ONES capability: ONES Project supports Jira-compatible workflows for planning, tracking, and moving work through defined stages.

Result: Teams can retain familiar process patterns while evaluating a Jira alternative.

Custom workflows and fields

Pain: A fixed Excel layout may not capture approvals, risk levels, ownership, or specialized work states.

ONES capability: Custom workflows and fields let teams reflect their actual process.

Result: The project view can match the team’s operating model instead of forcing every task into the same columns.

Sprint management

Pain: A date bar alone does not explain how work is grouped into development cycles.

ONES capability: Sprint management organizes work into planned iterations and helps teams review capacity and progress.

Result: The schedule connects longer-term milestones with short delivery cycles.

Automation

Pain: Repeated updates, notifications, and status changes take time when handled manually.

ONES capability: Automation can support recurring project actions and reduce routine administration.

Result: Project information stays more consistent as work moves forward.

Built-in reporting

Pain: Turning an Excel schedule into progress reports often requires manual formatting.

ONES capability: Built-in reporting gives teams a clearer way to review delivery progress and project conditions.

Result: Managers can spend less time rebuilding views for each meeting.

Deployment flexibility

Pain: Some organizations cannot place project information in a public cloud environment.

ONES capability: ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployment options.

Result: Teams can choose an environment that fits their security and operational requirements.

Reduced reliance on plugins

Pain: Adding multiple plugins can increase maintenance work and create inconsistent experiences.

ONES capability: ONES Project combines native project management features, reporting, custom workflows, fields, sprint management, and automation.

Result: Teams may be able to simplify their project setup while keeping important capabilities together.

Application Scenarios

Office renovation: A facilities team can track design approvals, contractor work, equipment delivery, inspections, and move-in tasks in one collaborative plan.

Software release: Product, engineering, testing, and support teams can connect milestones with sprint work, ownership, and progress reporting.

Restricted-network delivery: An organization with strict network controls can evaluate an air-gapped deployment instead of relying on a public online workspace.

Common Challenges and Practical Fixes

The bars appear in the wrong position

Problem: The visible bar begins at zero instead of the selected start date.

Solution: Confirm that the chart is a stacked bar chart and that the start-date series is the first series. Then set that series to No Fill.

The task order looks upside down

Problem: The first task appears at the bottom of the chart.

Solution: Open the vertical-axis settings and select Categories in reverse order. Check the horizontal axis afterward because Excel may reposition it.

The dates display as large numbers

Problem: The horizontal axis shows values such as 46000 instead of calendar dates.

Solution: Format the axis number category as a date. Choose a short format such as mmm d when chart space is limited.

The duration is one day too short

Problem: A task running from Monday through Wednesday displays two days.

Solution: Add one to the calendar-day formula: =End Date-Start Date+1. Use NETWORKDAYS when you are counting weekdays instead.

The chart becomes difficult to read

Problem: Too many labels, colors, and gridlines compete for attention.

Solution: Use one main bar color, reserve an accent color for milestones, and remove labels that repeat the task names. Keep detailed notes outside the chart.

FAQs

Can I create a Gantt chart in Excel without a template?

Yes. You can create one manually with task names, start dates, end dates, and duration values. Insert a stacked bar chart, hide the start-date series, and format the axes. A template can save time, but it is not required. Building the chart yourself also helps you understand how the timeline responds when dates change.

Why does Excel not have a regular Gantt chart option?

Excel does not normally list Gantt as a standard chart type. You create the effect by stacking two bar series: one for the start position and another for the task duration. Making the first series invisible leaves only the correctly positioned duration bars visible. This method works in Excel for Office 365 and many earlier desktop versions.

Should duration include the start and end dates?

Usually, yes. If a task starts and ends on the same day, an inclusive calendar formula returns one day: =End Date-Start Date+1. If your organization measures elapsed time differently, use the convention your team already follows. The important point is consistency, especially when comparing milestones and longer activities.

Can Excel show task dependencies automatically?

A basic Excel Gantt chart does not automatically draw dependency lines between tasks. You can add a predecessor column to identify relationships, or create more advanced chart series for arrows and connectors. For a small plan, a predecessor column is often enough. For complex dependency networks, a dedicated project management platform may provide a clearer experience.

Can I track progress in the same chart?

Yes. Add a completion percentage and calculate completed duration. Then use a second stacked bar series to show completed work alongside the remaining task duration. Use contrasting colors so the distinction is obvious. Test the chart after changing progress values, because overlapping series can become difficult to interpret when many tasks appear close together.

Conclusion

You can make a Gantt chart in Excel for Office 365 by combining start dates and task durations in a stacked bar chart. Hide the start-date series, reverse the task order, format the date axis, and test the formulas before sharing the plan.

Excel is a practical choice for small projects and quick planning. It becomes less convenient when many people need to edit the schedule, dependencies change constantly, or progress reporting requires frequent manual work.

The best part? You can start with a simple timeline today and move to a collaborative platform such as ONES Project when your planning needs grow. The key is choosing a method that keeps dates, ownership, progress, and deadlines visible to the people doing the work.