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

Planning a project in Excel 2013 can become confusing quickly. Tasks, dates, durations, and dependencies often sit in separate cells without showing how the work fits together.

A plain schedule may tell you when a task starts, but it rarely reveals delays, overlaps, or the project’s critical path at a glance. That makes progress tracking harder than it needs to be.

But here’s the truth: you can create a clear Gantt chart in Excel 2013 without downloading special software. You only need a task list, accurate dates, a stacked bar chart, and a few formatting adjustments.

This guide walks you through seven practical steps. By the end, you will have a timeline that makes responsibilities, timing, and progress easier to understand.

How to Prepare a Gantt Chart in Excel 2013: 7 Steps

A Gantt chart in Excel 2013 is a horizontal timeline that shows project tasks as bars across calendar dates. Excel does not offer a dedicated Gantt chart button in this version, so you create one with a stacked bar chart.

The first series positions each task on the timeline. The second series displays the task duration. After hiding the positioning series, the remaining bars look like a standard Gantt chart.

1. Set up the project schedule

   Open a blank Excel workbook and create four columns with these headings:

   • Task
   • Start Date
   • Duration
   • Finish Date

   Enter one task per row. For example, a website launch plan might include planning, design, development, testing, and launch.

   Task	Start Date	Duration	Finish Date
   Project planning	01/06/2025	3	03/06/2025
   Interface design	04/06/2025	7	10/06/2025
   Development	11/06/2025	12	22/06/2025
   Testing	23/06/2025	5	27/06/2025
   Launch	28/06/2025	1	28/06/2025

   Use real Excel dates in the Start Date column. Avoid typing dates as descriptive text, because Excel may not recognize them as calendar values.

   For Finish Date, you can calculate the result with a formula such as =B2+C2-1, assuming the start date sits in column B and duration sits in column C.

2. Check the date and duration values

   Before creating the visual, check your schedule carefully. A chart can only be as reliable as the dates and durations behind it.

   Confirm that each start date uses the same format. You might choose dd/mm/yyyy or mm/dd/yyyy, depending on your regional settings.

   Then check whether durations use calendar days or working days. A five-day task could mean five consecutive days or five business days.

   Here’s why: a project beginning on Friday will look very different when weekends count compared with a schedule that excludes them.

   If you need working-day calculations, Excel 2013 supports the WORKDAY function. For example, =WORKDAY(B2,C2-1) can calculate a finish date using weekdays.

3. Select the task, start date, and duration columns

   Highlight the Task, Start Date, and Duration columns. Include the headings, but leave Finish Date outside the chart selection.

   For example, if your schedule occupies columns A through D, select columns A, B, and C. The chart needs task names, starting positions, and bar lengths.

   Do not select only the task and duration columns. Without the Start Date series, every bar begins at the same position.

   You might be wondering: why does the chart need both a start date and a duration?

   The start date creates the empty space before each task. The duration creates the visible bar. Together, they position and size every activity.

4. Insert a stacked bar chart

   With the required columns selected, open the Insert tab in Excel 2013.

   1. Choose Bar from the Charts group.
   2. Select 2-D Stacked Bar.
   3. Wait for Excel to create the chart.

   Excel may initially display the dates as large serial numbers. That is normal. Excel stores calendar dates as numbers, and the formatting comes later.

   The chart should contain two colored series. One represents Start Date, while the other represents Duration.

   The task labels may appear in reverse order. You can fix that after adjusting the horizontal axis.

5. Hide the Start Date series

   The Start Date series is only a positioning mechanism. You do not want it visible in the finished Gantt chart.

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

   In the formatting panel, select Fill, choose No Fill, and then select Border followed by No Line.

   The Start Date portion should disappear, leaving the Duration bars floating at their correct calendar positions.

   But here’s the truth: hiding this series does not remove it. Excel still uses it to place every visible task correctly.

6. Format the axes and task labels

   Now make the chart easier to read. Click the vertical task axis and choose Format Axis.

   Enable Categories in reverse order if your first task appears at the bottom. This places the opening activity at the top.

   Next, click the horizontal date axis. Set a suitable minimum and maximum bound, such as the project’s first and final dates.

   Excel may display the bounds as serial numbers. You can still enter recognized dates, or use the corresponding numeric values shown by Excel.

   Adjust the major unit to control the scale. A major unit of one displays daily intervals. A value of seven creates weekly intervals.

   For a six-month plan, weekly or monthly intervals usually create a cleaner view than daily marks.

