How to Make a Gantt Chart in Excel 2016: 7 Easy Steps [Guide]

Project schedules can become confusing quickly when tasks overlap, deadlines move, and nobody knows what should happen next. A plain task list shows activities, yet it rarely shows timing clearly.

That confusion creates missed handoffs, rushed work, and long status meetings. You may spend more time explaining the schedule than managing it.

Here’s the good news: Excel 2016 can turn a simple task list into a clear Gantt chart. You only need a task list, start dates, durations, and a few formatting changes.

In this guide, I’ll walk you through seven practical steps. You’ll also learn how to update the chart, fix common problems, and decide when dedicated project software makes more sense.

How to Make a Gantt Chart in Excel 2016

An Excel 2016 Gantt chart is a horizontal bar chart that shows each task, its start date, its duration, and its position within a project timeline.

Excel 2016 does not include a dedicated Gantt chart button. You create one with a Stacked Bar chart, then hide the series that represents the start date.

Here are the seven steps:

1. Prepare your project schedule. Create columns for task names, start dates, durations, and optional end dates.

2. Calculate task durations. Subtract each start date from its end date, then add one if your schedule counts both the first and last day.

3. Insert a stacked bar chart. Select the start dates and durations, then choose Insert, Bar Chart, and Stacked Bar.

4. Add task names to the vertical axis. Use Select Data to assign your task column as the category labels.

5. Reverse the task order. Format the vertical axis and select Categories in reverse order.

6. Hide the start-date series. Format that series with No Fill and No Line, leaving the duration bars visible.

7. Format the timeline. Adjust the horizontal axis, colors, labels, spacing, and chart title so the schedule is easy to read.

Here’s why: the hidden start-date series pushes each visible duration bar to the correct position. The result looks like a traditional Gantt chart.

Step 1: Build the task schedule

Start with a simple schedule. Use one row for each task and keep the headings short.

Enter real Excel dates instead of typing dates as plain text. Excel needs recognized date values to position bars correctly.

For example, place the start date in column B and the end date in column C. In cell D2, enter:

=C2-B2+1

Copy the formula downward. The added one counts both the start and end dates.

Step 2: Check your date and duration values

Before creating the chart, check that every task has a valid start date and a positive duration.

• Use the same date format across the schedule.
• Check that end dates come after start dates.
• Use whole numbers for durations.
• Remove empty task rows from the chart range.
• Keep task names specific enough to recognize quickly.

A duration of zero creates a barely visible bar. A negative duration may produce a misleading result or prevent the chart from behaving properly.

Step 3: Insert the stacked bar chart

Select the Start Date and Duration columns. You can include the headings, then select:

1. Open the Insert tab.
2. Choose the bar chart menu.
3. Select 2-D Bar.
4. Choose Stacked Bar.

Excel will create two colored series. One represents the start date, while the other represents the task duration.

The first version may look unusual. That is expected. You still need to add task labels and hide the start-date series.

Step 4: Add task names

Right-click the chart and select Select Data. Under Horizontal Category Axis Labels, choose Edit.

Select the cells containing your task names. Confirm the range, then click OK.

Your task names should now appear along the vertical axis. If Excel reverses the series or displays the wrong labels, reopen Select Data and check each range.

Step 5: Reverse the task order

Excel often places the first task at the bottom. Most project schedules read more naturally with the first task at the top.

Right-click the vertical axis, choose Format Axis, and select Categories in reverse order.

The task list should now run from the first activity at the top to the final activity at the bottom.

The best part? This change takes only a few seconds, yet it makes the chart much easier to scan during a project meeting.

Step 6: Hide the start-date series

Click one of the bars representing the start dates. Right-click it and select Format Data Series.

Under Fill, choose No Fill. Under Border, choose No Line.

The start-date series will disappear visually, while the duration bars remain in their correct positions.

Do not delete the start-date series. The chart needs it to preserve the spacing between the beginning of the timeline and each task.

Step 7: Format the timeline

Right-click the horizontal axis and select Format Axis. Set the minimum and maximum bounds to match your project period.

You can also adjust the major unit. A major unit of one day creates detailed scheduling, while seven days creates a weekly view.

• Use a clear title such as Website Launch Schedule.
• Choose one strong color for task bars.
• Reduce excessive white space with the gap width setting.
• Increase chart height when task names feel crowded.
• Use data labels only when they improve clarity.

How the Excel Gantt Chart Works

The chart uses two values for every task: the number representing its start date and the number representing its duration.

Excel stores dates as sequential numbers. A later date has a larger number, so the start-date series pushes each task bar farther along the timeline.

For example, a task beginning on April 1 starts near the left edge. A task beginning on April 9 receives a larger start-date value, so its visible bar begins later.

Here’s why: the start-date bars act like invisible spacers. The duration bars then show the actual work period.

Once you understand this structure, you can troubleshoot most formatting problems. If a bar begins too early, inspect the start date. If its length looks wrong, inspect the duration.

How to Add Dependencies and Milestones

Excel 2016 can show timing clearly, although it does not automatically manage every project relationship. You can still make dependencies easier to understand.

Suppose design must finish before development begins. Set development’s start date to the next working day after design ends. The visual gap will then reflect the handoff.

For milestones, create a task with a one-day duration. Give it a distinct color so it stands apart from longer activities.

Let me explain: the chart shows timing relationships, yet you must maintain those relationships by updating dates carefully.

How to Update and Share the Schedule

A Gantt chart remains useful only when the schedule stays current. Update the underlying task values first, then check the chart for unexpected gaps or overlaps.

