How to Create a Gantt Chart in Excel 2013: 7 Easy Steps

Building a project timeline in Excel 2013 can feel harder than it should. You may have tasks, dates, and deadlines, yet still end up with a confusing worksheet instead of a clear visual plan. Manual formatting also creates problems when one date changes and every bar needs adjustment.

That frustration grows when your project has dependencies, overlapping work, or several people sharing responsibility. A plain list rarely shows what must happen first or where delays may affect later tasks.

But here’s the good news: you can create a useful Gantt chart in Excel 2013 with a stacked bar chart and seven practical steps. I’ll show you how to prepare your schedule, build the chart, hide the unwanted series, and make the timeline easy to read.

How to Create a Gantt Chart in Excel 2013

To create a Gantt chart in Excel 2013, prepare task names, start dates, and durations, then turn them into a stacked bar chart. You will use the first series to position each task and the second series to display its length.

Step 1: Prepare your project schedule

Start with a simple worksheet containing three columns:

• Task
• Start date
• Duration

Enter one task per row. Use real Excel dates in the Start date column, rather than text that only looks like a date.

Duration means the number of calendar days represented by each task. If a task runs from April 3 through April 7, its duration is five days.

Here’s why: Excel positions the first chart series using date values. It displays the second series as the visible task bar.

Step 2: Add a stacked bar chart

Highlight the Task, Start date, and Duration columns, including their headings. Then follow these commands:

1. Select the Insert tab.
2. Choose Bar in the Charts section.
3. Select 2-D Bar.
4. Choose Stacked Bar.

Excel will create two colored sections for each task. One section represents the starting position. The other represents the task duration.

The chart may look unusual at first. That is normal because both series are visible before you format the starting-position series.

Step 3: Put the tasks in the correct order

Excel often places the first task at the bottom of a bar chart. A project timeline usually reads more naturally with the first task at the top.

To reverse the order:

1. Right-click the vertical task axis.
2. Select Format Axis.
3. Find the axis options.
4. Enable Categories in reverse order.

Excel may move the horizontal date axis to the top after you reverse the categories. This is expected.

If the chart becomes difficult to follow, adjust the plot area or resize the chart. A wider chart gives longer task names and dates more room.

Step 4: Hide the starting-position series

Now remove the color from the Start date series. This makes each Duration bar appear to begin on its correct date.

1. Click one of the left-side colored sections.
2. Right-click and choose Format Data Series.
3. Open the Fill options.
4. Select No fill.
5. Open the border options.
6. Select No line.

The first series still exists, but it becomes invisible. The visible Duration series now forms the actual Gantt bars.

Let me explain: the hidden series acts like empty space before each task. Without it, every bar would begin at the same point.

Step 5: Format the date axis

The horizontal axis may show numbers instead of familiar dates. Excel stores dates as serial numbers, so you need to format the axis.

1. Right-click the horizontal axis.
2. Select Format Axis.
3. Open the Number section.
4. Choose a date format such as 3-Apr.
5. Close the formatting panel.

You can also set the minimum and maximum bounds. Use the earliest start date as the minimum and a date after the final task as the maximum.

For example, if your project begins on April 1, set the minimum near April 1. If your last task ends on May 10, set the maximum near May 10 or May 12.

Step 6: Improve the task bars

Default bars may have large gaps between them. Reducing the gap width makes the timeline easier to read.

1. Click a visible task bar.
2. Right-click and select Format Data Series.
3. Find Gap Width.
4. Reduce the percentage until the bars look balanced.

A gap width between 30% and 60% often works well. The best setting depends on the chart size and the number of tasks.

You can also choose a consistent fill color. Use a darker shade for normal tasks and a contrasting shade for milestones or high-risk activities.

Step 7: Add finishing details

Remove anything that distracts from the schedule. You may want to delete the legend because the hidden Start date series no longer needs explanation.

Then consider these improvements:

• Rename the chart with a clear project title.
• Resize the chart so task names remain readable.
• Add vertical gridlines for easier date tracking.
• Use a different color for completed tasks.
• Highlight major milestones with a short duration.
• Check that every task appears in the correct order.

The best part? You now have a reusable timeline. Change a start date or duration, and Excel updates the chart automatically.

How the Excel Gantt Chart Works

A Gantt chart is a horizontal timeline that shows when tasks begin, how long they last, and how work overlaps. Excel 2013 does not include a dedicated Gantt chart button, so you create one with a stacked bar chart.

The chart uses two values for every task. The Start date series creates spacing before the bar. The Duration series creates the visible activity.

Think of the first series as invisible runway. If a task begins five days after the project starts, Excel leaves five days of empty space before showing its colored bar.

Start dates and durations have different jobs

