How to Create a Project Gantt Chart in Excel: 7 Steps (2026)

Project timelines often become confusing when tasks overlap, deadlines move, and nobody knows which activity should happen next. A plain task list can show what needs doing, yet it rarely shows how work flows across weeks. That gap can lead to missed dependencies, idle team members, and rushed delivery.

The good news is that you can build a clear project Gantt chart in Excel without advanced project management experience. You only need a task list, start and finish dates, and a simple timeline. In this guide, I’ll show you seven practical steps, explain the formulas, and help you avoid common formatting mistakes.

How to Create a Project Gantt Chart in Excel

A project Gantt chart in Excel is a timeline that displays tasks as horizontal bars across calendar dates. Each bar shows when a task starts, how long it lasts, and where it sits in the overall schedule.

Here’s why: a well-built chart lets you see task duration, overlapping activities, milestones, and delays in one view. Follow these seven steps to create one.

1. Build your project task table

   Open a blank Excel workbook and create four columns with these headings:

   • Task
   • Start Date
   • End Date
   • Duration

   Enter one activity per row. For example, a website launch might include “Confirm requirements,” “Create wireframes,” “Develop pages,” “Run testing,” and “Launch site.”

   Keep task names short enough to read easily. You can add more detail later through task IDs, owners, priorities, or notes.

2. Enter start and finish dates

   Type the planned start and end date for every task. Use a consistent date format, such as 3/2/2026 or Mar 2, 2026.

   Check that Excel recognizes each entry as a date. Select a date cell and change its format through Home > Number Format > Short Date.

   If Excel treats a date as text, formulas and chart labels may behave unexpectedly. A quick visual check helps: valid dates usually align to the right side of a cell by default.

3. Calculate task duration

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

   =C2-B2+1

   In this example, column B contains the start date and column C contains the end date. The +1 includes both the first and last day.

   For example, a task starting March 2 and ending March 5 lasts four calendar days. Without the extra one, Excel would return three days.

   Copy the formula down the Duration column. If your project uses working days only, use this formula instead:

   =NETWORKDAYS(B2,C2)

   You can also exclude holidays with a holiday range:

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

4. Create a stacked bar chart

   Select the Start Date and Duration columns. Hold Ctrl while selecting both columns if they are separated.

   Then choose Insert > Bar Chart > Stacked Bar. Excel will create two colored sections for each task:

   • The first section represents the time before the task begins.
   • The second section represents the task duration.

   Here’s the key idea: the first section positions the task on the calendar, while the second section becomes the visible task bar.

5. Add task names to the vertical axis

   Your chart may initially show numbers instead of task names. Right-click the chart and choose Select Data.

   Under the category axis labels, select the cells containing your task names. Excel will then connect each horizontal bar to the correct activity.

   Task order may appear upside down. Right-click the vertical axis, choose Format Axis, and select Categories in reverse order if needed.

   This places the first task at the top, which usually matches how people read a project schedule.

6. Hide the positioning series

   The first series currently appears as a colored bar. It only positions each activity on the timeline, so make it invisible.

   Click the first series, open Format Data Series, and select:

   • Fill: No fill
   • Border: No line

   Now only the Duration series remains visible. Your chart should look like a conventional Gantt chart, with each task displayed as a horizontal bar at the correct starting point.

7. Format the timeline and review the schedule

   Improve readability by adjusting the horizontal axis, bar color, chart title, and spacing. Useful changes include:

   • Set the minimum axis value to the project start date.
   • Set the maximum value slightly after the planned finish date.
   • Change the major unit to seven days for a weekly view.
   • Reduce the gap width to make task bars thicker.
   • Use one color for regular tasks and another for milestones.
   • Remove unnecessary chart borders and gridlines.

   Finally, compare the chart with your plan. Look for tasks ending after their dependent activities begin, gaps between related tasks, and activities that consume too much time.

Prepare the Schedule Before Building the Chart

A Gantt chart is only as useful as the schedule behind it. Before opening the chart tool, clarify what the project must deliver and divide the work into manageable activities.

For example, “Build mobile app” is too broad for a useful timeline. Break it into “Confirm user flows,” “Design screens,” “Develop login,” “Develop notifications,” “Test on iOS,” and “Test on Android.” Each activity can then receive its own dates and duration.

Let me explain: smaller tasks make delays visible earlier. If “Develop login” slips by three days, you can see which later activities may need adjustment.

Separate tasks, milestones, and phases

