Guide · 2026-08-19

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

Project timelines can become confusing when tasks overlap, deadlines move, and nobody knows who owns the next step. A plain task list rarely shows how work fits together.

That confusion grows quickly. You may miss dependencies, underestimate a delayed task, or spend hours formatting a timeline that becomes outdated the next morning.

Here’s the solution: build a Gantt chart in Excel with task names, start dates, durations, and a stacked bar chart. This seven-step method gives you a practical project timeline without complex software.

How to Make a Gantt Chart in Excel in 7 Steps

A Gantt chart in Excel uses a stacked bar chart to show when each task starts and how long it lasts. The hidden first series creates spacing, while the visible series displays task duration.

Step 1: Create the Project Schedule

Open Excel and create three columns for the basic schedule:

Enter one task per row. Keep the schedule simple at first, then add more detail after the chart works.

Task Start Date Duration
Project kickoff January 6, 2026 1 day
Requirements review January 7, 2026 4 days
Design January 13, 2026 7 days
Development January 22, 2026 12 days
Testing February 9, 2026 6 days

Excel stores dates as serial numbers, so the chart can position each task along a time axis. Enter real dates rather than typing dates as plain text.

Step 2: Calculate Task Durations

Duration means the number of calendar days between a task’s start and finish dates. You can enter durations manually or calculate them with a formula.

Add a Finish Date column if you want Excel to calculate the duration:

In the Duration column, use a formula such as:

=C2-B2+1

This counts both the starting day and ending day. For example, a task running from January 7 through January 10 lasts four calendar days.

For weekdays only, use:

=NETWORKDAYS(B2,C2)

You can also account for holidays with:

=NETWORKDAYS(B2,C2,Holidays)

Replace Holidays with the cell range containing your non-working dates. Choose one duration method and use it consistently across the schedule.

Step 3: Select the Start Dates and Durations

Select the Task, Start Date, and Duration columns. Include the column headings, but avoid selecting unrelated notes or blank rows.

For a small schedule, hold the Ctrl key while selecting separate ranges. A cleaner approach is placing the three columns beside each other before creating the chart.

Here’s why:

The chart needs two numeric series. The Start Date series controls horizontal placement, while Duration controls the length of each task bar.

Step 4: Insert a Stacked Bar Chart

Go to Insert, choose Bar Chart, and select 2-D Stacked Bar.

Excel will create two colored series. One represents the start dates, and the other represents task durations.

The chart may look strange initially. That is normal because Excel treats the date values as large numbers.

If the task labels appear in the legend instead of on the vertical axis, open Chart Design and select Switch Row/Column.

Step 5: Hide the Start-Date Series

Click one of the bars representing the start dates. Right-click it and choose Format Data Series.

Set:

The start-date series will disappear visually, leaving the duration bars positioned across the timeline.

The hidden series still performs an important function. It pushes each task bar to its correct starting point.

Step 6: Reverse the Task Order

Excel often places the first task at the bottom of the chart. Reverse the order so the project reads naturally from top to bottom.

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

You may need to adjust the horizontal axis afterward. Set the minimum and maximum bounds around your project dates.

For example, if your project runs from January 6 through February 20, use bounds slightly before January 6 and after February 20.

Step 7: Format and Maintain the Gantt Chart

Remove unnecessary chart elements, adjust colors, and make the task labels readable. A useful chart should communicate progress quickly.

Consider these formatting changes:

When a date or duration changes, Excel updates the chart automatically. Keep formulas intact, and avoid manually dragging bars to represent schedule changes.

What Information Does an Excel Gantt Chart Need?

A useful timeline needs task names, start dates, and durations. Those three fields create the basic visual schedule.

Task Names

Use action-oriented labels such as “Approve design” or “Complete user testing.” Avoid vague labels like “Phase two” unless you define the work elsewhere.

Short labels make the vertical axis easier to scan. If a task needs extra context, add a Notes column beside the schedule.

Start Dates

Each task needs a start date. These dates determine where the bars appear along the horizontal timeline.

