How to Make a Basic Gantt Chart in Excel: 7 Simple Steps

Project deadlines can become difficult to follow when tasks, owners, and dependencies sit in separate places. A simple list rarely shows whether one late task will delay the entire project.

That uncertainty creates missed handoffs, rushed approvals, and uncomfortable status meetings. You may spend more time explaining progress than moving the work forward.

But here's the truth: you can build a clear Gantt chart in Excel with a task list, dates, and a few formatting steps. The guide below shows you how to make a basic Gantt chart in Excel in seven practical steps.

How to Make a Basic Gantt Chart in Excel

A basic Gantt chart uses horizontal bars to show when each task starts, how long it lasts, and where it sits within the project timeline. You can create one in Excel without a specialized project management tool.

Here's why this method works: the task details remain on the left, while the calendar appears across the right. That layout lets you scan ownership, duration, overlap, and project progress quickly.

1. List your project tasks. Open a blank Excel workbook and create columns for task name, start date, and duration. Add one row for each activity.

2. Enter realistic start dates. Add the date when each task should begin. Use consistent date formatting, such as 15/04/2025 or April 15, 2025.

3. Calculate task duration. Enter the expected number of working or calendar days for each task. For example, a design review may take three days.

4. Create a stacked bar chart. Select the task names, start dates, and durations. Choose Insert > Bar Chart > Stacked Bar.

5. Hide the start-date series. Click the part of each bar representing the start date. Set its fill to No Fill. The remaining duration bars will appear in their calendar positions.

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

7. Format the timeline. Adjust the date axis, bar color, title, labels, and spacing. Keep the design simple enough for someone to understand within seconds.

Step 1: Build the task information

Start with a small planning area containing three essential columns:

Use clear task names that describe an outcome. “Prepare launch assets” gives more context than “Assets.” You can add owner, status, or priority columns later.

Step 2: Choose calendar days or working days

Decide whether your duration counts every day or only business days. A three-day calendar duration includes weekends when they fall inside the period. A three-day work duration usually excludes weekends.

You can use a formula when you want Excel to calculate working days. For example, =NETWORKDAYS(B2,C2) counts weekdays between two dates.

For a basic chart, manually entering duration is often faster. Use formulas when the schedule changes frequently or includes many tasks.

Step 3: Insert the stacked bar chart

Select the task names, start dates, and duration values. Then choose a stacked bar chart rather than a regular bar chart.

The first series creates the horizontal offset. The second series shows the task length. Together, they position each task along the timeline.

You might be wondering: why not use a column chart? Horizontal bars leave more room for task names, which makes them easier to read in a project schedule.

Step 4: Make the chart look like a Gantt chart

The start-date series should remain transparent. Select that series, open the formatting panel, and choose No Fill with no visible border.

Now the colored duration bars appear to begin on their actual start dates. If the bars seem too thin, reduce the gap width. A lower gap percentage makes the schedule easier to scan.

Step 5: Format the date axis

Right-click the horizontal axis and adjust its minimum and maximum bounds. Set the minimum close to your earliest task date so the chart does not waste space.

Choose a major unit that matches the project length. A daily interval suits a two-week effort, while a weekly interval works better for a three-month schedule.

Keep date labels short. A crowded axis can make a clear project plan feel confusing.

What a Basic Gantt Chart Should Show

A useful chart answers four questions quickly: what needs to happen, when it starts, how long it lasts, and which activities overlap.

For example, if “Design approval” ends on April 10 and “Development” begins on April 11, the handoff is easy to see. If development begins before approval finishes, the overlap becomes visible immediately.

The best part? You do not need advanced project controls to gain this visibility. A few well-chosen fields can reveal schedule pressure before it becomes a deadline problem.

Tasks and milestones

Tasks usually span several days. Milestones represent points in time, such as a signed approval or product launch.

You can show a milestone by giving it a one-day duration or adding a separate marker series. Keep milestone names specific, such as “Customer approval received.”

