How to Build a Gantt Chart in Excel from Scratch

 

A Gantt chart is a project management chart that shows tasks against a timeline. It helps you see when each task starts, how long it lasts, and where different tasks overlap. Excel doesn’t have a built-in Gantt chart type, but you can build a fully functional one using a Stacked Bar Chart.

In this tutorial, we will show the steps to build a Gantt chart in Excel from scratch. Let’s create a clean, professional Gantt chart with some formatting tricks.

Step 1: Set Up Your Project Data Table

• First, create a table containing the task name, start date, and duration
• Enter dates as actual Excel dates (not text), so calculations work correctly
• List tasks in the order you want them to appear from top to bottom in the chart (Excel charts plot bottom-to-top by default, so the first row ends up at the bottom; we’ll fix that later)
• Calculate End Date with the formula (the -1 makes the end date inclusive)

=B2+C2-1

Step 2: Insert a Stacked Bar Chart

• Select your Task, Start Date, and Duration columns
• Go to the Insert tab >> from the Charts group >> click the Bar Chart icon
• Under 2-D Bar >> choose Stacked Bar

This inserts a chart with two series stacked on top of each other for each task: one for Start Date and one for Duration. At this point, the chart will not yet look like a Gantt chart.

Step 3: Correctly Add the Start Date Series

Now replace the default category numbers with the actual task names.

• Click the chart
• Go to the Chart Design tab >> click Select Data
• Check the Legend Entries (Series) box:
  • If “Duration” is already listed, leave it
  • If “Start Date” is missing (or shows up wrong), click Add

• Set:
  • Series name: Start Date column header cell (e.g. B1)
  • Series values: Start Date data range (e.g. B2:B7)

• Look at Horizontal (Category) Axis Labels, click Edit

• Select cells A2:A7 >> click OK
• Use the up/down arrows above the series list to make sure Start Date is listed first and Duration second; order matters, since Excel stacks them in that sequence
• Click OK

You should now see two stacked segments per bar: a solid color for Start Date and another for Duration. The vertical axis should show clean task names only, with no date clutter.

Step 4: Make the “Start Date” Bars Invisible

This is the trick that turns a stacked bar chart into a Gantt chart. The first segment (Start Date) becomes invisible, leaving only the Duration segment visible, which appears to “float” at the correct starting point.

• Click on the Start Date series in the chart to select it
• Right-click >> select Format Data Series

• In the Fill & Line panel:
  • Under Fill >> select No fill
  • Under Border >> select No line

Now only the blue Duration bars are visible, and they appear to start at the correct date. The chart now begins to look like a proper Gantt chart.

Step 5: Format the Date Axis

By default, the horizontal axis will show numbers rather than a clean date range, and the chart may not align well with your project timeline.

• Click on the horizontal axis (bottom of the chart)
• Right-click >> select Format Axis

• Under Axis Options, set:
  • Minimum: the serial number of your earliest start date (or type the date directly, e.g. 7/1/2026)
  • Maximum: the project’s end date
  • Major unit: 1 day, 1 week, or whatever granularity fits your timeline
  • For example, setting the Major unit to 7 produces weekly intervals
• Optionally, go to Number and set the format to a short date (dd-mmm) so the axis reads clearly

Step 6: Reverse the Task Order (Top-to-Bottom)

Excel plots the first row of your data at the bottom of the chart by default. To make your task list read top-to-bottom like a real Gantt chart:

• Click on the vertical axis (the task names)
• Right-click >> select Format Axis
• Check Categories in reverse order

• This will also flip the horizontal axis to the top of the chart. To move it back to the bottom, go to Horizontal Axis Crosses >> select Maximum category

Step 7: Clean Up the Chart

• Remove the Legend: Click it and press Delete (it’s not needed since there’s only one visible series).
• Add a Chart Title: Click the title placeholder and type something like “Project Timeline — [Project Name]”.
• Adjust Bar Width: Select the Duration bars >> select Format Data Series >> set Gap Width to around 50–75% for thicker, more readable bars.
• Add Data Labels (Optional): Select the Duration bars >> click the Chart Elements (+) button >> check Data Labels.
• Color-Code by Phase (Optional): Select individual bars and change their fill color to represent categories (e.g. planning, development, testing) for quick visual grouping.

Step 8: Make It Dynamic (Optional but Recommended)

To make your Gantt chart automatically update as you edit the data:

• Format your source data range as an Excel table
• Go to the Insert tab >> select Table, or press Ctrl+T

• Tables auto-expand, so new tasks added to the bottom of the list will automatically appear in the chart

• Use a formula-driven Duration or % Complete column, and consider adding a Percent Complete stacked segment (a third series) inside each Duration bar to show progress
• Shade the completed portion darker and the remaining portion lighter

Conclusion

By following the steps above, you can build a Gantt chart in Excel from scratch. The Start Date series controls where each task begins, while the Duration series determines the length of its visible bar. Whenever you update a task’s Start Date or Duration in the source table, the Gantt chart will update automatically, making it useful for tracking project schedules, content calendars, product launches, and other time-based plans. Building it manually gives you full control over formatting and behavior that a locked template won’t.