Guide · 2026-08-23

How to Make a Gantt Chart in Excel: 7 Simple Steps (2026)

Creating a Gantt chart in Excel can feel harder than it should. You may have task names, dates, and deadlines, yet still end up with a chart that looks confusing or takes hours to format.

That frustration grows when milestones shift, tasks overlap, or someone asks for a clearer project view. A manually colored calendar rarely stays accurate for long. Small schedule changes can force you to rebuild the entire visual.

But here’s the truth: Excel can create a useful Gantt chart with a stacked bar chart and a few formatting changes. You can finish the basic version in about 15 minutes.

This guide shows you how to make a Gantt chart in Excel using seven simple steps. You’ll also learn how to handle milestones, progress, dependencies, and team collaboration more effectively.

How to Make a Gantt Chart in Excel in 7 Steps

The quickest method uses a stacked bar chart. You create one series for task start dates and another for task durations, then hide the start-date series.

Here’s the complete process:

  1. Plan your project details. List each task, its start date, and its duration.
  2. Build a schedule table. Arrange the information in clear Excel columns.
  3. Insert a stacked bar chart. Use the start date and duration columns.
  4. Reverse the task order. Make the first task appear at the top.
  5. Hide the start-date bars. This creates the familiar Gantt chart appearance.
  6. Format the timeline. Adjust dates, colors, labels, and spacing.
  7. Add progress and milestones. Make the schedule easier to understand and maintain.

Step 1: Plan the tasks and schedule

Start by deciding what the chart needs to show. A simple project may require only task names, start dates, and durations.

For example, a website launch might include research, design, development, testing, and launch preparation.

Task Start date Duration
Research January 5, 2026 5 days
Design January 10, 2026 8 days
Development January 18, 2026 12 days
Testing January 30, 2026 6 days

Keep tasks specific enough to schedule. “Build website” is broad, while “Create homepage layout” gives you a clearer time block.

Step 2: Create the schedule table

Open Excel and create three columns titled Task, Start Date, and Duration.

Enter each task on its own row. Use real Excel dates in the start-date column, such as 1/5/2026, rather than typing dates as plain text.

Enter duration as a number of days. For example, enter 5 for a task that lasts five working days.

Excel stores dates as numbers behind the scenes. That allows the chart to position each bar correctly along the timeline.

Step 3: Insert a stacked bar chart

Select the task, start-date, and duration columns. Then choose Insert, select Bar Chart, and choose Stacked Bar.

Excel will create two horizontal bar series. The first represents the time before each task begins. The second represents the task duration.

At this stage, the chart may look like ordinary stacked bars. That is expected. The hidden-start technique comes next.

Step 4: Put the first task at the top

Excel often displays the first task at the bottom of a bar chart. You can reverse the order in a few clicks.

Right-click the vertical task axis and choose Format Axis. Then enable Categories in reverse order.

The first task should now appear at the top. This matches the way most people read a project schedule.

If the horizontal axis moves to the opposite side, adjust the axis settings until the task labels appear where you want them.

Step 5: Hide the start-date series

Click one of the bars representing start dates. Open the formatting panel and set its fill to No Fill.

You can also remove its border. The duration bars will remain visible, while the hidden bars create empty space before each task begins.

That empty space is what makes the chart look like a traditional Gantt chart.

Do not delete the start-date series. Excel still needs it to position the duration bars correctly.

Step 6: Format the timeline

Now make the chart easier to read. Right-click the horizontal axis and choose Format Axis.

Set the minimum and maximum bounds to match your project period. For example, a January project may begin around January 1 and end around February 15.

Choose a major unit that fits the schedule. Daily units work for short projects, while weekly units usually work better for longer plans.

You can also change the bar color, reduce the gap width, add a chart title, and remove unnecessary gridlines.

Step 7: Add progress and milestones

A basic Gantt chart shows planned timing. You can make it more useful by adding progress information.

Add a Progress column with values such as 0%, 50%, or 100%. Then use a second series or a darker overlay to show completed work.

For milestones, create a separate task with a one-day duration. Use a contrasting color or a diamond-shaped marker.

For example, “Design approved” could appear as a one-day milestone after the design task.

What a Gantt Chart Shows

A Gantt chart is a timeline view of project work. Each horizontal bar represents a task, while its position shows when the task starts and ends.

