How to Make an Excel Gantt Chart: Step-by-Step Guide [2026]

Excel can create a useful Gantt chart, yet the setup often feels harder than the project itself. Dates may appear as strange numbers, task bars can shift out of place, and a small schedule change may require several manual fixes.

That becomes frustrating when you need to show progress during a meeting or coordinate several people. A chart that looks almost right can still hide overdue work, overlapping tasks, or an unrealistic deadline.

But here's the truth: you can build a clear Excel Gantt chart with ordinary worksheet features. This guide walks you through the process, explains the formulas, and shows how to keep the schedule readable as your project changes.

How to Make an Excel Gantt Chart Step by Step

An Excel Gantt chart is a horizontal timeline that shows when each task starts, how long it lasts, and when it should finish. Excel does not include a dedicated Gantt chart type, so you create one with a stacked bar chart and carefully formatted dates.

Here is the complete process:

1. Prepare a task list with names, start dates, and durations.
2. Calculate an end date for every task.
3. Create a stacked bar chart from the schedule data.
4. Hide the start-date series so only task bars remain visible.
5. Reverse the task order and format the date axis.
6. Improve the chart with labels, colors, milestones, and progress details.

Step 1: Create the schedule table

Open a new Excel worksheet and create four columns with these headings:

Enter actual Excel dates in the Start Date column. You can type a date such as 1/5/2026, then format the cell as a readable date.

Use calendar days for the simplest chart. If your project operates only on weekdays, calculate working time with NETWORKDAYS and account for weekends separately.

Step 2: Calculate the task duration

Duration controls the visible length of each task bar. If you already know the number of days, enter that number directly.

If you know the start and end dates instead, calculate the duration with this formula:

=D2-B2+1

Here, column B contains the start date and column D contains the end date. The +1 counts both the first and last day.

For example, a task that begins on January 5 and ends on January 9 lasts five calendar days. Without +1, Excel would calculate four days.

Step 3: Select the task, start, and duration columns

For the chart, select the Task, Start Date, and Duration columns. You can hold the Ctrl key while selecting separate ranges if the End Date column sits between the other columns.

In the example above, select the task names, start dates, and durations. Leave End Date out because it helps you manage the schedule but does not need to appear as a chart series.

Step 4: Insert a stacked bar chart

Choose Insert, open the chart options, and select 2-D Bar followed by Stacked Bar.

Excel will initially show two colored sections for every task:

• The first section represents the start date.
• The second section represents the task duration.

The chart may look unusual because Excel stores dates as serial numbers. The start-date section pushes each task bar across the timeline, while the duration section shows the work period.

Step 5: Hide the start-date series

Click one of the sections representing the start dates. Open the formatting options and set the fill to No Fill. Remove its border if Excel displays one.

The start-date series still positions each task correctly. It simply becomes invisible, leaving the duration bars floating at their proper dates.

Choose a clear color for the duration series. Blue works well for planned work, while orange or red can highlight attention items.

Step 6: Reverse the task order

Excel commonly places the first task at the bottom of a horizontal bar chart. To make the chart read naturally, right-click the vertical task axis and choose Format Axis.

Enable Categories in reverse order. The first task will move to the top, and the final task will appear at the bottom.

Excel may also move the horizontal axis to the top of the chart. That is usually helpful because the timeline now reads from the first task downward.

Step 7: Format the date axis

Right-click the horizontal axis and open Format Axis. Adjust the minimum and maximum bounds so the chart starts near your earliest task and ends near your final deadline.

Excel stores dates as serial values, so you may see numbers instead of calendar dates. Change the number format to a date style such as:

• mmm d for Jan 5
• mmm d, yyyy for Jan 5, 2026
• dd-mmm for 05-Jan

Use a short format when the chart covers a few weeks. Use the year when the schedule spans several months.

Step 8: Improve the chart’s readability

Remove the legend if the chart has only one visible series. A clear title such as Product Launch Schedule helps people understand the chart immediately.

You can also adjust the gap width. A smaller gap creates thicker task bars, while a larger gap gives each row more separation.

Keep the chart wide enough for date labels. A narrow chart forces dates together and makes overlapping work harder to see.

Build the Worksheet Before You Build the Chart

A Gantt chart is only as reliable as the schedule behind it. Start with a clean task list and decide what each row represents.

Choose the right level of detail

One row can represent a major phase, a deliverable, or a small activity. Choose a level that helps you make decisions.

For example, “Marketing” is too broad if you need to track design, review, publishing, and promotion separately. Four task rows provide better control.

At the same time, adding every tiny action can make the chart difficult to scan. If a task takes only a few minutes, group it with related work unless it affects a key handoff.

Use consistent date rules

Decide whether your schedule uses calendar days or working days. A five-day duration means something different under each rule.

