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

Building a Gantt chart in Excel 2013 can feel harder than it should. You may have tasks, deadlines, and team members ready, yet the blank worksheet gives you no clear starting point. Then come the formatting problems: dates appear as serial numbers, bars refuse to align, and progress becomes difficult to read.

That frustration can turn a simple planning task into an afternoon of trial and error. A small mistake in the date axis may shift every task bar. An incorrect chart type can make your schedule look like a stack of unrelated columns.

But here's the solution: create a stacked bar chart, hide the start-date series, and format the remaining series as task bars. This guide walks you through seven practical steps for creating a clear Gantt chart in Excel 2013.

How to Build a Gantt Chart in Excel 2013

A Gantt chart in Excel 2013 is a horizontal timeline that shows when each task starts, how long it lasts, and how tasks overlap. Excel does not include a dedicated Gantt chart button in this version. You can create one by combining a task list with a stacked bar chart.

The method uses three key values:

• Task: The activity you want to schedule.
• Start date: The day the activity begins.
• Duration: The number of days the activity continues.

For example, a website redesign might include planning for five days, design for ten days, development for fifteen days, and testing for seven days.

Here's why this approach works: the hidden start-date series creates empty space before each task bar. The visible duration series then appears in the correct position on the timeline.

Step 1: Prepare the Project Schedule

Start with a simple schedule in an Excel worksheet. Use one row for each task and keep the headings short.

Enter real Excel dates in the Start Date column. You can type a date such as 4/1/2013, then apply a date format through the Home tab.

Keep duration values as whole numbers. A duration of 10 means the task lasts ten calendar days on the chart.

Place the task names in the first column. Avoid leaving blank rows between activities because Excel may treat them as extra categories.

Step 2: Select the Schedule Values

Highlight the Task, Start Date, and Duration columns, including their headings. Do not include unrelated notes or totals.

If your schedule occupies cells A1:C5, select that range. The first row should contain the headings, while the remaining rows should contain your activities.

You can select the range by dragging across the cells. You can also click the first cell, hold Shift, and select the final cell.

Here's a useful check: every task should have a matching start date and duration. Missing values can create gaps or misleading bars.

Step 3: Insert a Stacked Bar Chart

With the schedule selected, open the Insert tab on the Excel ribbon.

1. Choose Bar from the Charts group.
2. Select 2-D Bar.
3. Choose Stacked Bar.

Excel creates a chart with two colored series. One series represents the start dates. The other represents task durations.

The first version may look confusing because Excel often places the earliest task at the bottom. The horizontal axis may also display large numbers instead of familiar calendar dates.

That appearance is temporary. You will correct the task order, hide the start-date series, and format the date axis in the next steps.

Step 4: Reverse the Task Order

Gantt charts usually show the first task at the top. Excel 2013 may display the categories in the opposite order.

To reverse them:

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

The task list should now read from the first activity at the top to the final activity at the bottom.

Excel may move the horizontal date axis to the top after you reverse the categories. That is normal. You can leave it there or adjust the axis position later.

Step 5: Hide the Start-Date Series

The start-date series creates the space before each duration bar. It needs to remain in the chart, but it should become invisible.

Click one of the left-hand colored segments in the chart. These segments usually represent the start dates.

1. Right-click the selected series.
2. Choose Format Data Series.
3. Open Fill.
4. Select No fill.
5. Open Border Color.
6. Select No line.

The start-date series disappears visually. The duration bars remain in place, creating the familiar Gantt chart appearance.

Let me explain the visual effect: the invisible segment pushes each task bar across the timeline. A task starting later receives a longer invisible section before its visible bar.

Step 6: Format the Date Axis

The horizontal axis may show numbers such as 41365 instead of dates. Excel stores dates as serial numbers, so you need to change the axis display.

1. Right-click the horizontal axis.
2. Choose Format Axis.
3. Open Number.
4. Choose a date format such as mmm d or m/d.
5. Set the minimum bound to the earliest project start date when needed.
6. Set the maximum bound slightly after the final task ends.

For example, a project running from April 1 through May 7 may need an axis beginning around April 1 and ending around May 10.