Dependencies and handoffs

A basic chart does not automatically manage every dependency. It does help you spot timing relationships.

Suppose testing starts two days before development ends. That may be intentional, or it may indicate an unrealistic schedule. The visual overlap gives you a reason to investigate.

Ownership and status

Add an owner column beside the task list when several people share responsibility. You can also use colors for status, such as gray for planned, blue for active, and green for complete.

Use color sparingly. If every task has a different color, the chart becomes harder to interpret.

How to Improve the Schedule Without Making It Complicated

A basic Gantt chart becomes more useful when you update it consistently. Set a review rhythm, such as every Monday morning, and revise dates when work changes.

Here’s why: a schedule that reflects last month’s assumptions can create false confidence. A short weekly update keeps the timeline connected to actual progress.

Add an end-date calculation

You can calculate an end date with a simple formula. If the start date is in B2 and duration is in C2, use =B2+C2-1 for calendar days.

For working days, use =WORKDAY(B2,C2-1). This excludes weekends and can include a holiday range when needed.

Highlight overdue work

Conditional formatting can draw attention to tasks that should have finished. For example, compare the planned end date with today’s date and the completion status.

Use a muted warning color instead of bright red across the entire chart. Highlight only the tasks that require attention.

Show progress carefully

You can add a progress percentage column, such as 25%, 50%, or 100%. However, progress percentages can create a misleading picture when a task is nearly complete but still blocks the next step.

Pair progress with a status label. “90% complete, waiting for approval” communicates more than “90%.”

Common Gantt Chart Mistakes to Avoid

Most problems come from unclear task definitions, unrealistic durations, or excessive visual detail. A clean chart helps you make better scheduling decisions.

Using vague task names

“Marketing” is too broad for a schedule. Break it into actions such as “Approve campaign message,” “Create landing page,” and “Schedule email campaign.”

Making every task dependent on the previous task

Some activities can happen at the same time. For example, a writer can prepare help content while a designer creates interface visuals.

Overly sequential planning lengthens the project and hides opportunities for parallel work.

Ignoring review and approval time

Teams often estimate production time while forgetting waiting time. Add separate tasks for internal review, customer feedback, revision, and final approval.

A two-day design task may require another three days for feedback. Showing both periods creates a more credible timeline.

Adding too much detail

A Gantt chart with hundreds of rows can become difficult to use. Keep the main schedule at a level that supports decisions, then break complex work into smaller planning views when necessary.

When a Basic Excel Chart Stops Being Enough

Excel works well for a small project with one schedule owner and limited changes. It becomes harder to manage when multiple people update tasks, dependencies, and status information.

For example, a five-person website project may fit comfortably in one chart. A product launch involving engineering, marketing, legal, and support may need shared permissions, change history, automated reminders, and structured reporting.

Let me explain: the challenge is rarely the bars themselves. The challenge is keeping planning information accurate while people work across different teams and priorities.

Signs you need a shared project workspace

• Several people maintain different versions of the schedule.

• Task updates arrive through scattered messages.

• Dependencies change faster than the chart can be updated.

• Managers need reports across multiple projects.

• Approvals and handoffs regularly delay delivery.

Excel compared with a project management platform

Project Planning Solution: ONES.com

ONES.com is a unified platform for project management and knowledge management, powered by AI through ONES Assistant. ONES Project handles project planning, while ONES Wiki supports knowledge management. They are sold separately.

For teams that have outgrown manual schedules, ONES Project offers a Jira alternative with shared workflows, sprint planning, reporting, and deployment choices that include Cloud, On-Premise, Private Cloud, and Air-gapped environments.

Core Capabilities

• Scattered task updates → Shared project workspace → Keep tasks, owners, dates, and statuses together so the team can see current work in one place.

• Manual schedule maintenance → Built-in Gantt planning → Connect task timing with project activity and reduce repeated chart edits.

