A Gantt chart is one of the most effective tools for project planning and management. By creating a Gantt chart in Excel, you can visually represent tasks, timelines, and progress, allowing for a better understanding of project schedules and status updates at a glance.
If you need to start tracking immediately without building a chart from scratch, check out our
Simple Gantt Chart Templates
for a quick, professional setup.
How to Create a Gantt Chart in Excel
While Excel doesn’t offer a built-in “Gantt” chart type, you can easily use a Stacked Bar Chart to achieve the same result. Setting it up might seem technical at first, but once you follow these steps, it becomes an indispensable tool for managing any project. Here is our step-by-step guide to building your own Excel Gantt chart.
- Prepare your data table: Organise Tasks, Start Dates, and Durations.
- Populate your data: Input your project-specific timelines.
- Insert a Stacked Bar Chart: Use the Start Date series as your foundation.
- Add the Task Duration: Overlay the task lengths onto the chart.
- Format for clarity: Hide the “placeholder” bars and fix the task order.
Step 1: Prepare Your Data Table
To build a functional Gantt chart, your data must include three key elements: Task Name, Start Date, and Duration. We recommend converting your data range into an Excel Table (Ctrl + T) so your chart updates automatically when you add new rows.
| Task | Start Date | Duration (Days) |
|---|---|---|
| Initial Research | 2023-08-01 | 40 |
| Concept Design | 2023-08-08 | 35 |
| Development Phase | 2023-08-15 | 55 |
| Beta Testing | 2023-08-05 | 35 |
| Final Deployment | 2023-08-29 | 20 |
Step 2: Populate the Data
Enter your actual project timelines. To create an advanced Gantt chart, you can include extra columns like Responsible Person, Progress %, or Status. While these won’t all appear in the bar chart initially, they are essential for your project tracking logs.
| Task | Responsible | Start Date | Duration | Progress | Status |
|---|---|---|---|---|---|
| Task Title 1 | John Doe | 2023-08-01 | 40 | 100% | Completed |
| Task Title 2 | Jane Smith | 2023-08-08 | 50 | 100% | Completed |
| Task Title 3 | Mary Johnson | 2023-08-15 | 25 | 80% | Ongoing |
Step 3: Insert a Stacked Bar Chart
Highlight the Tasks and Start Date columns. Navigate to the Insert tab, click on the Bar Chart icon, and select Stacked Bar Chart. This will plot your start dates along the timeline.
Step 4: Add Task Duration to the Chart
Now, we need to add the bars that represent the actual work duration:
- Right-click on the chart and select Select Data.
- Click Add. For Series Name, select the “Duration” header.
- For Series Values, select the duration numbers in your table.
Step 5: Format the Axis and “Hide” the Start Dates
This is the “Magic Step” that makes it a true Gantt chart:
- Reverse the Order: Right-click the vertical axis (Task Names), select Format Axis, and check “Categories in reverse order.”
- Make Bars Invisible: Click on the first set of bars (the Start Dates). Right-click, select Format Data Series, and in the “Fill” section, choose No Fill.
Download Gantt Chart Excel Templates
Excel’s flexibility makes it a preferred tool for project managers. Use the templates below to see exactly how the formatting and axis settings are applied.
We hope you find this guide helpful! If you’re looking for even more advanced features like automated task dependencies or automated color-coding, don’t forget to visit our Simple Gantt Chart Templates page. Let us know your feedback in the comments!