Use a major unit of seven days if you want weekly spacing. Use a major unit of one day for short schedules requiring daily precision.

Avoid squeezing a six-month schedule into a narrow chart. The labels will overlap, and the task relationships will become difficult to interpret.

Step 7: Improve the Chart for Daily Use

Once the chart displays correctly, make small formatting changes that improve readability.

• Give the chart a clear title, such as Website Redesign Schedule.
• Choose one strong color for the duration bars.
• Remove the legend if the hidden start-date series creates confusion.
• Adjust the chart height so every task has enough space.
• Reduce the gap width to make bars thicker.
• Use consistent date formats throughout the worksheet.
• Add milestone markers separately when a key event has no duration.

To change the gap width, right-click a visible task bar and select Format Data Series. Lower the gap percentage until the bars look substantial without touching each other.

The chart is now ready for planning. Change a start date or duration in the worksheet, and Excel updates the visual schedule.

What the Chart Shows

A finished Gantt chart communicates three details quickly: the order of activities, the length of each activity, and the amount of overlap between activities.

Suppose design begins on April 6 and development begins on April 16. The chart makes that relationship visible without requiring someone to read every date in the worksheet.

The horizontal position shows timing. The bar length shows duration. The vertical position shows the task sequence.

The best part? You can spot scheduling pressure at a glance. If four long bars occupy the same period, your team may need more capacity or a revised plan.

Start Dates and Durations Work Together

Excel calculates the visual position from the start date. It calculates the visible bar length from the duration value.

Changing a start date moves the bar along the timeline. Changing a duration extends or shortens the bar.

For example, changing testing from seven days to twelve days extends its bar without moving its starting position. Changing its start date shifts the entire bar.

This separation gives you a simple way to model schedule changes without rebuilding the chart.

Calendar Days Versus Working Days

The basic method uses calendar days. A duration of five includes every day in the sequence, including weekends.

If your project runs only Monday through Friday, calculate working-day durations separately. You can use Excel functions such as NETWORKDAYS for working-day counts.

For example, a task beginning Monday and ending Friday has five working days. A task spanning Saturday and Sunday still has five working days if those days are excluded.

Choose one calendar approach and apply it consistently. Mixing calendar days with working days can make the chart appear ahead of or behind the real schedule.

How to Add Milestones and Progress

A standard Gantt chart shows task duration. You can extend it with milestone markers and progress indicators when your project needs more detail.

Adding a Milestone

A milestone represents an event with little or no duration, such as approval, launch, or final review.

Create a separate milestone series with a date value. Then add that series to the chart as a marker.

In Excel 2013, this may require a combination chart. Use an XY scatter series or a column series, depending on the visual result you want.

For a simple schedule, you can also add a text box or shape aligned with the milestone date. This works well when the chart has only a few important events.

Showing Task Progress

To show progress, add a second duration value for completed work. For example, a task may have a total duration of ten days and a completed duration of six days.

You can create a second stacked bar series for completed duration. Use a darker color for completed work and a lighter color for remaining work.

Keep progress values consistent with the total duration. A completed value greater than the total can distort the chart.

A progress view is useful during weekly reviews. You can see which tasks are moving and which tasks remain unchanged.

Common Excel 2013 Gantt Chart Problems

Most chart issues come from three areas: incorrect selection, incorrect formatting, or inconsistent dates. The symptoms are usually easy to recognize.

The Bars Begin at the Same Point

If every task starts at the same horizontal position, Excel may be using task numbers instead of real dates.

Check the Start Date column first. Select a date cell and look at the formula bar. A valid date should behave like a numeric value when you change its format.

If the entries are stored as text, re-enter them using a recognized date format. Then recreate the chart or update the series range.

The Tasks Appear in Reverse Order

This happens because Excel charts categories from the bottom upward. Right-click the vertical axis and select Categories in reverse order.

Check the result after applying the setting. The first activity should appear at the top, and the final activity should appear at the bottom.

The Date Labels Are Hard to Read

Dense labels usually mean the chart is too narrow or the major unit is too small.

