How to Make a Gantt Chart in Excel: A 10-Step Guide [2026]

Project deadlines can feel clear in your head and confusing on the page. A plain task list may show what needs doing, yet it rarely shows timing, overlap, or the work blocking your next milestone.

That confusion grows when several people handle related tasks. You may miss a dependency, underestimate a long activity, or discover that two critical tasks compete for the same week.

But here's the truth: Excel can turn a simple task list into a practical Gantt chart. You only need task names, start dates, durations, and a stacked bar chart. The steps below show exactly how to build, format, update, and share one in 2026.

How to Make a Gantt Chart in Excel: 10 Steps

A Gantt chart in Excel uses a stacked bar chart with two series: an invisible start-date series and a visible duration series. The invisible series pushes each task to its correct position on the timeline.

Here's why: Excel does not offer a dedicated Gantt chart button in every version. You can still create the same visual by arranging the right columns and formatting the chart carefully.

1. Define the project scope and time unit

Start by deciding what the chart should explain. A product launch may need weekly planning, while a two-day workshop may need daily planning.

Choose one practical time unit before building the chart:

• Use days for short projects with frequent handoffs.
• Use weeks for product releases, campaigns, and construction plans.
• Use months for annual programs or high-level roadmaps.

For example, a website redesign may include research, wireframes, visual design, development, testing, and launch. Each phase should have a clear beginning and estimated length.

2. Create the task planning table

Open Excel and create three essential columns. Add a fourth column if you want to show ownership or progress later.

Keep each task on its own row. Use specific names such as “Approve mobile wireframes” instead of vague labels such as “Design.”

3. Enter realistic dates and durations

Enter actual calendar dates in the Start Date column. Excel recognizes a valid date when you use formats such as 1/12/2026 or 12-Jan-2026.

Enter duration as a whole number. If a task runs for five working days, type 5. If the plan includes weekends, decide whether those days count before entering the estimate.

Here is a small example:

Check the sequence before creating the chart. A chart reflects your dates, including mistakes.

4. Select the start-date and duration columns

Highlight the Start Date and Duration columns, including their headings. Leave the Task column unselected for this first chart step.

For example, if Start Date is in column B and Duration is in column C, select the range from B1 through C5.

The chart needs the start dates first. Duration comes second because Excel will stack the visible work segment after the invisible opening segment.

5. Insert a stacked bar chart

Go to the Insert tab, open the bar chart options, and select 2-D Stacked Bar.

Choose a horizontal bar chart rather than a column chart. Horizontal bars make task names easier to read and leave room for a longer timeline.

Excel will initially show two colored sections for every task. One section represents the start date, while the other represents the task duration.

At this stage, the chart may look more like a regular bar chart. Let me explain: the key transformation happens when you hide the start-date series.

6. Add task names to the vertical axis

Right-click the chart and choose Select Data. Under the category labels, select the Task column.

Excel should now display your task names along the vertical axis. If the labels appear in the wrong order, reverse them:

1. Right-click the vertical axis.
2. Select Format Axis.
3. Open Axis Options.
4. Enable Categories in reverse order.

This setting places the first task at the top, which matches how most project plans are read.

7. Hide the start-date series

Click the start-date section of any bar. Excel should select the entire start-date series.

Right-click that series, choose Format Data Series, and set:

• Fill to No fill.
• Border to No line.

The duration bars will now appear to begin on their actual start dates. You have created the central Gantt effect.

The best part? You can change a date or duration in the planning table, and the chart will update automatically.

8. Format the horizontal date axis

The horizontal axis may show large serial numbers or an unhelpful range. Format it so the timeline is easy to scan.

Right-click the horizontal axis and choose Format Axis. Adjust these settings:

• Set the minimum bound near the earliest project start date.
• Set the maximum bound near the planned finish date.
• Choose a major unit that matches your planning rhythm.
• Use a date number format such as mmm d or mmm-yy.

For a six-week project, weekly tick marks may work well. For a twelve-month plan, monthly labels usually create a cleaner view.

Avoid showing every single date when the chart covers a long period. Too many labels make the timeline harder to read.

9. Improve colors, spacing, and labels

Use one primary color for active work. Add a second color for milestones, approvals, or high-risk activities.

To make bars easier to distinguish, reduce the gap width in Format Data Series. A setting between 30% and 60% often gives tasks enough visual weight.

Keep formatting functional:

• Use a clear chart title.
• Remove the legend if the hidden series is no longer visible.
• Use a light gridline style for date alignment.
• Increase chart height when task names feel crowded.
• Keep text large enough for screen sharing.

Use labels only when they add meaning. A duration label can help during reviews, while labels on every bar may create clutter.

10. Add progress, milestones, and a review routine

A basic Gantt chart shows planned timing. You can extend it with progress and milestone indicators.

