Where Is the Gantt Chart in Excel? A Step-by-Step Guide

Looking for a Gantt chart in Excel can be surprisingly frustrating. You open the Insert tab, scan the chart options, and still cannot find anything named “Gantt.” Then deadlines, task durations, and dependencies start getting harder to track.

But here’s the problem: Excel does not include a dedicated Gantt chart button. You need to build one with a stacked bar chart or start with a template. That extra step can make a simple project plan feel more complicated than it should.

Here’s the solution: create a task table, add start dates and durations, insert a stacked bar chart, and hide the starting-date series. I’ll show you exactly where to find each option, how to format the result, and when another project management platform may work better.

How to Create a Gantt Chart in Excel

Excel does not have a dedicated Gantt chart type. You create one by combining a stacked bar chart with task names, start dates, and durations.

You can build a basic timeline in a few minutes. The finished chart will show when each task begins, how long it lasts, and how tasks overlap across the project.

Step 1: Create the project schedule

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

• Task
• Start date
• Duration

Enter one task per row. Use actual dates in the start-date column, then enter the number of days each task should take.

For example, a website redesign might look like this:

Keep the dates consistent. If some tasks use calendar days and others use working days, the timeline may not reflect the real schedule.

Step 2: Select the schedule data

Highlight the task names, start dates, and durations. Include the column headings, but do not include unrelated notes or totals.

For the example above, select the range containing all three columns. Excel will use the start dates and durations as two chart series.

Step 3: Insert a stacked bar chart

Go to the Insert tab on the Excel ribbon.

1. Choose Insert Column or Bar Chart.
2. Open the 2-D Bar category.
3. Select Stacked Bar.

Do not choose a regular bar chart. The stacked version places the start date and duration beside each other, which creates the foundation for the timeline.

At this stage, the chart may look incorrect. You will probably see a large block representing the start dates and a smaller block representing task durations.

Step 4: Add task names to the vertical axis

If Excel does not automatically use your task names, right-click the chart and select Select Data.

In the Horizontal (Category) Axis Labels area, choose Edit. Select the cells containing your task names, then confirm the selection.

Your task names should now appear along the vertical axis.

Step 5: Reverse the task order

Excel commonly places the first task at the bottom of the chart. Most project plans read more naturally from top to bottom.

To reverse the order:

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

The first task should now appear at the top. You may need to adjust the horizontal axis afterward so the dates remain easy to read.

Step 6: Hide the start-date series

Now remove the visible start-date bars while keeping their spacing.

1. Click one of the bars representing the start dates.
2. Open the Format tab or right-click and choose Format Data Series.
3. Choose Fill.
4. Select No fill.
5. Set the border to No line.

The duration bars will remain visible. Their position along the timeline will reflect each task’s start date.

Here’s why: the invisible start-date series pushes each colored duration bar to the correct point on the calendar.

Step 7: Format the timeline

Click the horizontal axis and open Format Axis. You can change the minimum date, maximum date, major units, and number format.

For a short project, use a daily or two-day interval. For a six-month plan, weekly or monthly intervals will keep the chart readable.

You can also adjust the chart by:

• Changing the duration-bar color.
• Reducing the gap width between tasks.
• Adding a clear chart title.
• Removing the legend if it no longer helps.
• Using a date format that fits the available space.

The best part? Once the chart is set up, changing a start date or duration will update the task bar automatically.

Where the Gantt Chart Option Is—and Why You Cannot See It

You cannot find a dedicated Gantt chart under Excel’s chart menu because Excel does not offer it as a standard chart category.

Excel includes column, line, pie, area, scatter, and bar charts. A Gantt chart is usually built from a stacked bar chart, so the option is hidden in plain sight.

Think of the chart as two layers. The first layer represents the time before a task begins. The second layer represents the task itself. By hiding the first layer, you create the familiar horizontal timeline.

You may also find prebuilt Gantt templates through Excel’s template gallery. Search for terms such as project timeline, project planner, or Gantt. Templates can save setup time, although they may contain formulas and formatting you need to understand before editing.

What a Gantt Chart in Excel Can Show

A well-built timeline gives you a quick view of project timing. Each horizontal bar represents a task, while its position shows when that task begins.

Task duration

A longer bar means a task takes more time. For example, “Development” may span ten days, while “Client review” may take three.

Task overlap

Bars that appear on the same dates show overlapping work. This can help you spot periods when designers, developers, or reviewers may be needed at the same time.

Project milestones

You can represent a milestone with a one-day duration or add a separate marker. For example, “Launch approval” might appear as a single-day event after testing ends.

Schedule gaps

Large empty spaces may reveal waiting time. If testing finishes on April 20 but launch preparation starts on April 27, the gap deserves attention.

Let me explain: Excel is useful for visualizing a relatively simple schedule. It becomes harder to manage when the plan requires many linked tasks, frequent changes, several owners, or detailed progress tracking.

How to Add Dependencies and Progress Tracking

A basic Excel Gantt chart shows timing, but it does not automatically understand task relationships. You need to represent dependencies with additional planning columns or careful date updates.

Use predecessor details

Add a column called Predecessor beside your task list. Enter the task that must finish before the current task begins.

For example, “Development” may depend on “Design approval.” If approval moves by two days, you must update the development start date manually unless you build formulas for that relationship.

Show completed work

Add a Percent complete column. You can then create a second duration value that represents completed time and apply a darker color to it.

For a ten-day task that is 40% complete, the completed portion would represent four days. The remaining portion would show the outstanding six days.

Mark today’s date

A vertical “today” marker helps you compare the planned schedule with the current date. You can create one by adding a helper series with the current date and formatting it as a thin line.

This approach works for a personal plan. It takes more maintenance when several people update tasks throughout the week.

