How to Build a Gantt Chart in Excel: 7 Steps With Examples

A project can have clear tasks and still feel impossible to manage when dates, dependencies, and deadlines are scattered. A plain list tells you what needs doing, but it rarely shows whether work overlaps or where a delay could affect the finish date.

That gap gets frustrating fast. You may miss a handoff, underestimate a task, or spend time adjusting a chart that keeps changing shape. But here's the truth: Excel can create a useful Gantt chart with a stacked bar chart and a few carefully arranged columns.

In this guide, I’ll walk you through seven steps, using a small website launch as an example. You’ll learn how to prepare task dates, build the chart, format its timeline, and keep it readable as plans change. I’ll also explain when Excel works well and when a project management platform may save you effort.

How to Make a Gantt Chart in Excel: 7 Steps

Quick answer: List each task, start date, and duration, then create a stacked bar chart using the start dates as invisible offsets. Format the date axis and task bars to turn it into a timeline.

For the example, imagine a small website launch with five tasks: plan pages, write copy, design the site, build the site, and test it. The tasks span several weeks, with some work happening in parallel.

1. Step 1: Set up your task columns. Create columns for Task, Start Date, Duration, and End Date. Use one row per task, and enter actual Excel dates in the date columns.

   For example, “Plan pages” might start on June 2 and take three days. “Write copy” could begin June 4 and last five days. Choose whether your duration counts calendar days or working days, then use the same convention throughout the plan.

2. Step 2: Calculate each task’s duration. Enter the number of days you expect each task to take. If you already have start and end dates, calculate the duration by subtracting the start date from the end date.

   For a calendar-day schedule, a simple duration formula is =D2-C2 if the start date is in C2 and the end date is in D2. Add one if you want both the first and final day counted as full workdays.

   For example, June 2 through June 4 can be treated as a three-day task when both dates count. Keep your chosen counting method consistent so bars don’t appear shorter or longer than planned.

3. Step 3: Select the chart ranges. Select the task names, start dates, and durations. These three fields become the category labels and the two chart series.

   If the columns aren’t next to one another, select one range, then hold Ctrl on Windows or Command on Mac while selecting the other ranges. Check that the task names line up with their dates and durations before inserting the chart.

4. Step 4: Insert a stacked bar chart. In Excel, open the Insert tab, choose Bar Chart, and select Stacked Bar. Use the stacked option rather than a clustered bar chart, because the duration series needs to begin after each task’s start-date offset.

   Excel may initially show two visible colors for every task. That’s expected: one series represents the start date, and the second represents the task duration. You’ll hide the start-date series in the next step.

5. Step 5: Hide the start-date series. Select a bar from the start-date series, open Format Data Series, and set its fill to No Fill. You can also remove its outline.

   The start-date series remains in the chart as an invisible offset. The visible duration bars now begin at the correct points on the timeline, making the chart look like a schedule instead of two stacked blocks.

6. Step 6: Fix the task order and date axis. Select the vertical category axis and enable Categories in reverse order. This usually places the first task at the top of the chart.

   Next, select the horizontal date axis. Set its minimum and maximum bounds to match the project’s start and finish dates, then choose a date format that’s easy to scan. If the date scale feels too crowded, adjust its major unit to show weekly or monthly intervals.

   Excel stores dates as serial numbers, so axis bounds may appear as numbers in the formatting pane. If that happens, enter the correct date values and check the chart labels before moving on.

7. Step 7: Improve readability and check the schedule. Choose a restrained bar color, remove chart clutter, and give the chart a clear title. Widen the chart area if task names or date labels are cut off.

   Compare each bar with your original dates. For the website launch, “Write copy” should overlap the planning task if its start date falls before planning ends. If a task’s date changes, update its row and confirm that the bar moves as expected.

What a Gantt Chart Shows—and What Excel Needs

A Gantt chart is a timeline that displays project tasks as horizontal bars. Each bar’s position shows when a task starts, while its length represents how long the work is expected to take.

Here's why the stacked bar method works: Excel uses the start-date series to position each duration bar along a shared timeline. Once you make the start-date series invisible, the remaining bars show the schedule clearly.

For example, a five-day writing task can overlap with a three-day planning task. That overlap is easy to spot on a Gantt chart, even if the task list alone makes the work look sequential.

Information to prepare before charting