7. Improve the design and add project context

   Click the visible Duration bars and choose a color that stands out against the chart background.

   Reduce the gap width to make the bars thicker. Right-click the bars, choose Format Data Series, and adjust Gap Width.

   Add a clear chart title, such as Website Launch Schedule. You can also add axis titles if the audience needs more context.

   Remove unnecessary chart elements. Excessive gridlines, legends, and borders can distract from the timeline.

   The best part? A simple chart is often more useful than a heavily decorated one. Keep the task labels readable and the date scale easy to follow.

How the Excel Gantt Chart Works

The chart uses two stacked values for every task. The first value is the number of days between Excel’s starting point and the task’s beginning. The second value is the task duration.

Imagine a task beginning on June 11 and lasting twelve days. The Start Date series pushes the visible bar forward to June 11. The Duration series then draws the bar across twelve calendar units.

Once the first series becomes transparent, only the duration bar remains visible. This creates the familiar Gantt chart appearance.

Let me explain the visual logic with a simple comparison:

This approach works because Excel treats dates as numerical values. The stacked bar chart can therefore place each task accurately along the time axis.

How to Show Dependencies and Milestones

A basic Gantt chart shows timing, but it does not automatically explain why one task must wait for another. You need to make those relationships visible through planning and formatting.

For example, development may begin only after interface design finishes. If design ends on June 10, development should start on June 11 unless your team allows overlap.

You can add a Dependency column to your schedule. Enter values such as “Planning” or “Design complete” to explain the relationship between activities.

For milestones, create a short task with a duration of one day. A launch, approval, inspection, or handoff can appear as a narrow bar on the timeline.

You can also create a separate milestone series. Use a duration of zero or one, then apply a contrasting color. A diamond shape requires additional formatting, so a narrow colored bar is usually simpler in Excel 2013.

Here’s why dependencies matter: if design slips by three days, development may also move unless another team can begin early.

How to Track Progress in the Chart

Excel 2013 does not provide automatic progress tracking in this chart setup. You can still show progress by adding a second duration calculation.

Add columns named Planned Duration, Percent Complete, and Completed Duration. Then calculate completed work with a formula such as:

=C2*E2

In this example, C2 contains the planned duration and E2 contains the completion percentage. Format the percentage as a value between 0% and 100%.

You can create another stacked bar series for Completed Duration. Apply a darker shade to completed work and a lighter shade to the remaining duration.

For example, a ten-day task at 60% completion can show six days in dark blue and four days in light blue.

This method gives you a useful visual indicator, but remember to update the percentage regularly. An outdated progress value can create false confidence.

Practical Formatting Tips for a Clear Timeline

A well-built chart should answer three questions quickly: what needs to happen, when will it happen, and which activities are at risk?

Choose a useful time scale

Daily intervals suit short projects, such as a two-week event plan. Weekly intervals usually work better for monthly projects. Monthly intervals suit longer programs.

If the chart looks crowded, change the major unit instead of shrinking the entire chart. More space does not solve a confusing time scale.

Use colors with a purpose

Choose one main color for ordinary tasks. Reserve another color for milestones, delayed work, or high-priority activities.

For example, blue can represent planned work, green can show completed work, and orange can highlight activities requiring attention.

Keep task names short

Long labels can make the chart difficult to scan. Use “Approve wireframes” instead of “Obtain final approval for all website interface wireframes.”

If a task needs more explanation, add notes beside the chart or maintain a separate planning area.

Protect the original schedule

Save a clean version before making major design changes. Then create a working copy for formatting and progress updates.

This gives you a safe recovery point if a chart series becomes misaligned or a formula changes unexpectedly.

Natural Project Scheduling Solution: ONES.com

Value Proposition

For a small project, Excel 2013 can create a useful visual timeline. When many people need to update tasks, dependencies, approvals, and progress, a dedicated platform such as ONES.com can reduce manual coordination.

ONES.com combines project management and knowledge management, while ONES Project serves as a project management platform and Jira alternative. ONES Project and ONES Wiki are sold separately.

Core Capabilities

