How to Make a Gantt Chart in Excel 2016: 7 Simple Steps!

Creating a Gantt chart in Excel 2016 can feel harder than planning the project itself. You enter dates, insert a chart, and still end up with confusing bars or the wrong timeline. A small formatting mistake can make task durations look inaccurate. Worse, Excel 2016 does not include a dedicated Gantt chart button.

But here's the truth: you can build a clear project schedule with Excel’s built-in stacked bar chart. You only need a task list, start dates, durations, and a few formatting changes. This guide walks you through seven practical steps, explains common mistakes, and shows how to keep the finished chart easy to update.

How to Make a Gantt Chart in Excel 2016

To make a Gantt chart in Excel 2016, create a task table with start dates and durations, insert a stacked bar chart, hide the start-date series, and format the axis. Excel uses the invisible start-date bars to position each visible duration bar on the timeline.

Here is a simple example you can follow:

Step 1: Prepare your project schedule

Open a new Excel workbook and create three columns named Task, Start Date, and Duration.

Enter one task per row. Use real Excel dates in the start-date column, then enter the length of each task in days.

For example, a task beginning on January 6 and ending on January 10 has a duration of five calendar days.

Keep the schedule simple at first. You can add owners, milestones, costs, or completion percentages after the chart works correctly.

Step 2: Check that Excel recognizes your dates

Click a start date and look at the Home tab. The Number group should show a date format, such as Short Date.

If Excel treats the date as plain text, the chart will not position tasks correctly. Re-enter the date using a consistent format, such as 1/6/2025.

You can also test the date with a simple formula. In an empty cell, type =B2+1, assuming the first date appears in cell B2.

If the result becomes the next calendar day, Excel recognizes the value correctly.

Step 3: Select the schedule range

Select the three columns containing task names, start dates, and durations. Include the headings, but exclude empty rows.

For the example above, the selected range might be A1:C5.

Here's why: Excel needs the task labels and both numerical series to build the chart structure.

If you select unrelated columns, Excel may add extra series or assign the wrong labels.

Step 4: Insert a stacked bar chart

Open the Insert tab, choose Bar Chart, and select 2-D Stacked Bar.

Excel will create two colored bar segments for every task. One segment represents the start date, while the other represents the task duration.

At this stage, the chart may look nothing like a schedule. That is normal.

The start-date segment creates spacing before each task. You will make that segment invisible in the next step.

Step 5: Hide the start-date series

Click one of the bars representing the start-date series. Right-click it and choose Format Data Series.

In the formatting panel, choose Fill & Line. Under Fill, select No Fill. Under Border, select No Line.

The start-date series will disappear, leaving only the colored duration bars.

Let me explain: the series still exists and continues positioning each task. It is simply invisible to the viewer.

Step 6: Reverse the task order

Excel usually places the first task at the bottom of a horizontal bar chart. Most project schedules read from top to bottom instead.

Right-click the task labels on the vertical axis and choose Format Axis.

Under Axis Options, select Categories in reverse order.

The first task should now appear at the top. You may need to adjust the horizontal axis position afterward.

Step 7: Format the timeline and finish the design

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

Excel stores dates as serial numbers. Therefore, the axis may display large numbers until you apply a date format.

In the Number section, choose a date format such as mmm d or m/d.

Finally, reduce the gap width between bars, choose a clear color, add a chart title, and remove the legend entry for the hidden series.

1. Review the task labels. Make sure every task appears once and reads clearly.
2. Check the bar lengths. Compare each visible bar with its duration value.
3. Inspect the timeline. Confirm that the first bar begins near the correct date.
4. Test an update. Change one start date and confirm that the bar moves.
5. Save a backup copy. Preserve a working version before making major formatting changes.

How the Excel Gantt Chart Method Works

Excel 2016 creates this schedule through a visual trick. A stacked bar chart places one series before another on the same horizontal row.

The first series equals the number of days between Excel’s starting point and the task start date. The second series equals the task duration.

For example, suppose a task starts on January 13 and lasts eight days. Excel places an invisible segment before the task, then draws an eight-day visible segment.

The invisible segment acts like empty space. It pushes the task bar to the correct location on the timeline.

Why a stacked bar chart works

A column chart grows upward from a baseline. A stacked bar chart grows horizontally, which matches the way project schedules move across dates.

Each row becomes one task. The horizontal position shows when work begins, and the visible length shows how long the work continues.

Consider a website launch schedule. Planning may begin on Monday, design may begin the following week, and testing may begin after development ends.

The hidden start-date series creates those gaps without requiring separate shapes or manual positioning.

Why Excel does not show a dedicated Gantt option

Excel 2016 includes several standard chart types, including stacked bars. It does not include a one-click Gantt chart template in the regular chart gallery.

That means you build the visual manually with existing chart features.

The approach works well for short schedules. Complex plans with dependencies, resource conflicts, and frequent changes require more maintenance.

How to Calculate Durations Correctly

Your chart is only as reliable as the duration values behind it. Decide whether your schedule uses calendar days or working days before entering formulas.