• Task names: Use concise labels such as “Draft landing page” or “Review design.”
• Start dates: Enter real Excel dates, not text that only looks like a date.
• Durations: Decide whether you’re counting calendar days or working days.
• Dependencies: Note which tasks need another task to finish first.

Excel’s basic Gantt chart displays dates and durations, but it doesn’t automatically enforce dependencies. If testing must follow development, you’ll need to adjust dates yourself when development slips.

Use Dependencies and Milestones Without Making the Chart Hard to Read

A useful chart shows meaningful relationships without squeezing every detail into the bars. You can add a Dependency column to your plan, such as “Testing starts after build,” and use it to review whether dates make sense.

For instance, if site testing is scheduled for June 16 but development ends June 18, the schedule contains a conflict. Excel won’t necessarily flag it, so compare the task dates whenever a predecessor moves.

Show milestones as short tasks

A launch approval or design sign-off has little duration, so it may not appear clearly as a regular bar. You can give the milestone a one-day duration and use a contrasting color, or add a separate marker series if you’re comfortable adjusting chart settings.

Keep milestone labels brief. A chart with every approval detail can become harder to read than the task list it was meant to clarify.

Decide how to handle non-working days

A basic stacked bar chart treats duration as a continuous span. If a task lasts five working days but crosses a weekend, the bar may include Saturday and Sunday.

That’s acceptable for a high-level calendar view. If you need exact working-day timing, calculate dates using a workday calendar and verify how the chart represents gaps. For a simple plan, clearly state whether weekends are included.

Keep Your Excel Gantt Chart Accurate as Plans Change

A chart is only useful while its dates reflect the current plan. When a task slips, update its start date and duration, then check any dependent tasks that may also need to move.

The best part? You can make routine updates easier by converting the task range into an Excel Table. New rows can inherit formatting and formulas, and your chart may be easier to expand as the plan grows.

Use formulas carefully

Formula-driven end dates help reduce manual arithmetic. For a calendar-day duration where both the start and end dates count, an end-date formula can add the duration minus one to the start date.

If a task takes five days and starts June 10, the inclusive end date is June 14. Choose the formula convention that matches your planning rules, then apply it consistently.

Make a quick review part of each update

• Check whether each task’s start date is still realistic.
• Confirm that delayed tasks haven’t created conflicts downstream.
• Verify the chart’s date bounds still include the full schedule.
• Look for missing bars caused by blank dates or text-formatted dates.

For a short project with a few contributors, this review may take only a minute. A schedule with many owners and frequent changes needs a more deliberate update routine.

When Excel Is a Good Fit—and When It Becomes a Bottleneck

Excel works well when you need a straightforward visual schedule for a small project. A team planning a two-week campaign, for example, can use a single chart to see deadlines and overlapping work.

As the plan expands, manual upkeep becomes more demanding. If several people change dates, task owners, and dependencies, you may spend more time reconciling updates than coordinating the work.

Excel may be enough when

• The project has a manageable number of tasks.
• One person maintains the schedule and communicates changes.
• You mainly need a visual timeline for review or presentation.

Consider a project management workflow when

• Several teams need to update work at the same time.
• Task dependencies and ownership change frequently.
• You need progress reporting alongside the schedule.
• Project plans and team knowledge should stay connected.

Let me explain: the difference is less about the chart itself and more about the work required to keep it trustworthy. A visual timeline can be simple; coordinating a changing project often isn’t.

Project Management Beyond Excel: ONES.com

ONES.com brings project management and knowledge management together on a unified platform powered by ONES Assistant. It can help teams coordinate work and keep project knowledge accessible as schedules evolve.

If you’ve outgrown a manually maintained Excel chart, ONES Project provides project management capabilities as a Jira alternative. ONES Wiki is a knowledge management product and a Confluence alternative. They’re sold separately, so you can choose the product that fits your needs.

Core capabilities: from planning pain to practical outcomes