Add a Progress column with percentages such as 0%, 50%, or 100%. You can then use a second bar series or conditional formatting to show completion.

For milestones, enter a one-day duration and use a contrasting color. Examples include:

• Contract approved.
• Prototype accepted.
• Testing completed.
• Release deployed.

Review the chart at a fixed rhythm. A weekly review can compare planned dates with current expectations, identify delayed work, and move dependent activities.

How the Excel Gantt Chart Works

Excel creates this visual with a simple calculation. The first series establishes horizontal space before each task, while the second series displays the active period.

Imagine a task starting on January 20. Excel treats that date as a numeric value. The invisible bar stretches across the timeline until January 20, and the visible bar continues for the task duration.

The two-series method

The method has two parts:

• Start date: Positions the task on the timeline.
• Duration: Shows how long the task remains active.

When the start-date series becomes transparent, only the duration segment remains visible. That creates the familiar Gantt layout without a specialized chart type.

Why date formatting matters

Excel stores dates as numbers. That behavior makes chart positioning possible, yet it can produce confusing axis labels.

For example, Excel may show a value such as 46034 instead of a calendar date. Applying a date format changes the appearance without changing the underlying value.

If the chart starts far before your first task, adjust the minimum axis bound. This removes unused space and gives the active project area more room.

Working days versus calendar days

Duration estimates can count every day or only business days. The choice affects finish dates, dependencies, and milestone timing.

For a five-day task beginning Friday, calendar-day planning ends Tuesday. Business-day planning ends the following Thursday when weekends are excluded.

If your project depends on working days, calculate the finish date with a formula such as:

=WORKDAY(StartDate,Duration-1)

That formula helps you estimate a finish date while excluding weekends. You can also add a holiday range when public holidays affect the schedule.

How to Add Dependencies and Milestones

A Gantt chart becomes more useful when it shows relationships between tasks. A dependency explains why one activity cannot start until another reaches a certain point.

For example, development may begin after design approval. If approval moves three days later, development should move with it.

Use predecessor notes for simple plans

Add a Predecessor column when the project has several handoffs. Enter the task that must finish first.

This approach does not automatically move every dependent task. It gives you a visible reminder to review related dates when a task changes.

Show milestones clearly

A milestone marks an important point rather than a period of work. Give it a one-day duration and use a distinct color.

Examples include “Security review passed” or “Customer sign-off received.” Keep milestone names short so they remain readable beside the timeline.

Highlight the current date

A vertical line for today can make a review faster. You can add a helper series with today’s date and format it as a narrow line.

This helps you answer a practical question: which activities should already be complete, and which should be active now?

How to Update and Share the Plan Safely

A Gantt chart stays useful only when the planning table remains current. Set a review habit before the first task begins.

During each review, compare completed work with planned timing. Record the reason for major changes, such as approval delays, staffing changes, or technical rework.

Use a weekly review checklist

• Mark finished tasks as complete.
• Update active task durations when estimates change.
• Move dependent tasks after a major delay.
• Check whether milestones still have realistic dates.
• Confirm that each active task has an owner.
• Look for overlapping work that needs the same person.

A ten-minute review can prevent a misleading plan from guiding the next two weeks.

Keep views simple for different audiences

Project teams may need task owners, dependencies, and detailed timing. Executives may only need milestones, major phases, and the expected finish date.

Create a clean presentation view by hiding helper columns and reducing visual clutter. Keep the planning details available for the people responsible for updates.

Protect the chart structure

Accidental edits can break chart references. Use cell protection when several people review the plan, and leave only the intended planning cells editable.

Keep a copy of the original chart structure before making major formatting changes. This gives you a recovery point if a series disappears or labels become disconnected.

When Excel Stops Being the Right Fit

Excel works well for a small project with one planning owner. It becomes harder to manage when several people update tasks, comments, dependencies, and reports at the same time.

Consider a product launch with 150 activities, eight teams, and weekly scope changes. A manually maintained chart may show dates clearly while hiding the conversations and decisions behind those dates.

Signs your planning process has outgrown a workbook

• Several versions circulate through email or chat.
• People cannot tell which plan is current.
• Dependency changes require repeated manual edits.
• Status updates live in separate places.
• Teams need permission controls and an activity history.
• Leadership needs dashboards without manual chart preparation.

In that situation, a project management platform can connect tasks, owners, workflows, reporting, and knowledge in one workspace.

Excel remains useful for quick planning and personal analysis. A dedicated platform becomes more practical when coordination matters as much as the timeline.

Project Planning Solution: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform. ONES Project provides project planning capabilities for teams seeking a Jira alternative, while ONES Wiki supports knowledge management separately.