For calendar days, subtract the start date from the end date and add one:

=C2-B2+1

Here, B2 could contain the start date and C2 could contain the end date. The added one counts both the first and final day.

Calendar-day example

Imagine a task starts on March 3 and ends on March 7. The calculation returns five days.

That result includes Monday, Tuesday, Wednesday, Thursday, and Friday.

If the task starts on March 3 and ends on March 10, the result returns eight calendar days.

This approach suits activities that continue through weekends, such as equipment monitoring or service availability.

Working-day example

For a Monday-to-Friday schedule, use Excel’s NETWORKDAYS function:

=NETWORKDAYS(B2,C2)

This formula excludes Saturdays and Sundays. You can also exclude holidays by adding a holiday range:

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

The result may differ from a calendar-day calculation. A task running from Friday through Monday covers four calendar days but only two standard workdays.

Duration mistakes that distort the chart

A duration of zero creates no visible bar. A negative duration may produce confusing results or an error.

Blank dates can also push bars to unexpected positions. Check for missing values before reviewing the visual design.

Here's why: the chart does not understand project intent. It only reflects the values in the worksheet.

How to Format the Chart for Clear Communication

A technically correct chart can still be difficult to read. Use formatting to make timing, sequence, and ownership obvious.

Start with the horizontal axis. Show enough dates to establish context, but avoid labeling every single day on a long project.

For a two-week plan, daily labels may help. For a six-month plan, weekly or monthly labels are easier to scan.

Adjust the gap width

Right-click a visible bar and choose Format Data Series. Find Gap Width and reduce the percentage.

A lower gap width makes task bars thicker. Thicker bars are easier to see when the schedule contains many rows.

Try a value between 30% and 60%, then adjust it according to the number of tasks.

Use color with purpose

Choose one main color for ordinary tasks. Add a second color for milestones, delayed work, or tasks requiring attention.

For example, blue can represent planned work, green can represent completed work, and orange can indicate risk.

Keep the palette limited. Too many colors force readers to decode the chart before understanding the schedule.

Add progress tracking carefully

Excel’s basic chart uses duration, so it does not automatically show completed work inside each task bar.

You can add a completion column and create additional series for completed and remaining portions.

For a 10-day task that is 40% complete, calculate four completed days and six remaining days.

This requires a more advanced stacked bar design. Build the basic schedule first, then add progress tracking after confirming the timeline.

Show milestones

A milestone has a date but no duration. A standard bar may disappear when the duration equals zero.

You can represent milestones with a separate marker series, a diamond shape, or a vertical reference line.

For example, place a diamond on the final approval date. Label it “Launch approval” so the meaning remains clear.

How to Update and Maintain the Schedule

A Gantt chart becomes valuable when it stays current. Set a simple update routine instead of redesigning it every time a date changes.

Keep task names, dates, and durations in a consistent area. Avoid typing directly onto the chart because those labels will not update with the schedule.

Updating a start date

Change the start date in the schedule area. The visible bar should move automatically.

If it does not move, click the chart and inspect the selected range under the Chart Design tab.

You may have selected a static range that excludes the changed row.

Adding new tasks

When you add a task below the existing range, Excel may or may not include it automatically.

Click the chart, choose Select Data, and expand the chart range to include the new row.

A formatted Excel table can make expansion easier. Select the schedule area, choose Insert, then select Table.

When you add rows directly below that table, Excel often extends formulas and formatting automatically.

Handling schedule changes

When a task slips, update its start date and duration. Then check the tasks that depend on it.

For instance, if development finishes three days late, testing may also need a later start date.

Excel can show the changed dates, but it does not automatically understand task dependencies in the way dedicated project software does.

You must review connected tasks manually and record the reason for important changes.

When an Excel Gantt Chart Is a Good Choice

Excel works well for small projects with a manageable number of tasks. It is useful when you need a quick visual plan for a meeting or a short-term initiative.

A marketing campaign with 15 tasks is a practical example. You can show planning, design, review, publication, and reporting on one page.

It also suits a personal renovation plan, where tasks have simple dates and limited dependencies.

Signs that Excel may be enough

• The schedule has fewer than 30 or 40 active tasks.
• One person maintains the timeline.
• Most tasks have simple start and end dates.
• People mainly need a visual overview.
• Updates happen occasionally rather than continuously.

Signs that you need a stronger project workflow

Excel becomes harder to manage when several people edit the plan, tasks depend on one another, or managers need live reporting.

Frequent status meetings can also create version confusion. One person may update dates while another changes task ownership.

Consider a dedicated platform when you need permissions, audit history, automated reminders, workload planning, or connected project information.

The best part? You can start with a simple chart and move to a structured workflow when the project’s coordination needs grow.

Project Scheduling Solution: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform powered by ONES Assistant. ONES Project is its project management product and works as a Jira alternative.

It can replace a manually maintained schedule when your team needs shared planning, reporting, workflow control, and broader project visibility.

Core Capabilities