Tasks require time. Milestones mark important events, such as approval, release, or completion. Phases group related activities, such as planning, design, development, and testing.

You can represent a milestone with a one-day duration or a separate marker. For example, “Design approved” may use one date and a contrasting color.

Identify dependencies

A dependency explains why one activity must wait for another. Development may depend on approved designs, while testing may depend on a completed build.

Add a Predecessor column if your schedule contains many relationships. A simple value such as “Task 3” can remind you which activity must finish first.

Make the Excel Timeline Easier to Read

A crowded chart can hide the information you need. The best design shows task timing quickly, without excessive color or decoration.

Use a weekly view for projects lasting several weeks. Use a daily view when you are coordinating a launch, event, migration, or short delivery cycle.

Use color with a clear purpose

Choose colors that communicate meaning. For example:

• Blue for planned work
• Green for completed work
• Orange for work at risk
• Red for delayed work
• Gray for milestones or waiting periods

Keep the palette limited. If every task has a different color, the reader must decode the chart before understanding the schedule.

Show progress when needed

You can add a Progress column with values such as 0%, 50%, or 100%. Then create a second duration series to show completed work inside each task bar.

For example, a 10-day activity at 50% completion would show five days of progress. This approach requires extra formatting, yet it gives stakeholders a quick status view.

Use Formulas to Keep Dates Accurate

Manual duration calculations create avoidable mistakes. Formulas help Excel update the timeline when you change a start or finish date.

For calendar days, use:

=EndDate-StartDate+1

For working days, use:

=NETWORKDAYS(StartDate,EndDate)

For a finish date calculated from a start date and working duration, use:

=WORKDAY(StartDate,Duration-1)

You can also calculate a planned finish date from a predecessor. Suppose Task 4 starts one working day after Task 3 finishes:

=WORKDAY(Task3EndDate,1)

These formulas reduce repetitive typing. They also make schedule changes easier to manage when a deadline moves.

Account for weekends and holidays

Calendar duration and working duration produce different results. A task running from Friday through Monday takes four calendar days, yet it covers two typical working days.

Keep a holiday list in a separate area of the workbook and reference it in NETWORKDAYS or WORKDAY. This produces a more realistic schedule for teams that pause on public holidays.

Manage Dependencies, Milestones, and Changes

A static timeline can become outdated quickly when project conditions change. Review the schedule after major decisions, approvals, or scope adjustments.

For example, if a client approval moves from April 8 to April 12, update dependent activities immediately. Otherwise, your chart may show work starting before the required approval exists.

Track common dependency types

The most common relationship is finish-to-start: one activity finishes before another begins. Some projects also use start-to-start or finish-to-finish relationships.

For instance, proofreading may begin while writing continues. A simple bar chart can display the overlap, while a separate dependency column explains why the overlap is intentional.

Mark the critical path

The critical path contains activities that directly influence the final completion date. If one critical activity slips, the entire project may slip unless you recover time elsewhere.

Highlight these activities with a distinct color. A small example might include requirements approval, development, integration testing, and launch preparation.

Excel Gantt Chart Limitations and Practical Workarounds

Excel works well for a small project with a stable schedule. It becomes harder to manage when many people edit tasks, dependencies change frequently, or several projects share the same resources.

For example, a 15-task marketing campaign may remain simple. A 200-task product launch with multiple teams can become difficult to maintain through manual formatting.

Common limitations

• Dependency relationships are often maintained manually.
• Progress updates may require repeated chart adjustments.
• Multiple editors can create inconsistent formatting.
• Resource conflicts are difficult to see in one chart.
• Version history may be limited by how the workbook is shared.

When Excel remains a good choice

Excel is a practical option when you need a quick planning view, a printable timeline, or a lightweight schedule for a small team.

It also works well during early planning. You can test task order and duration before moving the project into a dedicated platform.

A More Connected Project Planning Solution: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform, with AI support through ONES Assistant. ONES Project is a Jira alternative for teams that need structured planning beyond a manually maintained Excel chart.

ONES Project and ONES Wiki are sold separately. You can choose the project management or knowledge management capability that matches your team’s needs.

Core Capabilities

