How to Make a Gantt Chart in Office 365: 7 Easy Steps (2026)

Building a project timeline in Office 365 can feel harder than the work itself. Excel has no single “Gantt chart” button, so many people waste time formatting bars manually. A small mistake in dates can also make milestones appear late, tasks overlap incorrectly, or the whole schedule become difficult to update.

That frustration grows when several people need to track progress. A chart that looks clear on Monday can become confusing after priorities, owners, or deadlines change. But here’s the truth: you can create a useful Gantt chart in Excel with a simple stacked bar chart. The process takes seven practical steps, and you can reuse the layout for future projects.

This guide shows you exactly how to build one, customize it, avoid common errors, and decide when a dedicated project management platform makes more sense.

How to Make a Gantt Chart in Office 365

The easiest Office 365 method uses Excel. You create a task list, calculate task duration, insert a stacked bar chart, and hide the first series so the remaining bars look like a project timeline.

Here’s why: Excel does not have a native Gantt chart type in the standard chart menu. However, a stacked bar chart can produce the same visual effect with a few formatting changes.

1. Create a task planning area

   Open Excel in Office 365 and create columns for the information your project needs. Start with a simple structure:

   Task	Owner	Start Date	End Date	Duration	Status
   Gather requirements	Alex	January 6, 2026	January 8, 2026	3	Complete
   Create wireframes	Sam	January 9, 2026	January 14, 2026	6	In progress
   Build prototype	Jordan	January 15, 2026	January 23, 2026	9	Not started

   Keep each task on its own row. Use real Excel dates rather than typing dates as ordinary text. Excel needs date values to position bars correctly.

2. Calculate each task’s duration

   The duration tells Excel how long each bar should extend. In the first duration cell, subtract the start date from the end date and add one:

   =D2-C2+1

   In this example, column C contains the start date and column D contains the end date. The extra one counts both the starting day and ending day.

   For example, January 6 through January 8 equals three calendar days. Without +1, Excel would calculate two days.

   Copy the formula down the duration column. If your project uses working days only, you can use:

   =NETWORKDAYS(C2,D2)

   That formula excludes weekends. You can also add a holiday range when your schedule requires more precise working-day calculations.

3. Insert a stacked bar chart

   Select the Task, Start Date, and Duration columns. You can select separate ranges by holding the Ctrl key on Windows or the Command key on a Mac.

   Then choose:

   • Insert
   • Bar Chart
   • 2-D Stacked Bar

   Excel will create two colored portions for every task. The first portion represents the waiting period before the task begins. The second portion represents the task duration.

   At this stage, the chart may look more like a standard bar chart than a Gantt chart. That is normal. The next steps create the timeline effect.

4. Put tasks in the correct order

   Excel often places the first task at the bottom. To reverse the order, click the vertical task axis and open the formatting options.

   Turn on Categories in reverse order. Your first task should now appear at the top, matching the order in your planning area.

   Check the task names carefully. If labels appear as numbers or dates, Excel probably selected the wrong range. Return to the chart’s data settings and assign the Task column as the category labels.

5. Hide the start-date series

   Click the first colored section of any bar. This series represents the number of days before each task begins.

   Set its fill to No fill and its border to No line. The duration portion will remain visible and appear in the correct position on the timeline.

   Let me explain: you are not deleting the start-date information. You are making that series invisible while Excel continues using it to position each task.

6. Format the date axis

   Click the horizontal axis and open the axis formatting panel. Adjust the bounds and units so the chart shows the project period clearly.

   Useful settings include:

   • Set the minimum bound to the earliest project start date.
   • Set the maximum bound slightly beyond the final deadline.
   • Use a major unit of seven days for weekly planning.
   • Use a major unit of one day for short projects.
   • Apply a readable date format, such as Jan 6 or Jan 6, 2026.

   If dates appear as large numbers, change the axis number format to a date format. Excel stores dates as serial numbers, so the chart may show those numbers until you adjust the display.