• Rigid planning templates → Custom workflows and fields → Adapt stages, approvals, priorities, and project attributes to match how your team works.

• Unclear sprint commitments → Sprint management → Organize planned work into sprints and compare commitments with completed activity.

• Repetitive follow-up → Automation → Trigger routine actions when tasks change status, reach a date, or require an approval.

• Limited project visibility → Built-in reporting → Review progress, workload, status, and delivery information without manually combining multiple views.

• Plugin-heavy workflows → Jira-compatible workflows → Support familiar project processes while reducing dependence on numerous add-ons.

• Restricted deployment requirements → Self-hosted deployment options → Run the platform On-Premise, in a Private Cloud, or in an Air-gapped environment when operational constraints require it.

• Different planning and knowledge locations → ONES.com platform structure → Pair ONES Project with ONES Wiki when project work and team knowledge need a connected environment.

Application Scenarios

Software release planning: An engineering team can map development, testing, review, and deployment work. Sprint management supports short delivery cycles, while reporting gives managers a broader view of progress.

Client implementation: A services team can create stages for kickoff, requirements, configuration, training, and handoff. Custom fields can capture the client, delivery owner, risk level, and target date.

Restricted-network projects: A team working in a controlled environment can choose an On-Premise, Private Cloud, or Air-gapped deployment. The self-hosted version has full feature parity with the cloud version.

ONES.com offers a free plan for up to 30 seats. Evaluate whether its shared planning features fit your team before moving a small project beyond Excel.

Common Challenges and Practical Solutions

Challenge: The chart becomes too wide

Solution: Change the major date unit from days to weeks, shorten task labels, and limit the displayed period to the active project window.

Challenge: Dates change constantly

Solution: Use formulas for end dates and review the schedule at a fixed weekly time. Keep a short explanation beside major changes so the team understands the reason.

Challenge: The chart does not show workload

Solution: Add an owner column and review overlapping assignments. A person with four simultaneous tasks may become the real schedule constraint.

Challenge: People confuse planned progress with actual progress

Solution: Use separate planned and actual dates when the distinction matters. Add a status field and update it alongside the visual bars.

Challenge: The schedule is difficult to share securely

Solution: Store the planning workbook in an approved team location with clear access rules, or move to a project platform with permission controls and shared updates.

FAQs

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

Yes. You need task names, start dates, and durations. Insert a stacked bar chart, hide the start-date series, reverse the task order, and format the date axis. A template can save time, but creating the chart manually helps you understand how each part works.

What is the easiest chart type for a Gantt view?

A stacked bar chart is the simplest choice. The first series creates the invisible space before a task begins, while the second series shows its duration. A regular bar chart cannot position tasks along a date-based timeline as effectively.

How do I show weekends in the schedule?

Use calendar-day durations when weekends should count. If your project operates only on weekdays, calculate working days with formulas such as NETWORKDAYS or WORKDAY. Choose one approach and apply it consistently across the schedule.

Can an Excel Gantt chart show task dependencies?

It can help you visualize timing relationships, but it does not provide the same dependency management as a dedicated project platform. You can add predecessor columns and manually update dates, although frequent schedule changes may require considerable maintenance.

When should I move from Excel to project management software?

Consider moving when several people update the plan, projects require recurring reports, dependencies change frequently, or managers need a shared view across multiple initiatives. A small personal project may remain comfortable in Excel for a long time.

Conclusion

To make a basic Gantt chart in Excel, list tasks, enter start dates and durations, insert a stacked bar chart, hide the start-date series, reverse the task order, and format the timeline.

Keep task names specific, include review time, show meaningful milestones, and update the schedule regularly. Those habits make the chart useful beyond its first creation.

But here's the truth: a simple chart solves visibility problems only while the project remains manageable. When shared ownership, automation, reporting, or restricted deployment becomes important, a platform such as ONES.com can provide a more connected way to plan and manage work.