How to Create a Gantt Chart in Excel: A 7-Step Project Plan

Project plans often look simple until deadlines shift, tasks overlap, and nobody knows which milestone is at risk. A basic task list can show what needs doing, but it rarely shows how work flows across time. That makes delays harder to spot and progress harder to explain.

But here's the truth: you can build a useful project plan Gantt chart in Excel without advanced project management software. You need task names, start dates, durations, and a stacked bar chart. The right setup turns a plain worksheet into a clear timeline.

In this guide, I’ll walk you through seven practical steps. You’ll learn how to prepare your project details, create the chart, format it, and keep it useful as the work changes.

How to Create a Project Plan Gantt Chart in Excel

An Excel Gantt chart is a horizontal timeline that shows project tasks, start dates, durations, dependencies, and progress. Excel does not offer a dedicated Gantt chart type, so you create one by customizing a stacked bar chart.

Here’s the process at a glance:

1. List your project tasks.
2. Add start dates, end dates, and durations.
3. Build a stacked bar chart.
4. Hide the start-date series.
5. Reverse the task order.
6. Format the timeline and task bars.
7. Add progress, milestones, and updates.

Step 1: List the Project Tasks

Start with the work your team must complete. Put one task on each row, and arrange tasks in the order they should appear.

For example, a website launch plan might include:

• Confirm project scope
• Create page structure
• Write page content
• Design page layouts
• Build the website
• Run quality checks
• Launch the website

Keep each task specific enough to track. “Build website” may be too broad for a small team. “Create homepage layout” gives you a clearer responsibility and finish point.

Step 2: Add Dates and Duration

Create columns for the task name, start date, end date, and duration. A simple layout might look like this:

In the duration column, subtract the start date from the end date and add one day:

=C2-B2+1

In this example, column B contains the start date and column C contains the end date. The formula counts both the starting and ending day.

For working days only, use:

=NETWORKDAYS(B2,C2)

This excludes weekends. You can also add a holiday range when your project calendar includes public holidays.

Step 3: Insert a Stacked Bar Chart

Select the task names, start dates, and duration values. Then choose Insert, select Bar Chart, and choose Stacked Bar.

Excel creates two colored sections for each task. The first section represents the time before the task begins. The second section represents the task duration.

At this point, the chart may look unusual. That is expected. The next steps turn it into a recognizable Gantt chart.

Step 4: Hide the Start-Date Series

Click one of the first colored sections in the chart. These sections represent the start dates.

Open the formatting panel, choose Fill, and select No fill. Then choose Border or Line and select No line.

The start-date series becomes invisible, while the duration series remains visible. The remaining bars now appear to begin on their actual start dates.

Let me explain: the invisible series still positions each task correctly on the timeline. It simply stops competing visually with the task bar.

Step 5: Reverse the Task Order

Excel commonly places the first task at the bottom of a horizontal bar chart. Most project plans read more naturally when the first task appears at the top.

To change the order, right-click the vertical task axis and choose Format Axis. Enable Categories in reverse order.

The first task moves to the top, and the final task moves to the bottom. You may need to adjust the horizontal axis afterward so the dates remain easy to read.

Step 6: Format the Timeline and Task Bars

Formatting helps people understand the project quickly. Keep the design restrained so important dates remain visible.

• Use one strong color for active task bars.
• Choose a light background for the chart area.
• Reduce unnecessary chart borders.
• Show weekly or monthly date intervals.
• Use a readable font size for task names.
• Increase the gap width if the bars look too thick.

To control the timeline, right-click the horizontal axis and adjust the minimum and maximum bounds. You can also change the major unit from days to weeks or months.

For a two-month project, weekly intervals usually work well. For a year-long plan, monthly intervals provide a cleaner view.

Step 7: Add Progress and Milestones

A schedule shows when work should happen. Progress indicators show whether work is actually moving.

You can add a progress column using a percentage value, such as 25%, 50%, or 100%. Then use a second bar series to show completed work inside each task.

For a simpler method, add progress labels beside task names:

• Confirm project scope — Complete
• Create page structure — In progress
• Write page content — Not started

Milestones work differently because they usually represent a single date rather than a duration. Examples include approval received, testing complete, or launch day.

You can show milestones with diamond-shaped markers, data labels, or a separate milestone series. Keep them visually distinct from normal task bars.

Prepare the Planning Information Before Building the Chart

A Gantt chart is only as useful as the schedule behind it. If task names are vague or dates are guesses, a polished chart can still mislead your team.