A start date tells Excel where to place a task. A duration tells Excel how long to draw it.

For example, a task starting on April 8 with a duration of seven days begins after the earlier timeline space. Its visible bar then stretches across seven calendar days.

If you accidentally enter an end date instead of a duration, the chart will show the wrong length. Subtract the start date from the end date when you need to calculate duration.

Calendar days versus working days

The basic method counts calendar days. That means weekends appear inside the timeline.

If your team works only Monday through Friday, use a working-day calculation for duration. Excel’s NETWORKDAYS function can count weekdays between two dates.

For example, a task running from Monday through Friday has five working days. A task spanning a weekend may have seven calendar days but only five working days.

Choose one approach and use it consistently. Mixing calendar and working days makes the visual schedule misleading.

How to Keep the Timeline Accurate

A chart is only useful when its underlying schedule remains accurate. Small inconsistencies can create large misunderstandings, especially when several activities overlap.

Use one date format throughout

Choose one readable format, such as 1-Apr-25, and apply it to every start date. Mixed formats can make dates difficult to scan.

Check that Excel recognizes each entry as a date. A quick test is to change the cell format to General. A recognized date usually becomes a serial number.

Review duration calculations

When you know the start and finish dates, calculate the duration instead of typing it manually.

For calendar days, use a formula such as:

=FinishDate-StartDate+1

The added one counts both the first and last day. Without it, a task beginning and ending on the same day may show zero days.

Mark milestones clearly

Milestones are important events rather than long activities. Examples include approval, launch, inspection, or release.

Give a milestone a one-day duration and use a contrasting color. This keeps it visible without creating an oversized bar.

Common Uses for an Excel 2013 Timeline

An Excel Gantt chart works well for small projects where one person or a small team maintains the schedule. It can support event planning, website launches, product improvements, training programs, and office renovations.

Example: planning a website launch

Imagine a launch with five activities: requirements, design, development, testing, and release preparation.

The chart immediately shows whether testing begins before development finishes. It also reveals whether release preparation has enough time before the target date.

That visual connection is more useful than reading five separate rows of dates.

Example: managing overlapping work

Suppose design begins on April 1 and development starts on April 6. Their bars overlap for several days.

This may be intentional, or it may reveal a resource conflict. If one person handles both activities, the overlap deserves attention.

A schedule view helps you spot that issue before it turns into a missed deadline.

When Excel may become limiting

Excel works well for a straightforward timeline. Complexity grows when you need automatic dependencies, several project owners, approval history, workload balancing, or frequent status updates.

For example, changing one task may require you to inspect several later tasks manually. A dedicated project platform can connect those relationships more directly.

Practical Improvements for Clearer Project Planning

You can make a basic Gantt chart more useful without making it complicated. The goal is to help someone understand the schedule in a few seconds.

Use a simple visual system

Choose one color for planned work, one for completed work, and one for risks or delays. Avoid using a different color for every task.

Too many colors create visual noise. A small team can usually understand three or four status colors quickly.

Add a status column

Include a Status column beside your schedule. Use labels such as Not started, In progress, Complete, and At risk.

You can apply conditional formatting to make each status easier to scan. The chart then shows timing, while the status column shows progress.

Protect the formulas

If several people update the worksheet, protect formula cells and leave only planning fields editable. This reduces accidental changes to duration calculations or chart preparation.

Keep a separate copy before making major changes. That gives you a safe point to return to when formatting or formulas go wrong.

Natural Project Timeline Solution: ONES.com

Excel 2013 is useful for a lightweight timeline, while ONES.com supports broader project and knowledge management needs. ONES Project is a Jira alternative for teams that need connected planning, execution, reporting, and workflow control.

ONES.com also includes ONES Wiki as a Confluence alternative. The products are sold separately, so you can choose the project management or knowledge management capability your team needs.

Value Proposition

ONES.com helps you move beyond manually maintained timelines when projects require shared workflows, live status visibility, and structured team collaboration.

It supports cloud, on-premise, private cloud, and air-gapped deployments. The free plan supports up to 30 seats.

Core Capabilities

1. Manual schedule maintenance

Pain: A chart in Excel needs manual updates when dates, owners, or task states change.

ONES capability: ONES Project centralizes project tasks, statuses, assignments, and workflow stages.

Result: Your team can view current work without rebuilding a chart after every schedule change.

2. Limited workflow control

Pain: A basic timeline may show when work happens, but it does not enforce how work moves forward.

ONES capability: You can create custom workflows for reviews, approvals, development, testing, and release activities.

Result: Tasks follow a visible process instead of relying on separate messages or personal reminders.

3. Weak dependency visibility

Pain: Overlapping bars can suggest a relationship, but they do not fully explain which task blocks another.