• Pain: Task plans are difficult to maintain across many work items. ONES capability: ONES Project supports sprint management and configurable workflows. Result: Teams can organize work around their process and monitor progress more consistently.
• Pain: A fixed task list doesn’t reflect how different teams work. ONES capability: Custom workflows and fields let teams tailor tracking. Result: Project details can better match the team’s delivery process.
• Pain: Repeated administrative actions take time. ONES capability: Automation supports routine workflow actions. Result: Teams can reduce some manual coordination.
• Pain: A timeline offers little insight into status. ONES capability: Built-in reporting helps teams review project progress. Result: Project discussions can use a clearer view of current work.
• Pain: Teams rely on numerous add-ons to match familiar workflows. ONES capability: Jira-compatible workflows, custom fields, sprint management, automation, and reporting are available natively. Result: Teams may reduce plugin dependence while preserving familiar practices.
• Pain: Some organizations need to control where their platform runs. ONES capability: Deployment options include Cloud, On-Premise, Private Cloud, and Air-gapped environments. Result: Teams can choose a deployment approach suited to their requirements.
• Pain: Self-hosted teams worry about losing functionality. ONES capability: ONES.com offers full feature parity between cloud and self-hosted versions. Result: Teams can consider self-hosting without planning around a reduced feature set.
• Pain: A team wants to try project management without committing to a large rollout. ONES capability: The free plan supports up to 30 seats. Result: A small team can evaluate whether its project workflow fits.

Where teams might apply it

A software team moving beyond a simple Excel timeline could use ONES Project to organize sprints, define custom fields, and automate routine transitions. Built-in reporting can help the team review progress without relying on a manually refreshed chart.

A regulated team with deployment constraints could assess On-Premise, Private Cloud, or Air-gapped deployment options. A team that also needs a managed knowledge space could evaluate ONES Wiki separately from ONES Project.

ONES.com makes sense to consider when project coordination has outgrown a single-person schedule or when deployment flexibility matters. If your chart is small and rarely changes, Excel may remain the simpler choice.

Common Challenges When Building a Gantt Chart in Excel

Most chart problems come from inconsistent dates, unclear duration rules, or settings that Excel applies automatically. Here are practical fixes for issues you’re likely to encounter.

• Bars start at the wrong dates. Check that the start-date cells contain real date values and are included as the first chart series. Then confirm that you selected a stacked bar chart.
• Tasks appear in reverse order. Select the category axis and enable Categories in reverse order. If the date axis shifts, adjust its position in the axis formatting settings.
• Some task bars are missing. Look for blank start dates, zero durations, or dates stored as text. Correct the affected cells and check whether the chart includes every task row.
• The timeline is too wide or crowded. Set reasonable minimum and maximum date bounds, then adjust the major interval. A weekly scale often suits a short project better than daily labels.
• Dates change but dependencies don’t. Excel’s chart won’t automatically reschedule dependent tasks. Review successor dates manually or use a project management workflow that better supports coordination.

FAQs About Creating a Gantt Chart in Excel

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

Yes. Create task, start-date, and duration columns, then insert a stacked bar chart. Hide the start-date series, reverse the task order if needed, and format the date axis. A template can save setup time, but building the chart yourself helps you understand how to update it when tasks or dates change.

Why does my Excel Gantt chart show two bars for each task?

The chart includes a start-date series and a duration series. The start-date series acts as an offset, positioning the duration bar along the timeline. Select that first series and set its fill to No Fill. It remains part of the chart but becomes invisible, leaving the duration bars visible at their scheduled dates.

How do I show weekends in an Excel Gantt chart?

A basic stacked bar chart uses a continuous date axis, so weekends appear as part of the timeline. If your duration is based on working days, the bar may cross weekend dates even though no work is planned then. For a high-level view, that can be acceptable; for precise schedules, calculate working dates and verify the chart’s representation.

Can Excel automatically move dependent tasks when a date changes?

A standard Gantt chart in Excel doesn’t automatically reschedule dependent tasks. You need to review related dates and update them when a predecessor slips. Formulas can help with simple rules, such as setting a task’s start after another task finishes, but more complex dependencies can become difficult to maintain manually.

When should I move from Excel to project management software?

Consider a dedicated project management workflow when multiple people update the plan, dependencies change often, or reporting takes too much manual effort. Excel can still work for a small schedule maintained by one person. The deciding factor is whether maintaining accurate dates and communicating changes has become a recurring burden.

Conclusion: Build a Clear Schedule, Then Keep It Current

To make a Gantt chart in Excel, organize tasks by start date and duration, insert a stacked bar chart, hide the start-date series, and format the timeline. A quick review of task dependencies and date bounds helps keep the result useful.

When a project’s schedule becomes hard to maintain, repeated chart fixes can distract from the work itself. Start with Excel for a small plan, and consider a project management workflow such as ONES Project if coordination, reporting, or deployment needs grow.

You now have a practical way to turn a task list into a visual timeline. Keep the dates consistent, make overlaps easy to read, and revisit the schedule whenever the plan changes.