Start by identifying the project outcome. Then divide the work into deliverables, activities, and milestones. For example, a product launch may include research, design, development, testing, training, and release preparation.

Here's why: each task needs a clear start condition and finish condition. “Review design” becomes easier to schedule when you define it as “Approve final mobile and desktop layouts.”

Choose the Right Level of Detail

Too little detail hides risks. Too much detail makes the chart difficult to maintain.

For a two-week marketing campaign, tasks such as “write headline,” “create graphics,” and “schedule email” may be appropriate. You probably do not need a separate row for every small editing action.

A useful task often takes between one day and two weeks. Longer tasks may need to be divided because delays can remain hidden for too long.

Identify Dependencies

Dependencies show which tasks rely on earlier work. A design review may depend on completed page layouts. Testing may depend on a working build.

Write these relationships beside your planning information before building the chart. You can add a predecessor column, such as:

Excel does not manage dependencies as deeply as dedicated project software. Still, recording them helps you update dates consistently.

Make the Chart Easier to Read and Maintain

A useful Gantt chart should answer three questions quickly: what is happening, when it happens, and whether the work is on track.

Use consistent colors for task categories. For example, blue can represent planning, purple can represent design, and green can represent completed work.

The best part? A small legend can prevent confusion when several people update the plan.

Use Formulas for Automatic Dates

Manual date changes create errors when a task moves. Formulas can reduce repetitive updates.

For example, if a task starts after its predecessor finishes, you might use:

=C2+1

This sets the next start date to the previous end date plus one day. If you need working days, use:

=WORKDAY(C2,1)

These formulas help maintain a sequence when the project schedule changes. Test them carefully when weekends or holidays affect timing.

Add a Today Marker

A today marker shows where the project stands right now. You can add a vertical line using a separate chart series and the current date.

For a simpler approach, add a visible note above the chart that says “Today: April 12.” Update it during each review meeting.

This small detail makes the timeline more useful during status conversations. People can compare the current date with planned task bars immediately.

Compare Excel With Dedicated Project Planning Tools

Excel works well for small projects, short schedules, and teams that need a familiar starting point. It is flexible, inexpensive, and easy to customize.

However, manual maintenance becomes difficult when several people need to update tasks, comments, dependencies, and progress simultaneously.

You might be wondering: when should you move beyond Excel?

Consider another approach when your team manages several active projects, needs permission controls, or spends more time maintaining schedules than completing work.

Excel remains useful for early planning. A dedicated platform becomes more valuable when the schedule must connect with workload, approvals, discussions, and progress reporting.

Use a Repeatable Review Routine

Creating the chart is only the beginning. A schedule becomes reliable through regular review.

Set a weekly planning session. Ask each task owner to confirm progress, expected completion, blockers, and changes to upcoming work.

For example, a team might discover that content approval will take three days longer than planned. Update the approval task first, then review every dependent task.

A Practical Weekly Review

• Mark completed tasks.
• Update active task durations.
• Move delayed tasks to realistic dates.
• Check milestones for potential risk.
• Review tasks scheduled for the next two weeks.
• Record decisions and ownership changes.

Do not change dates simply to make the chart look healthy. Accurate delays help you make better decisions while recovery options remain available.

Track Baseline and Current Dates

A baseline records the original plan. Current dates show the latest expectation.

Keeping both lets you see whether the project is early, on schedule, or late. You can add baseline bars in a lighter color beneath current task bars.

This comparison is especially helpful when stakeholders ask why the launch date changed. The chart can show the original commitment and the revised forecast together.

Project Planning Solution: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform. ONES Project supports structured planning when an Excel timeline no longer handles collaboration, reporting, and changing dependencies comfortably.

It is available through Cloud, On-Premise, Private Cloud, and Air-gapped deployments. The self-hosted versions provide feature parity with the cloud version.

Core Capabilities

