Guide · 2026-10-15

How to Make a Gantt Chart in Office 365: Step-by-Step Guide

Building a Gantt chart in Office 365 can feel harder than planning the project itself. Excel gives you the flexibility, yet it does not offer a one-click Gantt chart type. That leaves you choosing between a template, a manual chart, or another Microsoft 365 app.

The wrong approach creates unclear dates, cramped labels, and hours of repetitive formatting. A small schedule change can force you to adjust several bars by hand. That becomes risky when multiple people need to track the same plan.

Here’s the practical solution: create a task table in Excel, calculate each task’s duration, then turn a stacked bar chart into a Gantt chart. I’ll show every step, explain common mistakes, and cover better options for larger projects.

How to Create a Gantt Chart in Office 365

To make a Gantt chart in Office 365, create a task table in Excel, calculate task duration, insert a stacked bar chart, hide the start-date series, and format the remaining bars as your timeline. You can also start with an Excel Gantt template if you need a faster setup.

Step 1: Create the project schedule table

Open Excel through Microsoft 365 and create four columns:

For example, a website launch might include these tasks:

Task Start Date End Date Duration
Plan site structure March 3 March 5 3 days
Write page content March 6 March 12 7 days
Build landing page March 10 March 17 8 days
Test and publish March 18 March 20 3 days

Use real Excel date values rather than typed text. Excel can then calculate durations and position each bar correctly.

Step 2: Calculate the duration

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

=C2-B2+1

Here, column B contains the start date, and column C contains the end date. The plus-one includes both the first and final days.

For working days only, use this formula instead:

=NETWORKDAYS(B2,C2)

To exclude holidays, create a holiday list and use:

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

Choose one calculation method and use it consistently. Mixing calendar days with working days can make your timeline misleading.

Step 3: Insert a stacked bar chart

Select the Task, Start Date, and Duration columns. Then select Insert, choose Bar Chart, and select Stacked Bar.

Excel will create two series. The first represents the time before each task starts. The second represents the task duration.

At this stage, the chart may look like ordinary horizontal bars. That is expected. The formatting steps transform it into a Gantt chart.

Step 4: Hide the start-date series

Click one of the bars representing Start Date. Open the formatting panel, select Fill, and choose No Fill.

The start-date series becomes invisible. The Duration series remains visible and appears at the correct point along the timeline.

Here’s why: the hidden series still takes up space. It pushes each visible duration bar forward to its scheduled start date.

Step 5: Reverse the task order

Click the vertical task axis and open Format Axis. Turn on Categories in reverse order.

Your first task should now appear at the top. This creates the familiar top-to-bottom project sequence.

If the horizontal date axis moves to an awkward position, adjust the axis settings until the labels sit beneath the chart.

Step 6: Format the timeline

Improve readability with a few focused adjustments:

Avoid using many colors without a clear reason. One color for planned work and another for milestones usually creates a cleaner view.

Step 7: Add progress tracking

For progress tracking, add columns such as Progress, Owner, and Status. You can represent progress with a second duration series.

For example, a task lasting ten days with 40% completion has four completed days. A second bar can show those four days inside the planned duration.

Keep this addition simple. A chart that shows every detail can become difficult to read during meetings.

Step 8: Keep the chart updated

When a task changes, update its start date, end date, or progress value. The duration formula should recalculate automatically.

Check the chart after major changes. Confirm that dependent tasks still follow the correct sequence and that the final deadline remains realistic.

Choose the Right Office 365 Method

Excel works well when you need a flexible visual schedule for a small or medium project. It is especially useful for a presentation, a launch plan, or a short-term construction timeline.

For a faster start, search Excel’s template gallery for a Gantt template. Templates reduce setup time, although they may include formatting or formulas you do not need.

Microsoft Project offers more advanced scheduling features, including dependencies, resource planning, and baseline tracking. Its learning curve and licensing requirements may make it excessive for a simple timeline.

Method Best for Primary limitation
Excel manual chart Custom visual schedules Changes require careful maintenance
Excel Gantt template Quick project overviews Less control over built-in formatting
Microsoft Project Complex dependencies and resources More training and licensing effort
Dedicated project platform Collaborative planning and reporting Requires workflow setup

You might be wondering: which option should you choose? Start with Excel when the chart is mainly for viewing. Choose project software when people must actively update tasks, dependencies, owners, and progress.

Common Gantt Chart Mistakes to Avoid

The most common mistake is treating a Gantt chart as a decorative timeline. A useful chart should help you spot delays, workload conflicts, and dependency problems.

For example, if content writing finishes after development begins, the chart should make that conflict visible. A carefully ordered task list can reveal the issue before work starts.

Using text instead of real dates

Text such as “next Monday” may look understandable, but Excel cannot always interpret it consistently. Enter dates using a recognizable format, then confirm the cell format displays them correctly.

Ignoring task dependencies

A duration bar does not automatically show which task must finish first. Add a predecessor column or a dependency note when the sequence affects delivery.

