How to Make a Gantt Chart in Excel: 7 Easy Steps in 2026

Project schedules often look simple until tasks overlap, deadlines shift, and nobody knows which activity controls the finish date. A plain list of tasks can hide delays until they become expensive.

That frustration grows when you need to explain progress to a manager or coordinate several people. Reading dates across rows takes time, especially when dependencies are unclear.

But here's the solution: you can create a practical Gantt chart in Excel with a task list, start dates, durations, and a stacked bar chart. Follow these seven steps, then refine the view for easier planning and reporting.

How to Create a Gantt Chart in Excel: 7 Steps

A Gantt chart in Excel is a timeline that displays project tasks as horizontal bars across calendar dates. The bar position shows when a task starts, while its length represents how long the task lasts.

Excel does not include a dedicated Gantt chart button in every version. You can build one by combining a stacked bar chart with hidden start-date bars and visible duration bars.

Step 1: Build the project schedule

Open a blank Excel workbook and create three columns:

• Task
• Start Date
• Duration

Enter one activity per row. For example, a website redesign might include research, wireframes, visual design, development, testing, and launch.

Enter duration as a number of calendar days unless you intentionally want to track working days. Consistent units prevent confusing bar lengths later.

Step 2: Check your dates and durations

Make sure Excel recognizes each start date as a date rather than ordinary text. Select a date cell and change its format to a short date if necessary.

Keep durations numeric. For example, enter 10 rather than “ten days.” If a task lasts five working days, decide whether weekends should count before creating the chart.

You can add an end-date column to make planning easier:

• Calendar-day schedule: =B2+C2-1
• Working-day schedule: =WORKDAY(B2,C2-1)

The end date helps you catch mistakes. A task starting January 6 and lasting five calendar days should end January 10.

Step 3: Insert a stacked bar chart

Highlight the Task, Start Date, and Duration columns. Then select Insert, choose Bar Chart, and select Stacked Bar.

Excel will create two series for each task. The first series represents the start date, while the second represents the task duration.

At this stage, the chart may look unusual. That is expected. The start-date series creates the horizontal position, and you will hide it in the next step.

Step 4: Hide the start-date series

Click one of the start-date bars. Open the formatting panel and set its fill to No Fill. Remove its border if Excel leaves one visible.

The duration bars should now appear to float across the timeline. Their positions still rely on the hidden start-date values.

Here's why: a stacked bar chart places the duration segment after the start-date segment. Making the first segment invisible leaves the second segment in the correct calendar position.

Step 5: Reverse the task order

Excel usually places the first task at the bottom of a bar chart. Most project schedules read more naturally from top to bottom, so reverse the category order.

Right-click the vertical task axis and select Format Axis. Turn on Categories in reverse order.

The first activity should now appear at the top. You may also need to move the horizontal axis to the bottom so the dates remain easy to read.

Step 6: Format the timeline

Click the horizontal date axis and adjust the minimum and maximum bounds. Set the minimum close to the earliest project start date and the maximum near the final deadline.

Then reduce the gap width between bars. A gap width between 25% and 50% often creates a readable schedule without making bars look crowded.

Choose a clear color for duration bars. Use one color for ordinary tasks and a contrasting color for milestones or critical activities.

You can also improve readability by:

• Removing unnecessary chart borders
• Adding a descriptive chart title
• Increasing the chart height
• Using a consistent date format
• Showing major weekly or monthly gridlines

Step 7: Add milestones and review the schedule

A milestone usually has no duration. You can represent it with a one-day task, a separate marker, or a diamond-shaped data point added to the chart.

Review every bar against the plan. Look for tasks that overlap incorrectly, gaps between dependent activities, and deadlines that extend beyond the intended launch date.

Change one start date or duration and confirm that the chart updates. If the bars move automatically, your chart is ready for regular planning.

Prepare the Schedule Before Building the Chart

A Gantt chart is only as reliable as the schedule behind it. Before opening the chart tools, define the project outcome, major deliverables, task owners, and expected timing.