• Scattered task planning → Structured project workspaces → Organize tasks, milestones, owners, and schedules in a shared project environment.
• Manual dependency tracking → Jira-compatible workflows → Connect work stages and approval paths so progress follows a defined process.
• Limited chart visibility → Built-in reporting → Review project status, delivery trends, and progress without rebuilding charts by hand.
• Repeated custom formatting → Custom workflows and fields → Adapt task stages, metadata, and project rules to your team’s process.
• Separate sprint planning → Sprint management → Plan iterations, assign work, and review unfinished activities in a more connected workflow.
• Repetitive updates → Automation → Trigger routine actions when tasks change status, reach deadlines, or require approval.
• Plugin-heavy project setups → Native feature parity → Access core planning capabilities without depending on a large collection of add-ons.
• Restricted deployment requirements → On-premise, private cloud, and air-gapped options → Choose among Cloud, On-Premise, Private Cloud, and Air-gapped deployments.
• Uncertain migration expectations → Full feature parity between cloud and self-hosted versions → Maintain consistent capabilities across deployment models.
• Costly initial adoption → Free plan for up to 30 seats → Start with a small team and assess the workflow before expanding.

Application Scenarios

Product development: A software team can connect requirements, design tasks, development work, testing, and release approval. Sprint management and automation help reduce manual status updates.

Operations planning: An operations team can coordinate maintenance, inspections, approvals, and handoffs. Custom fields can capture location, priority, risk, or responsible department.

Security-sensitive environments: A team operating in a restricted network can use an air-gapped deployment. This supports controlled project coordination where cloud access is unsuitable.

The best part? You can begin with a simple timeline mindset and gradually move toward connected workflows as project complexity increases.

Common Challenges When Building a Gantt Chart

Challenge: Dates are treated as text

Problem: The chart places tasks incorrectly or refuses to calculate duration.

Solution: Reformat the cells as dates, re-enter one date manually, and test the subtraction formula. Avoid adding spaces before or after date values.

Challenge: The bars appear in the wrong order

Problem: The first task appears at the bottom of the chart.

Solution: Open the vertical axis settings and enable Categories in reverse order. Check the horizontal axis afterward because Excel may reposition it.

Challenge: The timeline shows too much empty space

Problem: The chart begins long before the first task or ends far beyond the final deadline.

Solution: Set suitable minimum and maximum values for the horizontal axis. Use the project start and finish dates as your first reference points.

Challenge: Weekends distort the schedule

Problem: A task appears longer than the number of working days your team expects.

Solution: Decide whether the plan uses calendar days or working days. Apply NETWORKDAYS and WORKDAY when weekends and holidays should be excluded.

Challenge: The chart becomes difficult to maintain

Problem: Frequent changes require repeated formatting and manual coordination.

Solution: Keep the workbook structured with consistent columns, formulas, and naming. Consider a dedicated project platform when dependencies, approvals, reporting, and multiple teams become central to the work.

FAQs

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

Yes. You can create one with a task table containing names, start dates, end dates, and durations. Insert a stacked bar chart, use start dates as the hidden positioning series, and use durations as the visible bars. A template can save time, yet building the chart yourself helps you understand how the timeline works.

What formula calculates task duration in Excel?

For calendar days, subtract the start date from the end date and add one: =EndDate-StartDate+1. For working days, use =NETWORKDAYS(StartDate,EndDate). Add a holiday range if public holidays should be excluded. Choose one method and apply it consistently across the project.

How do I show project progress on the chart?

Add a Progress column with percentages, then create a second duration series that represents completed work. Format the planned duration with a lighter color and completed duration with a darker color. This creates a progress overlay, although it requires more chart setup than a basic timeline.

How can I show milestones?

Give each milestone a one-day duration and use a contrasting color. You can also add a marker series if you need diamond-shaped milestone symbols. Label milestones with meaningful events, such as “Contract approved” or “Release accepted,” rather than generic names.

When should I use a project management platform instead of Excel?

Consider another approach when many people update the schedule, task dependencies change often, or you need built-in reporting and automation. Excel remains useful for small, stable plans. A project platform becomes more practical when coordination matters as much as the timeline itself.

Conclusion

You can create a useful project Gantt chart in Excel by organizing tasks, entering reliable dates, calculating duration, inserting a stacked bar chart, hiding the positioning series, and refining the timeline.

Start with a small example, such as a five-task website launch. Then test a date change and confirm that every dependent activity still makes sense. This simple review catches many schedule problems early.

Remember the bigger lesson: a chart can reveal timing problems, yet your project process determines how quickly you solve them. Excel is effective for lightweight planning, while ONES.com can support connected workflows, reporting, automation, and controlled deployment as your projects grow.