7. Improve readability and test the schedule

   Rename the chart, remove unnecessary legends, and choose a bar color that contrasts with the background. Increase the chart height if task names feel crowded.

   You can also add status colors. For example, use green for completed tasks, blue for active work, and gray for tasks that have not started.

   Before sharing the chart, change one start date and confirm that the bar moves. Change one end date and confirm that the duration changes. These quick tests reveal broken formulas and incorrect date formats.

   The best part? Once the formulas and chart structure work, you can replace the sample tasks with your own project plan.

What a Gantt Chart Shows

A Gantt chart displays project tasks as horizontal bars across a calendar timeline. Each bar shows when a task begins, how long it lasts, and when it should finish.

For example, a website launch might include planning, design, development, testing, and release. The chart places those activities on one timeline, making overlaps and gaps easier to see.

Most Gantt charts include task names, start dates, end dates, durations, owners, progress, and milestones. You do not need every field for a useful chart. A small marketing campaign may only require tasks, dates, owners, and status.

Tasks, milestones, and dependencies

A task has a duration, such as “write landing page” over five days. A milestone marks an important point, such as “design approved,” and usually has no duration.

Dependencies show relationships between tasks. Testing may depend on development finishing first. A launch may depend on testing and approval.

Excel can display these relationships visually, but it does not manage them as smoothly as dedicated project software. You may need to adjust dates manually when an earlier activity changes.

Calendar days versus working days

Decide whether your schedule uses calendar days or working days before building the chart. A three-day task may mean Monday through Wednesday, or three consecutive days including a weekend.

Use simple subtraction for calendar schedules. Use NETWORKDAYS when weekends should not count. State your choice near the chart so nobody misreads the timeline.

How to Add Progress and Milestones

A basic chart shows planned timing. Adding progress makes it more useful during project reviews.

One practical approach uses a progress percentage column. For a task lasting ten days and 40 percent complete, the completed portion equals four days.

Create a progress calculation

Add a column named Progress and enter percentages such as 0%, 25%, 50%, or 100%. Then add a calculated column for completed duration:

=E2*G2

In this example, column E contains total duration and column G contains progress. A second stacked bar series can represent completed work, while the remaining duration shows unfinished work.

Use contrasting colors carefully. A dark blue completed section inside a light blue planned bar is usually easier to read than several bright colors.

Mark milestones clearly

For a milestone, set the start and end dates to the same day. Its duration becomes one day, which may appear as a very narrow bar.

You can replace that bar with a diamond shape or add a text label. Select the milestone row, choose a distinct color, and add a short label such as “Approval” or “Launch.”

For a small schedule, milestone labels may be enough. For a complex plan, use a separate milestone series so important dates remain visible.

How to Make the Chart Easier to Maintain

A chart can look polished and still become unreliable after a few updates. The best maintenance approach is to separate planning details from visual formatting.

Turn the task range into an Excel table

Select your planning area and choose Insert, then Table. Excel tables expand when you add new rows and copy formulas automatically.

This reduces manual work when a project gains a new task. Check the chart after adding a row, because some chart ranges may need to be expanded manually.

Use consistent date rules

Choose one date style and apply it everywhere. Mixing January 6, 06/01/2026, and 1-6-26 can cause confusion, especially for teams in different regions.

Use a four-digit year when the schedule covers more than one year. A date such as January 6, 2026 removes unnecessary ambiguity.

Protect formulas from accidental changes

People often overwrite duration formulas while updating dates. Color-code editable cells and formula cells differently. You can also protect formula cells while leaving planning cells unlocked.

For example, use pale yellow for dates people can edit and light gray for calculated durations. A short legend beside the chart explains the difference.

Review the chart at a useful scale

A six-month project may look unreadable when every day appears on the axis. Use weekly or monthly intervals for longer schedules.

A two-week project needs more detail. Daily intervals can help the team spot handoff gaps and overlapping work.