The chart can also show task duration, overlapping work, milestones, progress, and the overall project window.

The main parts of the chart

Imagine planning a product launch. Research may happen first, design may overlap with research, and testing may begin only after development reaches a certain stage.

A calendar lists those dates. A Gantt chart shows the relationships between them at a glance.

How to Add Dependencies and Milestones

Excel does not provide the same built-in dependency controls as dedicated project management software. Still, you can represent relationships clearly with careful scheduling.

Represent task dependencies

Add a column called Depends On. Enter the task that must finish before the current task begins.

For example, “Testing” may depend on “Development.” If development ends late, you can manually move testing’s start date.

For a more automatic schedule, calculate the next start date with a formula. If a task begins after a previous task ends, use a formula such as:

=Previous_Start_Date+Previous_Duration

When weekends should not count, use Excel’s WORKDAY function. A practical example is:

=WORKDAY(B2,C2)

This calculates a future workday after adding the duration in the selected cell.

Mark important milestones

Milestones represent events rather than extended work. Examples include contract signed, prototype approved, or release published.

Create a milestone row with a one-day duration. Then apply a unique bar color so it stands apart from ordinary tasks.

If you want a diamond symbol, add a separate scatter series. That approach takes more formatting, but it creates a polished executive-style chart.

Show overlapping work

Overlapping bars help you see whether several activities compete for the same period.

Suppose design and content writing overlap for eight days. The chart makes that overlap visible immediately.

That visibility can reveal scheduling pressure before it becomes a missed deadline.

How to Show Progress in an Excel Gantt Chart

To show progress, calculate the completed portion of each task and display it inside the planned duration bar.

Use a progress column

Add two columns called Completed and Remaining. If a task lasts 10 days and is 40% complete, completed time equals four days.

You can calculate remaining time with:

=Duration-Completed

Task Duration Completed Remaining
Development 12 7 5
Testing 6 2 4

Add the completed and remaining columns as stacked series. Use a dark color for completed work and a lighter color for remaining work.

Use percentage completion carefully

Percentage completion can be misleading when a task has hidden complexity. A task marked 80% complete may still need extensive testing.

For example, a software feature may be coded but still lack approval, security checks, and user testing.

Consider tracking completion by deliverable or acceptance point. That gives your chart a more realistic view of progress.

Keep planned and actual dates separate

Add actual start and finish dates if you need to compare the plan with reality.

A planned bar can use one color, while an actual bar uses another. This creates a simple variance view.

If a task finishes five days late, the difference becomes visible without requiring a separate report.

Common Excel Gantt Chart Problems and Fixes

Excel gives you flexibility, but that flexibility can create maintenance problems. Most issues come from date formatting, chart ranges, or manual updates.

The bars start on the wrong dates

Check whether Excel recognizes your dates as dates. Select the cells and change the format to Short Date.

If the values remain aligned to the left or behave like text, re-enter them using a consistent date format.

The tasks appear in the wrong order

Open the vertical axis settings and select Categories in reverse order.

Also check whether your selected range includes the task labels in the correct order.

The chart shows too much empty space

Adjust the minimum and maximum bounds on the horizontal axis. Excel may choose a wider period than your project needs.

For a six-week project, a timeline covering six months wastes space and makes task differences harder to see.

New tasks do not appear

Your chart range may not include newly added rows. Select the chart, open Select Data, and expand the range.

For easier maintenance, convert the schedule range into an Excel table. New rows can then expand the connected range more reliably.

The chart becomes difficult to read

Too many tasks can overwhelm a single view. Group small activities under phases such as Planning, Design, Build, and Launch.

You can also create separate charts for executives, project leads, and individual contributors.

When Excel Is Enough and When You Need More

Excel works well for a small project with one owner, a stable schedule, and limited coordination.

For example, you might use it to plan a two-week event, a personal renovation, or a short marketing campaign.

However, a workbook becomes harder to manage when several people update tasks, priorities change daily, or dependencies grow complex.

Excel works well when A project platform may work better when
The project has fewer than 30 tasks. Many teams need to update work continuously.
One person maintains the schedule. Several roles need different views and permissions.
Dates rarely change. Deadlines, priorities, and dependencies shift frequently.
You need a quick visual summary. You need reporting, automation, and work history.