For a weekday-only schedule, you can calculate an end date with:

=WORKDAY(B2,C2-1)

This formula treats the start date as the first working day. You can also include a holiday range:

=WORKDAY(B2,C2-1,$H$2:$H$10)

Keep holiday dates in a clearly labeled area. This prevents a public holiday from making the schedule look shorter than the actual working period.

Add task relationships when timing depends on other work

Some tasks cannot begin until another task finishes. For example, testing may depend on development reaching a usable state.

You can calculate a dependent start date with:

=D2+1

If the previous task ends in cell D2, the next task begins the following day. For weekday schedules, use:

=WORKDAY(D2,1)

This approach creates a basic dependency chain. It does not replace a full project scheduling system, but it works well for a small plan.

Customize the Gantt Chart for Real Project Work

The basic chart shows planned timing. A few additions can reveal progress, risk, and important deadlines.

Show progress inside each task bar

Add a Progress column with percentages such as 0%, 50%, or 100%. Then calculate completed duration with:

=C2*E2

If column C contains total duration and column E contains progress, the result shows how much work is complete.

You can add completed duration as another stacked series. Format it with a darker color and keep the remaining duration in a lighter color.

For example, a 10-day task at 40% progress displays four days of completed work and six days of remaining work.

Mark milestones with zero-duration tasks

A milestone is an important event, such as approval, release, or inspection. It usually has a date without a meaningful duration.

Excel may not display a zero-length bar clearly. Enter a small value such as 0.2, then format the bar with a contrasting color.

You can also add a separate scatter series for milestone diamonds when precision matters. This requires more chart formatting, so the small-duration method is often better for a simple schedule.

Use colors that communicate meaning

Color should answer a question quickly. For example:

• Blue can represent planned work.
• Green can indicate completed work.
• Orange can flag work that needs attention.
• Red can mark a missed deadline or serious risk.
• Purple can identify milestones or approvals.

Use the same meaning throughout the chart. If orange means delayed work in one area, it should not mean completed work elsewhere.

Add today’s date as a reference line

A vertical line for today helps you compare planned work with the current date. One practical method is to add a Today column containing the current date:

=TODAY()

Create a second duration series that positions a narrow bar at today’s date. Format it with a dark gray color and a small width.

Because TODAY() changes automatically, the reference line moves as time passes. Check the chart after opening the workbook if the schedule is used for weekly reporting.

Common Excel Gantt Chart Problems and Fixes

Most problems come from date formatting, range selection, or chart settings. Here are practical fixes for the issues you are likely to encounter.

The chart shows numbers instead of dates

Excel represents dates with serial numbers internally. Select the horizontal axis, open its formatting options, and apply a date number format.

If the numbers still look wrong, check whether the start dates are real Excel dates. A date that Excel treats as text will not position the bar correctly.

The bars begin at the same point

This usually means Excel did not use the Start Date column as a chart series. Select the chart, open Select Data, and confirm that Start Date and Duration both appear as series.

Also verify that the start-date values are numeric dates. Re-enter one date manually to test whether Excel recognizes it.

The first task appears at the bottom

Reverse the category order through the vertical axis settings. Then check whether Excel moved the horizontal axis to an inconvenient position.

Small layout changes can improve the reading order without changing any schedule values.

The timeline includes too much empty space

Set the horizontal axis minimum close to the earliest start date. Set the maximum close to the latest end date, while leaving enough room for the final bar.

Large gaps often appear when the axis begins at Excel’s default minimum. A custom minimum makes the actual schedule easier to read.

Weekend work makes the schedule misleading

Use WORKDAY and NETWORKDAYS when weekends should not count. Add holidays to the calculation so the duration reflects your team’s actual working calendar.

For example, a task scheduled from Friday through Monday may span four calendar days but only two working days.

When an Excel Gantt Chart Works Well

Excel is a practical choice for a short project with a small team. It gives you flexible formulas, familiar editing tools, and quick control over the visual layout.

A launch plan with 15 tasks is easy to maintain. You can change a start date, adjust a duration, and update the chart without learning a separate platform.

It also works well for a one-time presentation. If a manager needs a simple timeline for a meeting, an Excel chart can communicate the sequence in minutes.

When the approach starts to break down

The chart becomes harder to manage when many people edit it simultaneously or when tasks change several times each day. Manual updates can create conflicting dates and outdated progress indicators.

Complex dependencies create another problem. A change to one activity may require several downstream dates to move. Excel formulas can support some relationships, but they become difficult to audit at scale.

For example, a 120-task engineering plan with multiple teams, approvals, and recurring work may need dependency tracking, permissions, alerts, and activity history.