1. Manual timeline upkeep causes stale plans. ONES Project centralizes tasks, dates, owners, and status updates in shared project spaces. The result is a schedule that reflects team activity more consistently.
2. Basic charts show timing without enough context. ONES Project connects tasks with custom fields, workflows, and project details. The result is a richer view of why work is scheduled.
3. Changing a task can create follow-up work. Automation helps trigger routine actions when status or conditions change. The result is less manual coordination for repeated project events.
4. Different teams follow different approval steps. Custom workflows let you model reviews, approvals, development stages, and release processes. The result is a process that matches the team’s operating style.
5. Sprint planning becomes disconnected from long-term planning. Sprint management connects short delivery cycles with broader project goals. The result is better visibility from planned work to completed work.
6. Leadership needs more than a static visual. Built-in reporting gives teams ways to review progress, trends, and status. The result is faster project conversations with less manual chart preparation.
7. Plugin-heavy environments create maintenance work. ONES Project provides native workflows, fields, reporting, automation, and sprint features. The result is fewer separate add-ons to configure and maintain.
8. Some teams cannot use public cloud services. ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments. The result is more flexibility for restricted or regulated environments.

Application Scenarios

Software delivery: A development team can connect planning, sprint execution, testing, and release approval. Managers can review progress without rebuilding a chart after every sprint.

Hardware development: A product team can track design reviews, prototype work, testing, procurement, and manufacturing readiness. Custom workflows can reflect approval gates between stages.

Restricted-network projects: A team working in an air-gapped environment can use a self-hosted deployment. ONES.com offers feature parity between cloud and self-hosted versions, helping teams retain core functionality.

ONES.com is available separately through ONES Project and ONES Wiki. ONES Wiki supports knowledge management and serves as a Confluence alternative, while ONES Project focuses on project execution.

A free plan supports up to 30 seats. This can make it practical for a small team evaluating a shared project workflow before expanding adoption.

Common Challenges and Practical Solutions

The bars appear in the wrong position

Problem: The start-date values may be stored as text, or the horizontal axis bounds may be too wide.

Solution: Re-enter the dates using a recognized Excel format. Then set the axis minimum close to the earliest start date.

The first task appears at the bottom

Problem: Excel places categories in its default order.

Solution: Open Format Axis and select Categories in reverse order. Review the horizontal axis afterward because Excel may move its position.

The chart shows large numbers instead of dates

Problem: Excel stores dates as serial numbers and may apply a general number format.

Solution: Open the horizontal axis settings and apply a date format such as mmm d.

New tasks do not appear

Problem: The chart’s selected range does not include the newly added rows.

Solution: Use Select Data to expand the range. An Excel table can also help extend the schedule as you add tasks.

The chart becomes crowded

Problem: Too many tasks, long labels, and daily axis marks reduce readability.

Solution: Group minor tasks, shorten labels, increase chart height, or split the plan into phases. Show weekly or monthly labels for longer projects.

FAQs

Does Excel 2016 have a built-in Gantt chart template?

Excel 2016 does not include a dedicated Gantt chart type in the standard chart menu. You can create one with a stacked bar chart, however. Use start dates as the first series and task durations as the second series. Hide the start-date series, reverse the task order, and format the horizontal axis as dates.

What is the easiest way to calculate task duration?

Use an end-date column and subtract the start date. Add one when you want to count both the first and last calendar day: =EndDate-StartDate+1. For Monday-to-Friday schedules, use NETWORKDAYS. Choose one calculation method and apply it consistently across the entire schedule.

Why does my Gantt chart show numbers instead of calendar dates?

Excel stores dates as serial numbers. The chart may display those numbers when the horizontal axis uses a General format. Right-click the axis, choose Format Axis, open the Number section, and select a date format. Formats such as mmm d usually provide a clean timeline.

Can I show weekends differently?

Yes, although Excel 2016 requires additional formatting. You can add a second series, use shaded shapes behind the chart, or apply a working-day duration calculation. For a simple schedule, label the axis clearly and use different colors for working and non-working periods.

Can I show task completion in the chart?

Yes. Add completed duration and remaining duration as separate series in a stacked bar chart. For example, a 10-day task that is 40% complete could use four completed days and six remaining days. This approach adds detail, though it also increases setup and maintenance work.

When should I use project management software instead?

Consider a project platform when several people update the schedule, dependencies change frequently, or you need permissions, automation, reporting, and activity history. Excel remains useful for quick planning. A structured platform becomes more valuable when coordination matters as much as the timeline.

Conclusion

You can build a Gantt chart in Excel 2016 by combining task names, start dates, and durations with a stacked bar chart. The start-date series creates positioning, while the duration series creates the visible schedule.

Start with the seven steps: prepare the schedule, verify dates, insert the chart, hide the first series, reverse task order, format the axis, and test updates.

But here's the truth: a chart only helps when the schedule stays accurate. Check duration formulas, clarify calendar rules, and review dependent tasks after every major change.

For a small plan, Excel may provide exactly the visual overview you need. When the work demands shared workflows, reporting, automation, or controlled deployment, a platform such as ONES.com can provide a more connected way to manage the project.