Use a consistent date format, such as 6-Jan-2026. Consistency makes errors easier to spot during schedule reviews.

Durations

Duration determines the length of each bar. You can measure it in calendar days or working days.

Calendar days work well for continuous activities. Working days are more practical when weekends and holidays do not count toward delivery.

Milestones

A milestone is a zero-duration event, such as approval, launch, or contract signing. Excel may display a zero-duration task poorly.

Give milestones a duration of one day, then use a different color or marker. This keeps them visible without changing the milestone’s meaning.

How to Add Dependencies and Milestones

A basic Excel Gantt chart shows timing. You can make it more useful by showing relationships between tasks.

Representing Dependencies

Dependencies explain why one task cannot begin until another task reaches a certain point.

For example, development may start only after design approval. Add a Dependency column with entries such as:

Excel will not automatically draw dependency arrows in a basic stacked bar chart. You can add arrows manually, or use a separate dependency column for planning and review.

For a small project, manual arrows may be adequate. For a schedule with dozens of relationships, maintenance becomes difficult.

Highlighting Milestones

Use a separate Milestone column with values such as “Yes” or “No.” Apply a different color to milestone rows.

Another option is adding a scatter series with milestone dates. This gives you diamond markers over the timeline, though it requires more chart configuration.

Adding a Today Marker

A vertical line showing today helps you compare planned progress with the current date.

Create a Today column containing the current date. You can use:

=TODAY()

Then add that series to the chart and format it as a narrow contrasting bar or line. Review the chart regularly because the marker changes automatically.

How to Format an Excel Timeline for Clearer Planning

Formatting affects how quickly someone can understand the schedule. A polished chart still needs a simple visual hierarchy.

Use Colors With Meaning

Choose colors that communicate status consistently. For example:

Do not use a different color for every task. Too many colors make the chart harder to interpret.

Separate Planned and Actual Dates

Add Planned Start, Planned Finish, Actual Start, and Actual Finish columns when progress tracking matters.

You can show planned work with a light bar and actual work with a darker bar. This makes schedule variance visible without calculating it mentally.

Improve the Time Axis

Right-click the horizontal axis and select Format Axis. Adjust the major unit to control how often dates appear.

Use daily labels for short projects. Use weekly or monthly labels for longer plans.

For example, a two-week campaign may need daily markers. A six-month implementation usually needs monthly markers.

Make the Chart Printable

Set the print area, choose landscape orientation, and check whether task labels remain readable. A chart that only works on your screen may fail during a review meeting.

Keep the schedule and chart on one worksheet when possible. This makes printing and sharing easier.

Common Excel Gantt Chart Problems and Fixes

Most problems come from date formatting, incorrect chart selection, or inconsistent duration formulas. Here are practical fixes for the issues you are most likely to encounter.

The Bars Start on the Wrong Date

Excel may interpret dates as text. Select the date cells and apply a date format from the Home ribbon.

If that does not work, re-enter one date manually. Then copy the format across the remaining date cells.

The Tasks Appear in the Wrong Order

Open the vertical axis settings and select Categories in reverse order. This places the earliest task at the top.

Check the horizontal axis afterward. Reversing categories can move the axis position unexpectedly.

The Chart Shows Only One Series

Your selected range may exclude either Start Date or Duration. Reopen Select Data and confirm both series appear.

Each series should point to the correct rows. The task names should serve as the category labels.

The Schedule Is Too Wide

A long project can create a chart with excessive empty space. Adjust the horizontal axis bounds to match the actual planning period.

Also check for an accidental date far in the future. One incorrect date can stretch the entire chart.

Updates Feel Tedious

Manual formatting becomes difficult when the schedule changes often. Use formulas, consistent columns, and conditional formatting to reduce repetitive work.

If your project includes frequent dependencies, multiple teams, or daily status changes, a project platform may save more time than continued chart maintenance.

Gantt Chart Solution: ONES.com

ONES.com product screenshot

Value Proposition