When Excel Is the Right Choice

Excel works well for short projects, personal planning, and schedules with limited dependencies. It is also useful when stakeholders already understand Office 365 and need a familiar planning format.

Imagine a three-person event team preparing a product webinar. The plan contains twelve tasks, two milestones, and a single launch date. An Excel Gantt chart may be all they need.

Excel becomes less comfortable when several people update the plan at once. Manual status updates, unclear ownership, and disconnected communication can make the chart lag behind reality.

You might be wondering: when should you move beyond a chart? Consider dedicated project management software when your schedule has many dependencies, recurring updates, cross-team work, approval steps, or detailed reporting needs.

When a Dedicated Project Workspace Makes More Sense

A Gantt chart answers one question well: when should each activity happen? A complete project workspace also manages conversations, requirements, responsibilities, approvals, and progress history.

For example, an engineering team may need sprint planning, custom fields, workflow rules, reports, and controlled access. Recreating all those functions around an Excel chart can create more maintenance than value.

Compare the two approaches:

The right choice depends on project complexity. You do not need a large platform for every small timeline, but you should avoid forcing Excel to act like a full project system.

A Practical Alternative for Structured Project Planning: ONES.com

ONES.com combines project management and knowledge management in one platform. ONES Project provides project planning, workflow control, reporting, and collaboration, while ONES Wiki supports organized team knowledge.

If your Office 365 Gantt chart keeps requiring manual updates, ONES Project can provide a more connected environment for tasks, schedules, owners, and progress.

Value Proposition

ONES.com helps you move from a static timeline toward a structured project workspace. ONES Project is sold separately from ONES Wiki, so you can choose the product that matches your team’s needs.

Core Capabilities

1. Manual timeline updates become connected project planning

Pain: An Excel chart may show planned dates, while current task activity lives elsewhere.

ONES capability: ONES Project connects tasks, owners, statuses, schedules, and workflows in a shared project environment.

Result: Your timeline reflects project activity more consistently, reducing repeated status checks.

2. Complex dependencies become easier to manage

Pain: Moving one task in Excel may require manual changes to several following tasks.

ONES capability: Jira-compatible workflows and structured task relationships help teams organize work across connected activities.

Result: Teams can see how changes affect delivery planning without rebuilding every chart element.

3. Custom planning needs become configurable workflows

Pain: A fixed spreadsheet layout may not match an engineering, marketing, or operations process.

ONES capability: ONES Project supports custom workflows and custom fields for different project types.

Result: You can capture information such as risk level, approval owner, release area, or customer impact.

4. Repeated manual reporting becomes built-in reporting

Pain: Teams may spend hours converting task updates into weekly status summaries.

ONES capability: Built-in reporting helps organize project progress and delivery information.

Result: Managers can review project health with less manual calculation and presentation work.

5. Sprint planning becomes part of the same workflow

Pain: Agile teams may maintain a timeline separately from sprint planning.

ONES capability: ONES Project includes sprint management alongside broader project planning.

Result: Sprint activities and longer delivery goals can stay connected in one project environment.

6. Plugin-heavy setups become more streamlined

Pain: A team may rely on several add-ons to fill gaps in its project workflow.

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

Result: Fewer separate extensions can reduce configuration work and simplify administration.

7. Restricted environments become easier to support

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 deployments, with full feature parity between cloud and self-hosted versions.

Result: Teams can choose a deployment model that matches their security and infrastructure requirements.

8. Migration from Jira workflows becomes more practical

Pain: Teams may want to move away from Jira while preserving familiar working patterns.

ONES capability: ONES Project functions as a Jira alternative with compatible workflows and a project management focus.

Result: Teams can evaluate a different platform without abandoning every established process.

Application Scenarios

Product development release

A product team may start with an Excel Gantt chart for discovery, design, development, testing, and release. As contributors increase, ONES Project can organize those activities into workflows, sprints, owners, and reports.