• Manual schedule maintenance: Updating many Excel rows can become repetitive. ONES capability: Jira-compatible workflows and structured task management keep project work organized. Result: Teams can manage familiar processes without rebuilding every workflow manually.
• Unclear ownership: A bar chart may show timing without showing responsibility clearly. ONES capability: Assignable tasks, fields, and workflow stages connect work with ownership. Result: Each task has a clearer person or team responsible for moving it forward.
• Changing project processes: Different teams often need different statuses and approval steps. ONES capability: Custom workflows and custom fields support varied operating models. Result: Your project plan can reflect the way your team actually works.
• Limited sprint visibility: A static Gantt chart does not always show short delivery cycles well. ONES capability: Sprint management supports iterative planning and delivery. Result: Teams can connect longer schedules with near-term execution.
• Repetitive coordination: Reassigning tasks or reminding people manually can slow progress. ONES capability: Automation handles repeatable actions inside workflows. Result: Teams spend less effort on routine coordination.
• Scattered progress reporting: Separate charts can make portfolio review difficult. ONES capability: Built-in reporting brings project progress into a shared view. Result: Project leads can review status without rebuilding reports each week.
• Plugin dependence: Adding many extensions can increase maintenance and inconsistency. ONES capability: Core project management functions are available natively. Result: Teams may reduce the number of separate plugins needed for everyday planning.
• Deployment restrictions: Some organizations cannot place project information in a public cloud. ONES capability: On-Premise, Private Cloud, and Air-gapped deployment options support restricted environments. Result: Teams can choose an operating model that matches internal requirements.

Application Scenarios

Software release planning: A development team can connect epics, tasks, sprints, testing, and release milestones. Project leads gain a broader view than a manually maintained Excel timeline.

Construction or engineering coordination: Teams can define approval stages, assign work, and track dependencies across multiple contributors. Custom fields can capture locations, work packages, or review status.

Restricted-network project management: An organization with strict network controls can use an air-gapped deployment. This supports project coordination without requiring a public-cloud setup.

ONES Project is sold separately from ONES Wiki. ONES Wiki supports knowledge management, while ONES Project focuses on project management. Together, they can connect planning with team knowledge when both capabilities are needed.

Common Challenges When Building an Excel Gantt Chart

Challenge: Dates Display as Numbers

Problem: Excel may show dates as serial numbers or use an unexpected date format.

Solution: Select the date cells, open the number-format controls, and choose a date format. Then format the chart axis separately if needed.

Challenge: Tasks Appear in the Wrong Order

Problem: The first task appears at the bottom, making the plan harder to follow.

Solution: Format the vertical axis and enable the reverse category option. Check that the task labels still align with the correct bars.

Challenge: The Timeline Is Too Crowded

Problem: Daily labels overlap across a long project.

Solution: Change the major axis unit to weeks or months. You can also widen the chart and reduce unnecessary labels.

Challenge: Progress Is Difficult to See

Problem: Planned duration and completed work appear as one indistinct bar.

Solution: Add a separate progress series or use a second color for completed portions. Include a small legend so the meaning stays clear.

Challenge: Updates Break the Chart

Problem: New tasks fall outside the chart range, or formulas fail after rows change.

Solution: Convert the planning range into an Excel table before creating the chart. Review formulas and chart references whenever you add new rows.

FAQs About Excel Gantt Charts

Can I create 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 does not need a special template for the basic method. After inserting the chart, hide the start-date series and reverse the task order. Templates can save setup time, but building the chart yourself makes customization easier.

What columns should a project plan Gantt chart include?

At minimum, include task name, start date, end date, and duration. For better planning, add owner, status, predecessor, milestone, and progress percentage. A larger project may also need priority, team, risk, and notes. Keep the visible chart simple, while storing extra planning details beside it.

How do I show weekends in an Excel project timeline?

If your team works weekends, calculate duration with regular date subtraction. If weekends are excluded, use the NETWORKDAYS function. You can also shade weekend columns through conditional formatting. This makes non-working periods visible and helps explain why a task spans more calendar days than working days.

How can I show task dependencies in Excel?

Add a predecessor column that identifies the task each activity depends on. You can also draw connector lines between bars, although those lines require manual maintenance. For a small plan, a predecessor column may be enough. If dependencies change frequently, dedicated project software usually reduces the amount of manual updating.

Can Excel track project progress?

Yes. Add a progress percentage and create a second bar series for completed work. Another option is to use status labels such as Not started, In progress, Blocked, and Complete. Excel can show progress clearly for small projects, but large teams may need shared updates, activity history, and built-in reporting.

Conclusion

A practical Excel Gantt chart needs four essentials: clear tasks, reliable dates, calculated durations, and a readable stacked bar chart. The seven-step method gives you a useful timeline without requiring specialist software.

But here's the truth: the chart only helps when you keep it current. Review it regularly, update delays honestly, and connect dependent tasks when plans change.

For a small project, Excel may be all you need. As collaboration, reporting, workflows, and deployment requirements grow, ONES.com and ONES Project offer a more structured way to manage the work behind the timeline.