Widen the chart, reduce the number of labels, or use weekly intervals. A three-month schedule rarely needs a label for every day.

The Visible Bars Have Strange Colors

You may have formatted the start-date series instead of the duration series. Click the visible bar carefully and confirm the selected series name.

Keep the start-date series transparent. Apply the strongest color to the duration series because it carries the schedule meaning.

When Excel 2013 Is Enough

Excel 2013 works well for a small project with a limited number of tasks and one person maintaining the schedule.

For example, a six-week marketing campaign with twelve activities can remain manageable in one workbook. You can update dates, print the chart, and share a revised version during a meeting.

The approach becomes harder when several people edit the plan, tasks depend on one another, or progress changes daily. Manual updates can create conflicting versions and missed changes.

You might be wondering: when should you move beyond a worksheet chart? Consider a dedicated project platform when you need ownership, permissions, task discussions, automated reminders, or live reporting.

Project Planning Solution: ONES.com

ONES.com combines project management and knowledge management in one platform. ONES Project provides project planning features as a Jira alternative, while ONES Wiki supports team knowledge management as a Confluence alternative.

If your Excel 2013 schedule has grown into a shared planning process, ONES.com can help you manage tasks, workflows, reporting, and team collaboration in one environment.

Value Proposition

ONES.com helps you move from manually maintained timeline charts to structured project workflows. You can keep planning details connected to tasks, teams, approvals, and project progress.

Core Capabilities

1. Scattered task planning → Structured project workspaces → Clear ownership

When tasks sit across separate worksheets, responsibility can become unclear. ONES Project organizes work into projects, issues, task views, and assigned owners.

Each activity can have a responsible person, status, priority, and deadline. Your team gains a clearer view of who handles each part of the plan.

2. Manual timeline updates → Sprint management → More predictable delivery

Changing dates by hand can make a chart outdated quickly. ONES Project includes sprint management for teams that plan work in repeated delivery cycles.

You can group work into sprints, track completion, and review progress against planned goals.

3. Rigid planning rules → Custom workflows and fields → Better process fit

A basic chart may show dates without capturing approvals, risk levels, or review states. ONES Project supports custom workflows and custom fields.

You can create stages such as Planned, In Review, Approved, In Progress, and Completed. Additional fields can capture business details relevant to your team.

4. Plugin-heavy project setups → Native project capabilities → Lower maintenance effort

Teams often add multiple extensions when their planning tool lacks reporting, automation, or workflow features. ONES Project includes built-in reporting, automation, custom workflows, and sprint management.

This native capability can reduce the need to connect many separate plugins for everyday project work.

5. Limited visibility → Built-in reporting → Faster project reviews

An Excel chart can show timing, yet it may require manual preparation for status meetings. Built-in reporting gives teams a repeatable way to review progress.

Managers can examine trends, workload, completion, and project status without rebuilding a presentation every week.

6. Complex Jira migration concerns → Jira-compatible workflows → Smoother adoption

Teams looking for a Jira alternative may worry about changing established practices. ONES Project supports Jira-compatible workflows.

This can make it easier to carry familiar issue and workflow concepts into a new project environment.

7. Online-only requirements → On-premise and private deployment options → More control

Some teams cannot place project information in a public cloud environment. ONES.com supports Cloud, On-Premise, Private Cloud, and Air-gapped deployments.

The self-hosted version maintains full feature parity with the cloud version. That gives restricted or regulated teams more deployment flexibility.

8. Disconnected project knowledge → ONES Wiki → Easier access to guidance

Project teams often need requirements, process notes, meeting decisions, and technical guidance near their work. ONES Wiki provides a knowledge management space as a Confluence alternative.

Keeping project activity and team knowledge within the same platform can reduce the time spent searching across separate systems.

Application Scenarios

Growing software team

A software team may begin with an Excel Gantt chart for a small release. As bugs, reviews, and sprint commitments increase, ONES Project can organize each work item by status, owner, and sprint.

The team can retain workflow visibility while reducing manual chart maintenance.

Restricted-network engineering group