• Scattered task updates → ONES Project centralizes work items and ownership → Teams can see responsibilities without repeatedly rebuilding a chart.
• Manual timeline adjustments → Built-in reporting and visual project views → Managers can review schedule health with less manual formatting.
• Rigid task fields → Custom workflows and custom fields → Teams can capture approval status, risk level, department, or release information.
• Complex sprint planning → Sprint management tools → Agile teams can plan iterations, assign work, and review unfinished tasks.
• Repeated status changes → Automation capabilities → Routine transitions and notifications can require fewer manual updates.
• Plugin-heavy Jira environments → Jira-compatible workflows with native capabilities → Teams can preserve familiar processes while reducing reliance on multiple add-ons.
• Restricted deployment requirements → Cloud, On-Premise, Private Cloud, and Air-gapped options → Organizations can select an environment that fits their security needs.
• Different capabilities across deployment types → Full feature parity between cloud and self-hosted versions → Teams can choose deployment flexibility without giving up core functions.
• Separate project knowledge → ONES Wiki knowledge management → Teams can connect planning guidance, decisions, and project context with their work.

Application Scenarios

A software team moving beyond a simple Excel schedule could use ONES Project for backlog planning, sprint management, custom workflows, and release reporting. Instead of manually coloring overdue bars, the team can review work status through project views and reports.

An engineering organization with restricted network requirements could choose an On-Premise, Private Cloud, or Air-gapped deployment. This supports controlled access while preserving the same core feature set available in the cloud version.

A cross-functional launch team could use ONES Project for tasks and ONES Wiki for planning guidance, meeting decisions, and operating procedures. Keeping those areas connected can reduce repeated questions during delivery.

ONES.com offers a free plan for up to 30 seats. That can give a small team room to test a structured workflow before deciding whether a larger rollout fits its needs.

Common Challenges When Creating a Gantt Chart in Excel 2013

The bars start at the same position

Problem: Every task begins at the left edge, so the chart does not reflect actual start dates.

Solution: Confirm that the Start Date column is included in the stacked bar chart. Then hide that series with No Fill and No Line.

The task order appears upside down

Problem: The final task appears at the top, while the opening task sits at the bottom.

Solution: Right-click the vertical axis, open Format Axis, and enable Categories in reverse order.

The horizontal axis shows strange numbers

Problem: Excel displays values such as 45600 instead of recognizable calendar dates.

Solution: Open Format Axis and set the number format to a date format. Adjust the minimum, maximum, and major unit values afterward.

Weekends create unexpected timelines

Problem: A task expected to take five working days appears to cover seven calendar days.

Solution: Decide whether your schedule uses calendar days or working days. Use the WORKDAY function when weekends should not count.

The chart becomes difficult to read

Problem: Too many tasks, colors, labels, and gridlines make the timeline overwhelming.

Solution: Use one main task color, shorten labels, adjust the time scale, and group minor activities when appropriate.

FAQs About Preparing a Gantt Chart in Excel 2013

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

Excel 2013 does not include a dedicated Gantt chart type in the standard chart menu. You create one by using a stacked bar chart, then hiding the Start Date series. Some templates may be available through Excel’s template library, but the stacked bar method gives you more control over task dates, durations, colors, and axis settings.

Why do I need a stacked bar chart?

A stacked bar chart lets you combine two values for each task. The Start Date value creates the empty space before the task begins, while the Duration value creates the visible bar. Once the Start Date portion becomes transparent, the duration bar appears in the correct calendar position. A regular bar chart cannot create this positioning effect as easily.

Can I include weekends in the schedule?

Yes. If the Duration column counts calendar days, weekends remain part of each task. If you want working-day planning, calculate finish dates with the WORKDAY function and define your working pattern clearly. For example, a five-day activity beginning on Monday can end on Friday when weekends are excluded. Always tell viewers which calendar rule the chart follows.

How can I show a task that is already partly complete?

Add a Percent Complete column and calculate Completed Duration by multiplying the planned duration by the completion percentage. Then add completed duration as another chart series, using a darker color. A ten-day task at 40% completion would show four completed days. Update the percentage during status reviews so the visual remains useful.

Can Excel 2013 show task dependencies automatically?

The basic stacked bar method does not automatically draw dependency lines. You can add a Dependency column to explain relationships, or use shapes and connectors for a small number of links. If a project has many changing dependencies, dedicated project management software may be easier to maintain than manual chart annotations.

Conclusion

Preparing a Gantt chart in Excel 2013 requires seven main actions: create a schedule, verify dates, select the right columns, insert a stacked bar chart, hide the Start Date series, format the axes, and improve the design.

Use calendar rules consistently, keep task labels concise, and update progress values regularly. A simple chart can reveal overlaps, gaps, milestones, and timing risks within seconds.

But here’s the truth: Excel works best for smaller plans that need a quick visual timeline. As task relationships, contributors, approvals, and reporting needs grow, a dedicated platform such as ONES Project may provide a more maintainable workflow.

You can start with the seven-step method today, then move to a structured project management environment when manual updates begin slowing the team down.