Start with broad activities, then divide them into manageable work. For example, “build a mobile app” is too broad for one bar. “Create login screen,” “connect authentication,” and “test password reset” provide more useful visibility.

Choose the right level of detail

Tasks should be specific enough to track but not so small that the chart becomes unreadable. A task lasting one or two hours may belong in a task list rather than the main project timeline.

A marketing campaign might use these levels:

• Campaign planning
• Audience research
• Creative production
• Review and approval
• Campaign launch

If the approval stage repeatedly causes delays, split it into internal review, legal review, revisions, and final sign-off.

Use dependencies to improve accuracy

Ask what must happen before each activity can begin. Development may depend on approved designs, while testing may depend on a completed build.

Without dependencies, two bars may appear to overlap even though the team cannot realistically perform both activities. The chart should reflect how work actually moves.

Make the Timeline Easier to Read

A technically correct chart can still confuse people. Your goal is to help someone understand project status within a few seconds.

Use visual grouping

Group related work under headings such as Planning, Design, Build, Testing, and Launch. You can use different colors sparingly or add section labels beside the chart.

For example, all design tasks might use blue, development tasks green, and testing tasks orange. Keep the palette limited so color continues to communicate meaning.

Show progress without clutter

You can add a Percent Complete column and use a second bar series to show completed work. However, this technique requires more chart formatting and can make a small chart difficult to read.

For a simple status view, add a progress label beside each task. Use values such as 0%, 50%, and 100%, then update them during project reviews.

Match the time scale to the project

Daily labels suit short campaigns, while weekly labels work better for product releases lasting several months. Monthly labels may be enough for annual initiatives.

Suppose your project lasts 14 days. Showing every month would hide useful detail. For a nine-month program, showing every single day would create visual noise.

Improve the Chart When Plans Change

Schedules change constantly. A good chart should make updates quick rather than forcing you to rebuild the visual every time.

Update dates through the schedule

Keep start dates and durations in the schedule area, then let the chart reflect those values. If a design review moves from January 15 to January 19, change the date once.

Avoid manually dragging bars to represent new timing. Manual movement can separate the visual from the actual schedule.

Track the current date

Add a vertical reference line for today’s date when you need regular status reviews. This line shows which work should already be underway and which activities are upcoming.

Excel can create this line with an additional series. For a simpler approach, use a narrow colored shape and reposition it during each review.

Protect the structure

Use clear headings, consistent formats, and a small legend. If several people maintain the schedule, explain which columns they may change.

For example, allow task owners to update duration and progress, while a project lead controls the project start date and milestone definitions.

Excel Gantt Charts Compared With Project Management Platforms

Excel works well for a short, stable project with one coordinator. It becomes harder to manage when several people need updates, comments, approvals, and automatic notifications.

Consider a product launch with 80 activities, six teams, and multiple dependencies. One person may maintain the chart, while everyone else sends updates through messages. That creates delays and duplicate effort.

A dedicated project management platform can connect tasks, owners, discussions, workflows, reports, and knowledge in one workspace. The chart becomes one view of the project rather than the only place where planning happens.

Project Planning Solution: ONES.com

ONES.com brings project management and knowledge management together, with ONES Project for planning work and ONES Wiki for organizing team knowledge. ONES Project can serve as a Jira alternative when an Excel timeline no longer provides enough coordination.

The platform is available in Cloud, On-Premise, Private Cloud, and Air-gapped deployments. You can start with up to 30 seats at no cost, and the self-hosted versions maintain feature parity with the cloud version.

Core Capabilities