Excel Gantt Chart Limitations to Consider

Excel can produce a useful visual timeline, yet the chart is only as reliable as the schedule behind it. Manual updates create risk when project conditions change often.

Frequent schedule changes

If a supplier delay moves six connected tasks, you may need to revise several start dates. Missing one update can make the chart look accurate while showing the wrong sequence.

Limited collaboration

Multiple people editing the same workbook can create confusion around ownership and the latest changes. Comments and version history may help, but they do not replace a structured task workflow.

Complex dependencies

Excel does not automatically recalculate every project relationship in a standard Gantt setup. Finish-to-start, start-to-start, and lag relationships require additional formulas or manual planning.

Progress visibility

A colored bar can show completion, but it may not explain why a task is late. You might need separate columns for blockers, owners, risks, notes, and approval status.

You might be wondering: should you still use Excel? Yes, when the schedule is small, the team is limited, and the plan changes occasionally. A dedicated project platform becomes more practical as coordination grows.

Excel Gantt Chart Alternative: ONES.com

Value Proposition

ONES.com combines project management and knowledge management in one platform. ONES Project provides Jira-compatible workflows, while ONES Wiki helps teams organize shared project knowledge.

It can suit teams that have outgrown manually maintained timelines but still need flexible workflows, reporting, and deployment choices.

Core Capabilities

Manual schedule updates create errors → Custom workflows and fields → Teams can capture task states, owners, priorities, and delivery details in one workflow.

Instead of changing several chart ranges, you can configure fields that reflect how your team actually manages work.

Hidden dependencies cause delays → Linked project work items and workflow controls → Teams gain clearer visibility into what must happen next.

This is more useful than relying only on visual bar positions when tasks have relationships.

Repeated status work consumes time → Automation → Routine transitions and notifications can happen with fewer manual actions.

For example, moving an item to review can trigger the next workflow step.

Basic timelines lack reporting depth → Built-in reporting → Managers can review progress, workload, and delivery patterns without rebuilding charts.

Plugin-heavy setups increase maintenance → Native project management features → Teams can reduce reliance on separate add-ons for common planning needs.

Jira migration creates workflow concerns → Jira-compatible workflows → Teams can preserve familiar ways of organizing project work while evaluating a Jira alternative.

Restricted networks limit cloud choices → On-premise, private cloud, and air-gapped deployments → Organizations can run the platform in environments with tighter access requirements.

Different deployment versions create capability gaps → Full feature parity between cloud and self-hosted versions → Teams can choose a deployment model without giving up core functionality.

Application Scenarios

A software team may use ONES Project for sprint planning, custom approval steps, automated status changes, and reporting. That gives the team more control than a manually updated Excel timeline.

An engineering organization with restricted network access may choose an on-premise or air-gapped deployment. Project work can remain inside the required environment while teams use structured workflows.

A product team may combine ONES Project with ONES Wiki. The project area can track delivery work, while the knowledge area keeps requirements, decisions, and operating guidance easy to find.

Common Challenges When Building a Gantt Chart in Excel

The bars appear in the wrong order

Problem: Excel places the first task at the bottom.

Solution: Open the vertical axis settings and enable Categories in reverse order. Then check that the date axis still runs in the direction you expect.

The chart starts far away from the first task

Problem: Excel treats dates as serial numbers, so the invisible start-date series creates a large empty area.

Solution: Set the horizontal axis minimum to a date close to the project start. This reduces unnecessary blank space.

The duration bars do not line up with the dates

Problem: Some dates may be stored as text rather than recognized calendar values.

Solution: Re-enter the dates using a consistent format, then confirm that Excel recognizes them as dates. A recognized date usually aligns correctly when you change its number format.

Updating the schedule feels tedious

Problem: A delay requires manual changes across several rows.

Solution: Add formulas for predictable relationships, or move the plan to a project management platform when dependencies and ownership become difficult to maintain.

FAQs About Finding a Gantt Chart in Excel

Does Excel have a built-in Gantt chart?

Excel does not include a dedicated Gantt chart category in the standard chart menu. You can create one with a stacked bar chart, or search Excel’s template gallery for a project timeline template. The stacked-bar method gives you more control over dates, task names, colors, and formatting.

Where do I click to make a Gantt chart in Excel?

Select your task names, start dates, and durations. Then choose Insert, open Insert Column or Bar Chart, and select Stacked Bar. Hide the start-date series by setting its fill and border to “No fill” and “No line.”

Why does my Excel Gantt chart show large blue bars?

The large bars usually represent the start-date series. They create the spacing needed to position each task on the timeline. Select that series, open its formatting options, and make it invisible. The remaining duration bars will appear in their correct calendar positions.

Can I add dependencies to an Excel Gantt chart?

Yes, but a standard chart does not manage dependencies automatically. You can add predecessor columns, formulas, or helper calculations. If one delay affects several connected tasks, you may need to update those dates manually. A project management platform can handle these relationships more consistently.

Can an Excel Gantt chart show task progress?

Yes. Add a percent-complete column, then create a separate series for completed duration. Apply one color to completed work and another to remaining work. This gives you a visual progress indicator, although it requires extra setup and maintenance.

Conclusion

The Gantt chart option is not missing from your Excel installation. Excel simply does not offer it as a dedicated chart type.

Create the timeline with a stacked bar chart, use start dates to position tasks, hide the start-date series, and format the duration bars. This approach works well for a small project with limited dependencies.

But here’s the truth: manual charts become harder to trust when schedules change constantly. If your team needs connected work items, automation, reporting, collaboration, or controlled deployment, a platform such as ONES.com may provide a more durable way to manage the work.

Start with Excel when a quick visual plan is enough. Move to a structured project workflow when keeping the chart updated becomes a project in itself.