Excel Gantt Chart Alternative: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform. ONES Project provides project planning, Jira-compatible workflows, reporting, and team coordination when a workbook becomes difficult to maintain.

You can use it as a Jira alternative when you need structured project control, fewer plugins, or deployment options that include on-premise and air-gapped environments.

Core Capabilities

• Repeated manual schedule updates: ONES Project connects tasks, dates, and workflow states so changes are easier to manage. The result is less rework when project timing moves.
• Limited visibility across teams: Built-in reporting gives you dashboards and progress views for delivery status, workload, and risks. Stakeholders can review current conditions without rebuilding a chart.
• Rigid task structures: Custom workflows and custom fields let you adapt work items to your approval, development, or operations process. Each team can capture the details it actually needs.
• Complex sprint planning: Sprint management supports planned work, active work, and completed work in a structured cycle. Teams can compare commitments with actual progress.
• Too many add-ons: Native capabilities reduce dependence on separate plugins for common project activities. Fewer moving parts can simplify administration.
• Jira migration concerns: Jira-compatible workflows help teams preserve familiar ways of planning and tracking work. That makes ONES Project a practical Jira alternative for teams evaluating a change.
• Restricted network requirements: ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments. Full feature parity between cloud and self-hosted versions gives teams more control over where work is hosted.
• Separate knowledge and delivery areas: ONES Wiki provides knowledge management alongside ONES Project. The products are sold separately, so you can choose the capability your team needs.

Application Scenarios

Product development: A product team can plan epics, sprints, testing, and release work in ONES Project. Reports show whether development is keeping pace with the launch target.

Regulated or restricted environments: An engineering organization can use an on-premise or air-gapped deployment when network controls prevent ordinary cloud usage. The team can preserve structured project workflows within its approved environment.

Growing cross-functional teams: Marketing, design, engineering, and support can coordinate shared milestones while keeping role-specific workflows. ONES Wiki can hold supporting guidance when that capability is purchased separately.

Common Challenges and Practical Solutions

Challenge: The chart becomes hard to read

Solution: Reduce unnecessary rows, group minor activities, and use short date formats. Keep the most important tasks visible at the current zoom level.

Challenge: People update dates inconsistently

Solution: Define one calendar rule and protect formula cells. Use data validation for status and progress fields so entries remain consistent.

Challenge: Progress does not match reality

Solution: Agree on what each percentage means. A team might define 50% as half the work completed, while another team uses it for time elapsed.

Challenge: Dependencies are missed

Solution: Add predecessor and successor columns. Review them whenever a major date changes, especially when several teams share the same deadline.

Challenge: The schedule becomes too large for comfortable editing

Solution: Move active planning into a project management platform when you need permissions, automation, dependency logic, reporting, or frequent collaboration.

FAQs

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

Yes. You can create one with a task list, start dates, durations, and a stacked bar chart. Excel uses the hidden start-date series to position each visible duration bar along the timeline. This approach works well for small and medium schedules that do not need advanced dependency management.

How do I show weekends in an Excel Gantt chart?

Use calendar-day durations if weekend work should appear in the schedule. If weekends should be excluded, calculate dates with WORKDAY and durations with NETWORKDAYS. The correct formula depends on whether your project tracks elapsed calendar time or actual working time.

Why are my Excel Gantt bars in the wrong position?

Check three things first: the start dates must be recognized as Excel dates, the Start Date column must be included as a chart series, and the horizontal axis bounds must cover the project period. A date stored as text often causes the biggest positioning problem.

How can I add task progress to the chart?

Add a progress percentage, calculate completed duration by multiplying total duration by progress, and add that value as another stacked series. Use a darker color for completed work and a lighter color for remaining work. This creates a simple progress bar inside each task row.

Is Excel suitable for a large project?

It can work for a stable schedule with limited collaboration. Large or frequently changing projects may need stronger dependency tracking, permissions, reporting, automation, and change history. In that situation, a dedicated project management platform can reduce manual maintenance.

Can I share an Excel Gantt chart with other people?

Yes, you can share it through your organization’s collaboration tools. Before sharing, protect formulas, label editable cells, and explain the calendar rules. If several people need to edit the plan regularly, a shared project platform may provide clearer control over changes.

Conclusion

You can build an effective Excel Gantt chart by combining task names, start dates, durations, and a stacked bar chart. Hide the start-date series, reverse the task order, and format the date axis for a clean timeline.

Keep the schedule useful by choosing the right level of detail, using consistent working-day rules, and adding progress or milestone indicators when they answer a real planning question.

But here's the truth: a manual chart becomes fragile as the project grows. If updates, dependencies, reporting, or collaboration consume more time than planning, consider a structured platform such as ONES Project.

The goal is simple: give everyone a trustworthy view of what needs to happen, when it should happen, and where attention is needed next.