An engineering group working in a restricted environment may need project planning without public cloud access. An air-gapped or on-premise ONES.com deployment can support that requirement.

The team can manage workflows and reporting within its approved environment.

Cross-functional product launch

A product launch may involve marketing, design, engineering, compliance, and support. ONES Project can assign work across teams, while ONES Wiki can hold launch guidance and decisions.

This creates a connected planning space for activities that would otherwise remain scattered across separate tools.

Common Challenges and Practical Solutions

Challenge: Dates display as serial numbers

Solution: Format the horizontal axis as a date. Right-click the axis, open Format Axis, choose Number, and select a readable date pattern.

Also check that your start dates are recognized as dates. Text that looks like a date may not behave like a real date in Excel.

Challenge: The chart becomes crowded

Solution: Divide a large schedule into phases or use weekly axis labels. You can also increase the chart height and reduce unnecessary labels.

For example, create separate views for Planning, Build, Testing, and Launch when one chart contains dozens of activities.

Challenge: Task changes are easy to miss

Solution: Add a Last Updated column and assign one person to maintain the schedule. Use a consistent review time each week.

For collaborative work, a project platform can provide ownership, status history, and workflow notifications.

Challenge: Dependencies are unclear

Solution: Add a Predecessor column that identifies the activity each task depends on. Then review whether a delayed activity affects later work.

Excel can display the schedule, but it does not automatically manage complex dependency logic as effectively as dedicated project software.

Challenge: The chart prints poorly

Solution: Set the page orientation to Landscape, adjust the print area, and use a readable scale. Preview the result before printing.

Keep the chart title and date labels visible. A chart that looks clear on screen may become difficult to read on paper.

FAQs

Does Excel 2013 have a built-in Gantt chart template?

Excel 2013 does not provide a dedicated Gantt chart type in the standard chart menu. You can create one with a stacked bar chart using task names, start dates, and durations. The start-date series remains in the chart as an invisible spacer, while the duration series becomes the visible task bar. This method works without special add-ins.

Why do my Excel Gantt chart bars start at the same position?

The Start Date values may be stored as text, or Excel may have selected the wrong chart orientation. Check that each date is recognized as an Excel date. Then confirm that the start dates form one series and durations form another. A valid start-date series creates the horizontal spacing that places each task at the correct point on the timeline.

Can I create a Gantt chart for working days only?

Yes. You can calculate working-day durations with Excel functions such as NETWORKDAYS. You may also need to calculate working-day offsets when positioning tasks. This requires more setup than a calendar-day chart. Define whether weekends and holidays count before building the schedule, then use the same rule for every task.

How can I show task completion in an Excel Gantt chart?

Add a completed-duration value alongside the total duration. Then create another stacked bar series for completed work. Use one color for completed time and another for remaining time. Keep the completed value within the total duration. Review the progress values regularly because the chart will only be accurate when those values are maintained.

When should I use project management software instead of Excel?

Excel is suitable for smaller schedules with limited collaboration. Consider project management software when you need dependencies, recurring workflows, permissions, automated reminders, sprint planning, or live reports. A dedicated platform also helps when several people update the plan and you need a consistent view of ownership and progress.

Can ONES.com replace an Excel Gantt chart?

ONES.com can support project planning through ONES Project, including workflows, sprint management, automation, custom fields, and reporting. It is a Jira alternative for teams that need broader project control. ONES.com also offers Cloud, On-Premise, Private Cloud, and Air-gapped deployment options. You can use ONES Wiki separately for team knowledge management as a Confluence alternative.

Conclusion

To build a Gantt chart in Excel 2013, prepare task names, start dates, and durations. Insert a stacked bar chart, reverse the task order, hide the start-date series, format the date axis, and improve the layout.

The process works well for small schedules and simple planning needs. You can extend the chart with milestones, progress indicators, working-day calculations, and project phases.

But here's the practical limit: manual charts need regular maintenance. As your team, workflow, and reporting needs grow, a project platform can provide stronger control.

Excel gives you a quick visual timeline today. ONES.com gives you a path toward structured project management when your schedule becomes a shared operational process.