Here’s why: Excel shows the schedule, but it does not automatically create a shared workflow around every task.

If five people keep separate copies, conflicting updates can appear. A centralized project workspace reduces that coordination burden.

A More Collaborative Gantt Chart Solution: ONES.com

Excel is useful for building a quick timeline. ONES.com is designed for teams that need project management and knowledge management in one connected platform.

ONES.com product screenshot

ONES Project works as a Jira alternative with Gantt views, custom workflows, sprint management, automation, reporting, and flexible fields. ONES Wiki provides a connected knowledge management space and works as a Confluence alternative. The products are sold separately.

Core capabilities

Application scenarios

Product development: A product team can plan research, design, development, testing, and release work. Sprint planning and workflow rules help connect daily execution with the larger timeline.

Regulated environments: A team with restricted network requirements can use a self-hosted deployment. ONES.com offers cloud, on-premise, private cloud, and air-gapped deployments, with full feature parity between cloud and self-hosted versions.

Cross-functional launches: Marketing, engineering, and operations can coordinate launch tasks in one workspace. Reports provide a shared view without asking each team to rebuild its own chart.

ONES.com offers a free plan for up to 30 seats. That can provide a practical starting point for smaller teams evaluating a more structured alternative to manual Excel scheduling.

Common Challenges When Building a Gantt Chart in Excel

Challenge: Your schedule becomes outdated

Solution: Assign one owner to maintain dates, and define when the chart must be reviewed.

A short review every Monday can catch changes before the visual schedule becomes misleading.

Challenge: People confuse duration with effort

Solution: Track duration and estimated work separately.

A task may span five calendar days while requiring only 12 hours of effort. Those measurements answer different planning questions.

Challenge: Dependencies remain unclear

Solution: Add a dependency column and use consistent task names.

For example, connect “Approve wireframes” to “Begin development,” rather than relying on memory.

Challenge: Too many tasks crowd the chart

Solution: Use summary rows for major phases and place detailed activities on a separate view.

This preserves the big picture while keeping execution details available when needed.

Challenge: Progress percentages hide risk

Solution: Add a status field such as On track, At risk, or Blocked.

A task at 70% completion may still threaten the deadline if its remaining work depends on an unavailable specialist.

FAQs About Creating Gantt Charts in Excel

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

Yes. You can create one manually with a stacked bar chart. Build columns for task names, start dates, and durations, then hide the start-date series.

Templates can save formatting time, but manual creation gives you more control over the timeline, colors, labels, and progress indicators.

What Excel chart type should I use?

Use a stacked bar chart, not a stacked column chart. Horizontal bars give task names enough room and make the schedule easier to scan.

The first series represents the start date, while the second represents the duration. Hiding the first series produces the Gantt appearance.

How do I show weekends in an Excel Gantt chart?

You can count calendar days directly, or calculate working days with formulas such as WORKDAY and NETWORKDAYS.

Choose the method that matches your planning needs. A construction schedule may include weekends, while an office project may exclude them.

How do I add a milestone to the chart?

Create a milestone row with a one-day duration and give it a contrasting color. Name it after the event, such as “Design approved” or “Release published.”

For a more polished chart, add a diamond marker through a separate scatter series.

Can Excel automatically update task dates?

Excel can calculate dates with formulas, but it does not manage complex project relationships automatically.

Simple sequential work can use date formulas. Projects with many dependencies, shifting priorities, or several contributors usually need a dedicated project management platform.

How can I make the chart easier to share?

Keep the schedule table beside the chart, use clear color meanings, and add a visible “last updated” date.

For recurring collaboration, consider a shared project workspace. That reduces conflicting versions and makes schedule changes easier to track.

Conclusion

You can make a Gantt chart in Excel by arranging tasks, start dates, and durations, then turning those values into a stacked bar chart.

Hide the start-date series, reverse the task order, format the timeline, and add progress or milestone indicators. Those seven steps create a clear visual schedule quickly.

But here's the truth: a chart is only useful when the schedule stays current. Review dates regularly, clarify dependencies, and avoid packing every minor activity into one view.

For a small, stable project, Excel may be all you need. When collaboration, reporting, automation, and deployment requirements grow, ONES.com can provide a more structured way to manage the work behind the timeline.