Adding too many tasks

A chart with hundreds of tiny activities becomes difficult to scan. Group related work into phases, then keep detailed activities in the project workspace.

Forgetting weekends and holidays

A seven-day duration and a seven-working-day duration represent different schedules. Decide whether your project operates on calendar days or working days.

Failing to define ownership

Dates alone do not explain who must act. Add an owner field so every important task has a clear person responsible for progress.

How to Make the Chart Easier to Read

Good visual design reduces the time needed to understand a schedule. Keep task names short, use consistent date labels, and leave enough space between bars.

Use milestones for decisions, approvals, launches, and handoffs. A milestone can be represented by a zero-duration task or a separate marker.

Color can communicate status when used consistently. For example, blue may represent planned work, green completed work, and red delayed work.

But here’s the truth: color cannot replace a clear status field. Someone viewing the chart without a legend may misunderstand your meaning.

When an Excel Gantt Chart Stops Working

An Excel chart becomes harder to manage when several people edit it, task relationships change frequently, or leaders need live reports.

Imagine a product launch with 120 tasks, six owners, and three approval stages. Every schedule change can affect multiple dates. Manual updates create opportunities for missed relationships.

At that point, a project platform can connect tasks, workflows, status updates, permissions, and reporting. The chart becomes one view of the plan rather than the entire planning system.

The best part? You can still export or present a clean timeline when stakeholders need a simple visual summary.

Project Planning Solution: ONES.com

ONES.com product screenshot

Value Proposition

ONES.com combines project management and knowledge management in one platform, with AI support through ONES Assistant. ONES Project is the project management product and works as a Jira alternative.

It suits teams that need structured planning, collaboration, reporting, and controlled deployment options beyond a manually maintained Office 365 chart.

Core Capabilities

Application Scenarios

Software release planning: A development team can manage sprints, testing, approval stages, and release tasks in one workflow. Progress reports give managers a current view without rebuilding an Excel chart.

Marketing campaign coordination: A marketing team can assign writing, design, review, and publishing activities. Custom fields can track campaign channels, owners, and approval status.

Restricted-network project management: A regulated team can use an On-Premise or Air-gapped deployment. This keeps project planning within the organization’s required environment.

Common Challenges

Challenge: The bars start on the wrong dates

Solution: Confirm that Excel recognizes your start dates as dates. Also check that the Start Date series appears before Duration in the chart’s series order.

Challenge: The task order looks upside down

Solution: Open the vertical axis settings and enable Categories in reverse order. Then check the horizontal axis position.

Challenge: Weekends distort the schedule

Solution: Decide whether the project uses calendar days or working days. Apply either subtraction or NETWORKDAYS consistently.

Challenge: The chart is too crowded

Solution: Group small activities into phases. Keep the visual schedule focused on meaningful deliverables and milestones.

Challenge: Several people need to update the plan

Solution: Use a shared Microsoft 365 location with clear editing rules, or move the work into a collaborative project platform such as ONES Project.

FAQs

Can I create a Gantt chart directly in Excel through Microsoft 365?

Yes. Excel does not usually provide a dedicated Gantt chart type, but you can create one with a stacked bar chart. Use Start Date as the first series and Duration as the second. Hide the Start Date series, reverse the task order, and format the axes. You can also begin with an Excel template if you want less manual setup.

What formula calculates task duration in Excel?

For calendar days, use =EndDate-StartDate+1. For working days, use =NETWORKDAYS(StartDate,EndDate). Add a holiday range to the second formula when public holidays should be excluded. The correct formula depends on whether your project runs every day or follows a working-week schedule.

Can I show task progress on an Excel Gantt chart?

Yes. Add a progress value and calculate completed duration separately. For a ten-day task at 40% completion, completed duration equals four days. Add that value as another chart series and use a contrasting color. Keep the visual simple so progress remains easy to interpret.

Should I use Excel or Microsoft Project?

Use Excel for a flexible overview, a small project, or a presentation. Microsoft Project is more suitable when you need detailed dependencies, resource planning, baselines, and advanced scheduling. A dedicated platform may fit better when several people need live updates, workflow automation, and shared reporting.

Can a project platform replace an Excel Gantt chart?

It can replace the manual maintenance behind the chart while still providing timeline views. A project platform connects tasks, owners, workflows, progress, and reporting. That approach becomes valuable when schedule changes happen often or several teams contribute to the same plan.

Conclusion

To create a Gantt chart in Office 365, build a task table in Excel, calculate durations, insert a stacked bar chart, hide the start-date series, and format the timeline.

Keep the schedule readable by using real dates, checking working-day rules, showing dependencies, and limiting unnecessary detail. Excel is a practical choice for smaller plans and visual summaries.

When updates, approvals, reporting, and collaboration become frequent, a dedicated platform such as ONES Project can provide a more connected workflow. Start with the simplest method that reflects your project’s real complexity.