ONES capability: ONES Project supports Jira-compatible workflows and structured task relationships.

Result: Teams can manage dependencies within the project process rather than interpreting a static visual.

4. Limited reporting

Pain: Excel charts often require manual summaries for progress, workload, or delayed activities.

ONES capability: Built-in reporting provides project visibility across tasks and workflow states.

Result: You spend less time preparing updates and more time addressing risks.

5. Too many extensions

Pain: Adding every missing planning function through separate extensions can increase maintenance work.

ONES capability: ONES Project includes custom fields, automation, sprint management, and reporting in one project environment.

Result: Your team can reduce dependence on multiple plugins for everyday project operations.

6. Deployment restrictions

Pain: Some teams cannot place project information in a public cloud environment.

ONES capability: ONES.com supports on-premise, private cloud, and air-gapped deployment options.

Result: Teams in restricted environments can use structured project workflows while meeting internal hosting requirements.

7. Separate project and knowledge work

Pain: Planning details may become disconnected from requirements, decisions, and team guidance.

ONES capability: ONES.com combines project management and knowledge management, with ONES Project and ONES Wiki available separately.

Result: Teams can connect execution practices with the information needed to complete work correctly.

8. Uneven platform requirements

Pain: A team may need a hosted environment today and a self-managed environment later.

ONES capability: ONES.com provides feature parity between its cloud and self-hosted versions.

Result: Your workflows can remain consistent when deployment needs change.

Application Scenarios

Software delivery: A development team can manage sprints, custom fields, automation, testing states, and release workflows in one project environment.

Restricted-network projects: An organization with air-gapped requirements can use a self-hosted deployment while maintaining structured project practices.

Knowledge-heavy work: A team can use ONES Project for execution and ONES Wiki for procedures, requirements, and internal guidance.

Common Challenges

Challenge 1: The bars begin on the wrong dates

Cause: Excel may be treating dates as text, or the Start date series may not be included correctly.

Solution: Re-enter the dates using a consistent format. Confirm that Excel recognizes them as dates, then check the chart’s selected range.

Challenge 2: Tasks appear upside down

Cause: Bar charts commonly place the first category at the bottom.

Solution: Open the vertical axis settings and enable Categories in reverse order. Review the chart afterward because Excel may move the date axis.

Challenge 3: The chart shows numbers instead of dates

Cause: Excel stores dates as serial values and may display those values on the axis.

Solution: Format the horizontal axis as a date. Choose a short format that remains readable at the chart’s current width.

Challenge 4: The schedule ignores weekends

Cause: Basic duration values count calendar days.

Solution: Decide whether the project uses calendar days or working days. Use a weekday calculation when weekends should not count.

Challenge 5: The chart becomes difficult to maintain

Cause: Many tasks, owners, dependencies, and revisions can exceed what a manually maintained worksheet handles comfortably.

Solution: Use a structured project platform when your team needs shared workflows, live reporting, automation, or controlled deployment.

FAQs

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

Yes. You can build one manually with a stacked bar chart. Prepare task names, start dates, and durations first. Then insert a stacked bar chart, reverse the task order, hide the Start date series, and format the date axis. This approach gives you more control than a template and helps you understand how the timeline works.

Why do I need to hide one series?

The hidden series creates the empty space before each task begins. Excel uses the Start date value to position the visible Duration bar. If both series remain colored, the chart shows two bars for every task. Removing the fill from the Start date series leaves only the useful task duration visible.

Can Excel show task dependencies?

Excel can suggest timing relationships through overlapping bars, but it does not automatically manage dependencies like a dedicated project platform. You can add predecessor columns and formulas, but updates require careful maintenance. For a small plan, that may be sufficient. Larger projects usually need stronger workflow and dependency controls.

How do I show progress on the chart?

Add a Progress column with percentages, then create another series representing completed work. Format that series with a darker color and place it over the planned duration. This approach takes additional setup and can become difficult when tasks change frequently. A status column may be simpler for small schedules.

Can I use working days instead of calendar days?

Yes. Use a working-day calculation for task duration when weekends should not count. You can also account for holidays by including a holiday range in the calculation. Make sure every task uses the same calendar logic. Otherwise, the visual length of tasks will not accurately reflect the team’s available working time.

Conclusion

Creating a Gantt chart in Excel 2013 requires seven core actions: prepare your schedule, insert a stacked bar chart, reverse the task order, hide the Start date series, format the date axis, improve the bars, and add finishing details.

But here’s the truth: the chart is only as reliable as the dates, durations, and planning rules behind it. Use consistent calendars, check formulas, and mark milestones clearly.

For a small project, Excel can provide a practical visual timeline. When your work needs shared workflows, reporting, automation, or controlled deployment, ONES.com offers a broader project management environment through ONES Project.