The team can keep longer delivery goals visible while managing day-to-day work through structured project views.

Client implementation program

An implementation team may coordinate onboarding, configuration, training, approval, and launch across several departments. A simple chart can show dates, but it may not capture ownership changes and approval stages clearly.

ONES Project can add custom fields and workflow steps for approval status, customer priority, implementation phase, and delivery risk.

Restricted-network engineering work

An engineering organization with strict network controls may need self-hosted project management. ONES.com offers On-Premise, Private Cloud, and Air-gapped deployment options.

This gives the team a way to manage structured work while aligning deployment with its infrastructure requirements.

Common Challenges and Practical Fixes

Challenge: The bars begin on the wrong dates

Cause: Excel may treat dates as text, or the chart may use the wrong category range.

Solution: Format the date cells as dates, test one date with a simple subtraction formula, and verify the chart’s category labels.

Challenge: The first task appears at the bottom

Cause: Excel’s category axis often displays the first row at the bottom of a horizontal bar chart.

Solution: Open the vertical axis settings and enable Categories in reverse order.

Challenge: New tasks do not appear

Cause: The chart may point to a fixed range rather than an expanding Excel table.

Solution: Convert your planning range into an Excel table or expand the chart’s selected range manually.

Challenge: The chart becomes too crowded

Cause: Too many tasks, labels, colors, and daily markers compete for attention.

Solution: Group minor activities, use weekly or monthly axis intervals, and reserve strong colors for milestones or major status differences.

Challenge: The schedule quickly becomes outdated

Cause: People may update tasks in separate places or forget to refresh the chart.

Solution: Assign one schedule owner, set a regular update time, and consider a project workspace when progress tracking becomes continuous.

FAQs

Can I create a Gantt chart directly in Excel for the web?

Yes. Excel for the web supports the stacked bar chart method, although some advanced formatting controls may appear in different locations. Create task dates and durations, insert a stacked bar chart, hide the start-date series, and format the date axis. If a setting is unavailable online, open the workbook in the desktop version of Excel.

What formula should I use for task duration?

For calendar days, use =EndDate-StartDate+1. For example, if the start date is in C2 and the end date is in D2, use =D2-C2+1. For working days, use =NETWORKDAYS(C2,D2). Choose one method consistently across the project.

Why does Excel show numbers instead of dates?

Excel stores dates as serial numbers internally. The chart may display those numbers when the axis format is set to General. Select the horizontal axis, open the number format settings, and choose a date style such as mmm d or mmm d, yyyy.

Can I add task dependencies to an Excel Gantt chart?

You can represent dependencies with task order, notes, or connector lines, but Excel will not automatically reschedule related tasks as smoothly as dedicated project software. For a small plan, manual updates may be sufficient. For a complex schedule, linked workflows and dependency management can reduce maintenance.

Should I use Excel or a dedicated project management platform?

Use Excel when the project is small, the schedule changes rarely, and one person can maintain it. Consider a dedicated platform when many contributors update work, dependencies affect delivery, reporting is frequent, or several teams share the same plan. The more coordination your project needs, the more valuable structured workflows become.

Can I turn an Excel schedule into a reusable template?

Yes. Keep the formulas, chart formatting, axis settings, legend, and status colors. Replace the sample tasks with project-specific activities, then test the chart with different dates. Add short instructions near editable cells so the next person knows which fields are safe to change.

Conclusion

You can make a Gantt chart in Office 365 by using Excel’s stacked bar chart method. Create task dates, calculate duration, insert the chart, reverse the task order, hide the start-date series, format the date axis, and test every update.

But here’s the truth: the chart is only as reliable as the planning habits around it. Use consistent dates, clear ownership, protected formulas, and a regular review routine.

For a short project, Excel may provide exactly the visibility you need. When your timeline grows into a shared workflow with dependencies, reporting, approvals, and continuous updates, ONES.com can provide a more structured path through ONES Project.