You can buy ONES Project and ONES Wiki separately. The platform supports cloud, on-premise, private cloud, and air-gapped deployments, with full feature parity between cloud and self-hosted versions.

Core Capabilities

• Scattered task updates → Unified project workspace → Keep tasks, owners, dates, and status in one place so progress reviews require less manual coordination.
• Complex approval paths → Custom workflows → Build steps for review, approval, rework, and completion so tasks follow a clear process.
• Limited planning detail → Custom fields → Add information such as release train, risk level, customer segment, or compliance status.
• Manual sprint planning → Sprint management → Organize backlog work into sprints and review planned work against completed work.
• Repeated administrative actions → Automation → Trigger routine actions when a task changes status, reaches a deadline, or meets a defined condition.
• Separate progress reports → Built-in reporting → Use project reporting to review workload, completion trends, and delivery progress without rebuilding every view manually.
• Plugin-heavy Jira setup → Jira-compatible workflows → Support familiar project processes while reducing the need for multiple add-ons.
• Restricted network requirements → Self-hosted deployment options → Run the platform on-premise, in a private cloud, or in an air-gapped environment when operational requirements demand it.

ONES.com offers a free plan for up to 30 seats. That can suit a small team testing a shared planning process before expanding its operating model.

Application Scenarios

Product development: A product team can connect requirements, sprint tasks, approvals, defects, and release milestones. The project view gives managers a clearer picture than a manually updated timeline.

Marketing campaigns: A campaign team can manage copy review, design approval, landing page work, legal checks, and launch activities. Custom workflows help prevent publication before required approvals are complete.

Restricted environments: A regulated engineering team can use an on-premise or air-gapped deployment. The team keeps project planning and knowledge management aligned with its network restrictions.

Common Challenges When Building a Gantt Chart in Excel

Challenge: The bars start at the wrong dates

Cause: Excel may treat dates as text, or the chart may use the wrong category range.

Solution: Confirm that each start date is recognized as a date. Then check the horizontal axis bounds and verify that the Task column supplies the category labels.

Challenge: Tasks appear in reverse order

Cause: Horizontal bar charts often place the first category at the bottom.

Solution: Open the vertical axis settings and enable Categories in reverse order. Check that the horizontal axis remains at the bottom after changing the setting.

Challenge: The timeline contains too much empty space

Cause: The axis minimum may begin well before the first activity.

Solution: Set the minimum bound close to the earliest start date. Keep a small margin when the chart needs room for a current-date marker.

Challenge: Updating one task creates confusion

Cause: Excel does not automatically manage every dependency in a simple stacked bar chart.

Solution: Add predecessor notes and review connected tasks after changing a major date. For complex dependency networks, consider a project management platform.

Challenge: The chart becomes difficult to read

Cause: Too many colors, labels, gridlines, or tasks compete for attention.

Solution: Use one color for regular work and one accent for milestones or risks. Split a large plan into phase-level views when necessary.

FAQs

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

Yes. You can create one with a task column, start-date column, duration column, and stacked bar chart. Hide the start-date series and format the date axis. Templates can save setup time, yet building the chart yourself helps you understand how updates work.

Should duration include weekends?

Use the calendar that matches your project commitments. Include weekends when work continues every day. Exclude them when the team works Monday through Friday. For business-day planning, Excel’s WORKDAY function can help calculate finish dates more consistently.

How can I show progress on an Excel Gantt chart?

Add a progress percentage for each task, then create a second duration series representing completed work. Format completed work with a darker color and planned work with a lighter color. Keep the calculation consistent so a task at 50% does not appear complete simply because its end date has passed.

Can Excel automatically move dependent tasks?

A basic stacked bar chart does not manage complex dependencies automatically. You can use formulas and predecessor columns for simpler plans, then review connected dates after a change. Large projects with many relationships usually benefit from dedicated scheduling features.

What is the best time scale for an Excel project chart?

Choose the smallest useful unit that keeps the chart readable. Days suit short implementation plans, weeks suit product and campaign schedules, and months suit long programs. If labels overlap, widen the chart or use a larger time unit.

When should I use a project management platform instead?

Consider one when several people update the plan, dependencies change frequently, or status reporting requires repeated manual work. A platform can connect task ownership, workflow rules, reporting, approvals, and collaboration. Excel remains a sensible choice for a small, stable plan with limited coordination needs.

Conclusion

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

The essential technique is simple: keep the start-date series invisible and leave the duration series visible. After that, improve the axis, reverse task order when needed, add milestones, and review the schedule regularly.

But here's the truth: a chart only helps when the plan stays current. Update dates after real changes, check dependencies, and keep the view readable for everyone who relies on it.

For a small project, Excel may provide everything you need. When planning grows into shared workflows, reporting, approvals, and restricted deployment requirements, ONES.com offers a broader way to coordinate project work.