• Scattered task tracking → Unified project planning → Keep tasks, owners, statuses, and deadlines connected so you spend less time reconciling separate updates.
• Manual schedule adjustments → Custom workflows and fields → Adapt the process to planning, review, approval, and delivery stages instead of forcing every team into one rigid flow.
• Limited timeline visibility → Sprint management → Organize short delivery cycles and compare planned work with completed work during regular reviews.
• Hidden progress risks → Built-in reporting → Use project reports to spot overdue activities, workload concerns, and changing delivery patterns earlier.
• Repetitive coordination → Automation → Trigger routine actions such as status changes, notifications, or assignments when defined conditions occur.
• Plugin-heavy setup → Native project capabilities → Reduce dependence on multiple add-ons for workflows, fields, sprints, and reporting.
• Restricted hosting requirements → On-Premise, Private Cloud, and Air-gapped deployment options → Run project operations in an environment that matches your security and network requirements.
• Disconnected project knowledge → ONES Wiki → Link planning work with requirements, procedures, decisions, and team guidance in a connected knowledge space.

Application Scenarios

Software release planning: A development team can organize requirements, sprints, testing activities, and release approvals in one workflow. Reporting helps the project lead see whether unfinished work threatens the release date.

Marketing campaign coordination: A campaign team can track copy, design, legal review, channel setup, and launch activities. Custom fields can capture campaign owners, regions, approval status, and launch windows.

Restricted-network project delivery: A team with strict network controls can use an air-gapped deployment while retaining project planning, workflow customization, reporting, and sprint capabilities.

Common Challenges With Excel Gantt Charts

Challenge 1: The chart becomes too wide

Problem: A long project creates hundreds of date columns or an unreadable horizontal axis.

Solution: Choose a weekly or monthly scale, shorten task names, and create separate views for detailed planning and executive reporting.

Challenge 2: Dates appear as numbers

Problem: Excel displays values such as 46000 instead of calendar dates.

Solution: Select the horizontal axis, open its formatting options, and change the number format to a date style. Confirm that the schedule cells also use recognized date values.

Challenge 3: Tasks appear in the wrong order

Problem: The first activity sits at the bottom, making the chart read backward.

Solution: Reverse the category order on the vertical axis. Check the result after every major chart edit because Excel can reset axis settings.

Challenge 4: The visual stops matching reality

Problem: Team members update timing in messages, while the chart remains unchanged.

Solution: Establish one update routine. During a weekly review, each owner confirms status, remaining duration, risks, and the next dependency.

Challenge 5: Too many tasks reduce clarity

Problem: The chart contains so many rows that nobody can see the important work.

Solution: Keep the primary view focused on deliverables and milestones. Put lower-level activities in a separate planning view or connected task system.

FAQs About Making a Gantt Chart in Excel

Can I create 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 time, but manual creation gives you more control over colors, labels, and timeline settings.

Which Excel chart type works for a Gantt chart?

A stacked bar chart is the usual choice. The hidden first series creates the starting position, while the visible second series shows task duration. A regular bar chart cannot position each activity accurately across a calendar timeline without this stacked structure.

Should duration include weekends?

That depends on how your team plans work. Use calendar days when activities continue through weekends. Use working days when the schedule reflects business-day availability. Decide once, then apply the same rule to every task so the timeline remains consistent.

How can I show task dependencies in Excel?

You can add predecessor columns, dependency notes, or connector lines. Excel does not provide the same dependency management experience as a dedicated project platform, so complex relationships can become difficult to maintain. For a small project, clear predecessor labels may be enough.

Can an Excel Gantt chart show progress?

Yes. Add a Percent Complete column and create an additional series for completed duration. You can also use progress labels beside tasks. Keep the design simple, because too many series can make the timeline harder to interpret.

When should I move beyond Excel?

Consider another approach when several people update tasks, deadlines change frequently, dependencies affect delivery, or project history matters. A connected platform can reduce manual coordination by combining assignments, workflows, reporting, discussions, and knowledge management.

Conclusion

You can build a useful Gantt chart in Excel by preparing task data, inserting a stacked bar chart, hiding the start-date series, reversing task order, formatting the timeline, and reviewing the schedule.

Start with a focused project rather than trying to map every minor activity. Use realistic durations, clear dependencies, and a consistent update routine. That prevents the chart from becoming attractive but unreliable.

But here's the truth: Excel is most effective when the schedule is small and relatively stable. As coordination grows, a platform such as ONES.com can connect timelines with workflows, reporting, sprints, automation, and team knowledge.