ONES.com brings project management and knowledge management into one platform, powered by ONES Assistant. ONES Project is the project management product and a Jira alternative, while ONES Wiki handles knowledge management and is sold separately.

It can suit teams that need structured planning, reporting, workflows, and controlled deployment beyond a manually maintained Excel timeline.

Core Capabilities

ONES.com offers a free plan for up to 30 seats. Cloud and self-hosted versions provide full feature parity, which helps teams choose deployment around security and infrastructure requirements.

Application Scenarios

Software release planning: A development team can organize epics, sprints, approvals, testing, and release work in one project environment. Managers can review progress without rebuilding a chart after every schedule change.

Regulated internal projects: A team with strict network requirements can use an On-Premise, Private Cloud, or Air-gapped deployment. Project information remains within the required environment.

Cross-functional launches: Marketing, design, engineering, and operations can coordinate shared milestones through custom workflows and reporting. ONES Wiki can separately hold supporting team knowledge.

Common Challenges When Building a Gantt Chart in Excel

Challenge: The Schedule Becomes Outdated

Problem: A manually maintained chart quickly loses accuracy when dates shift or tasks expand.

Solution: Link duration to finish dates with formulas. For larger projects, use a platform that updates views from active task records.

Challenge: Dependencies Are Hard to Track

Problem: Basic Excel charts do not manage dependency logic automatically.

Solution: Add dependency fields for small plans. Use dedicated project management features when one delay should affect several downstream tasks.

Challenge: Too Much Detail Makes the Chart Unreadable

Problem: Adding every activity creates a crowded visual with tiny labels and overlapping bars.

Solution: Keep the primary chart focused on major deliverables. Track smaller activities separately or group them beneath summary tasks.

Challenge: Different Teams Use Different Definitions

Problem: One team may count calendar days, while another counts working days.

Solution: Define duration rules before building the schedule. Add a short planning note that explains weekends, holidays, and milestone treatment.

Challenge: Progress Is Difficult to Compare

Problem: A planned timeline does not show whether work is ahead, on track, or late.

Solution: Add actual dates, completion percentages, and a today marker. Review variance during every project update.

FAQs About Creating a Gantt Chart in Excel

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

Yes. You can create one manually with Task, Start Date, and Duration columns. Insert a stacked bar chart, hide the start-date series, reverse the task order, and format the time axis.

Templates can save setup time, especially when you need progress tracking or milestone markers. However, building the chart manually helps you understand how the timeline works.

What is the best Excel chart type for a Gantt chart?

A stacked bar chart is the standard choice. The first series represents the start date and remains invisible. The second series represents task duration and stays visible.

A regular bar chart cannot create the same spacing effect. A stacked bar chart gives you control over each task’s starting position and length.

How do I show weekends in an Excel Gantt chart?

Use calendar-day durations when weekends should appear as part of the schedule. Use the NETWORKDAYS function when weekends should not count toward task length.

You can also shade weekend columns with conditional formatting. This makes non-working periods easier to recognize during planning.

How can I show completed work?

Add a Completion percentage column, then create a second duration series for completed time. Format completed time with a darker color over the planned bar.

For a simpler approach, use conditional formatting or manually color finished tasks. Update the method consistently so status remains trustworthy.

When should I use a project management platform instead?

Excel works well for small, stable schedules with limited dependencies. Consider a project platform when several teams update tasks, approvals matter, or progress changes frequently.

A dedicated platform can connect ownership, workflows, reporting, notifications, and task history. That reduces the effort needed to keep the timeline accurate.

Conclusion

You can create an Excel Gantt chart 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 maintain formulas as the schedule changes. Add milestones, dependencies, actual dates, and a today marker when your project needs more visibility.

But here’s the truth: the chart only helps when the schedule stays accurate. If updates become repetitive or dependencies become difficult to manage, ONES.com can provide a structured project management environment through ONES Project.

Start with Excel for a focused planning need. Move to a dedicated platform when coordination, reporting, security, and ongoing change become the bigger challenge.