When a task slips from April 5 to April 8, change its start date. If the duration remains the same, Excel moves the visible bar automatically.

For a longer project, use consistent colors for work categories. For example, blue can represent planned work, orange can represent review, and green can represent completed tasks.

• Review dates during a weekly planning session.
• Mark completed tasks with a consistent visual treatment.
• Keep the chart focused on major activities.
• Use a separate area for assumptions and notes.
• Check the printed or shared view before sending it to others.

You might be wondering: should every small activity appear on the chart? Usually, no. Include tasks that affect timing, ownership, handoffs, or major deliverables.

When Excel 2016 Is the Right Choice

Excel 2016 works well for a short project with one coordinator and a manageable number of activities. A product launch with 20 tasks may fit comfortably on one chart.

It also helps when your audience already knows Excel. You can create a visual schedule without introducing a new application or teaching a complex workflow.

The limitations appear as the project grows. Multiple owners, frequent updates, task dependencies, permissions, progress tracking, and team communication can become difficult to maintain manually.

Project Scheduling Solution: ONES.com

ONES.com combines project management and knowledge management in one platform. ONES Project provides project planning and tracking, while ONES Wiki supports organized team knowledge. They are sold separately.

If your Excel 2016 schedule has become difficult to maintain, ONES Project can provide Jira-compatible workflows, built-in reporting, custom fields, sprint management, and automation without relying on many separate plugins.

Core Capabilities

• Scattered task tracking: ONES Project centralizes tasks, owners, priorities, and status, so project information stays easier to follow.

• Manual timeline maintenance: Custom workflows and fields help standardize how your team creates, updates, and reviews work.

• Complex sprint planning: Sprint management supports iterative delivery when your team works in short development cycles.

• Limited progress visibility: Built-in reporting turns project activity into views that help you identify delays and workload concerns.

• Repeated administrative work: Automation can handle routine transitions, reminders, and status updates.

• Jira migration concerns: Jira-compatible workflows can make the transition easier for teams familiar with Jira practices.

• Plugin-heavy project environments: Native capabilities can reduce the need to connect numerous separate extensions.

• Restricted deployment requirements: ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments.

• Different hosting expectations: The self-hosted version provides feature parity with the cloud version, giving teams more deployment flexibility.

Application Scenarios

Software release planning: A development team can manage epics, sprints, testing activities, and release reporting within ONES Project. The team can replace a manually updated Excel timeline with connected work items and status views.

Operations improvement: An operations team can create repeatable workflows for approvals, handoffs, and follow-up actions. Custom fields can capture department, priority, risk, or service category.

Restricted-network projects: A team working in a controlled environment can choose an On-Premise, Private Cloud, or Air-gapped deployment. That approach supports local control while retaining the platform’s core capabilities.

Common Challenges

1. The bars appear in the wrong order

Problem: The first task appears at the bottom, making the schedule feel backward.

Solution: Format the vertical axis and select Categories in reverse order. Then confirm that the horizontal axis remains positioned correctly.

2. The timeline starts far before the project

Problem: A large blank area appears before the first visible task.

Solution: Format the horizontal axis and change the minimum bound to a date near the project start. Excel may choose a broad automatic range.

3. The duration bars disappear

Problem: You may have formatted the wrong series or selected No Fill for both series.

Solution: Click a visible bar, identify the selected series, and apply a solid fill only to the duration series.

4. Weekends make the chart hard to read

Problem: Calendar-day scheduling can make a workweek appear longer than expected.

Solution: Decide whether your project uses calendar days or working days. For working-day calculations, consider formulas such as NETWORKDAYS.

5. Updates become difficult to control

Problem: Several people change dates, labels, or formatting inconsistently.

Solution: Assign one schedule owner, protect formula cells, and establish a regular update routine. Consider a project platform when coordination becomes frequent.

FAQs

Can Excel 2016 create a Gantt chart without a template?

Yes. You can create one manually with a stacked bar chart. Enter task names, start dates, and durations, then hide the start-date series. Templates can save time, yet the manual method gives you more control over labels, colors, axis settings, and formulas.

Why does Excel use a stacked bar chart?

A stacked bar chart lets you combine two values for each task. The first value positions the task along the timeline, while the second value shows its duration. Hiding the first series leaves the visible bars looking like a conventional Gantt chart.

How do I show weekends in the schedule?

Use calendar-day durations when weekends should count toward task length. If your team works Monday through Friday, calculate working days with Excel’s workday functions. Then check the result against real holidays and planned closures.

Can I show task progress in Excel 2016?

Yes. Add a progress column and create another series for completed duration. You can format completed work with a darker color and remaining work with a lighter color. This takes extra setup because the chart needs multiple stacked series.

When should I move beyond Excel?

Consider a dedicated project platform when several people need frequent updates, dependencies change often, reporting takes significant manual effort, or access control matters. Excel remains useful for simple schedules, while connected project management becomes more valuable as coordination grows.

Conclusion

To create a Gantt chart in Excel 2016, prepare task dates and durations, insert a stacked bar chart, add task labels, reverse the task order, hide the start-date series, and format the timeline.

The method works well for small, clearly defined projects. Use formulas carefully, keep task names readable, and update the schedule consistently.

When overlapping work, reporting needs, permissions, and team coordination outgrow manual chart maintenance, ONES.com offers a broader project management approach through ONES Project.

That gives you a practical path forward: start with Excel for a focused timeline, then move to connected project workflows when the schedule becomes harder to control.