How to Make a Gantt Chart in Excel (2026)
Excel has no native Gantt chart, but you can build a clean one from a stacked bar chart in five steps. This guide walks through the whole build — from data setup to formatting for presentation.
⚡ Quick Answer
Set up 3 columns: Task, Start date, Duration. Insert stacked bar chart. Format the Start series with No Fill (invisible). Reverse the Y-axis so tasks read top-down. Done.
Step 1: Set up the data
Three columns:
Task Start Duration
Research 2026-01-01 14
Design 2026-01-15 21
Development 2026-02-05 35
Testing 2026-03-12 14
Launch 2026-03-26 7
Duration is in days. If you have Start and End dates, compute Duration with =EndDate - StartDate.
Step 2: Insert a stacked bar chart
Select the range
Include headers and all three columns.
Insert tab → Bar chart icon → Stacked Bar
Note: bar, not column. Bar = horizontal, which is what we need.
Excel inserts a stacked bar chart
Two series stacked: Start (which we'll make invisible) and Duration (which becomes the visible bar).
Step 3: Make the Start series invisible
The Start series is only there to push the visible bars to the right position on the timeline. Make it invisible.
Click a Start series bar
Selects the whole Start series.
Right-click → Format Data Series
Panel opens on the right.
Fill → No Fill
Series becomes invisible.
Border → No Line
Removes any outline.
Step 4: Reverse the Y-axis order
By default Excel puts the first task at the bottom. Gantt charts read top-down.
Right-click the Y-axis (task labels)
Format Axis panel opens.
Tick "Categories in reverse order"
Under Axis Options.
Y-axis flips
First task is now at the top. Tasks read chronologically top-to-bottom.
Step 5: Format the X-axis as dates
The X-axis probably shows numbers (Excel serial dates). Format them properly.
Right-click X-axis → Format Axis
Panel opens.
Set minimum bound
Set to your project start date (or a bit earlier). Enter as a date; Excel converts to serial number.
Set maximum bound
Project end date or a bit later.
Number format → Date
Format code:
mmm ddormm/ddfor compact dates.
Step 6: Polish for presentation
Chart title
Rename to something descriptive: "Q1 2026 Product Launch Timeline"
Remove legend
Only one series is visible; the legend is useless. Delete it.
Add data labels (optional)
Click the Duration series → Add Data Labels. Format to show the task name or duration inside each bar.
Color code by category
Click a specific bar (second click on a specific data point). Change its fill color to categorize (e.g., research = blue, design = purple, dev = green).
Add a "today" line
To show current date on the timeline:
- Add a helper column with
=TODAY()repeated for each task row - Add that column as a new series to the chart
- Change it to a Line chart type
- Format the line vertical and colored
Showing progress on a Gantt
Add a fourth data column: =Duration * PctComplete. Add this as another stacked series.
Now each task has three stacked segments: invisible Start, completed portion (solid color), and remaining portion (lighter shade or hatched). Instant progress visualization.
Excel Gantts work well up to ~30-50 tasks. Beyond that, use Smartsheet, Microsoft Project, or a real PM tool. Excel's chart mechanics were never designed for enterprise project scheduling.
Once you build a Gantt that looks right, save it as a chart template (right-click chart → Save as Template). For future projects, right-click → Change Chart Type → Templates → your Gantt. Instant.
Gantt charts without the setup
The stacked-bar-with-invisible-Start trick is clever but tedious. Excel Wizard builds Gantt charts from task lists automatically — you provide tasks with start dates and durations, it structures the data, inserts the chart, and formats it. No manual bar-hiding required.
Install Excel Wizard →Frequently asked questions
How do I make a Gantt chart in Excel?
Excel doesn't have a native Gantt chart. Build one from a stacked bar chart with two series — Start (invisible, no fill) and Duration (visible). The invisible Start series pushes each bar to the correct starting position.
What data do I need for a Gantt chart?
Three columns: Task name, Start date, and Duration (in days). Optional: End date, Assigned to, Status. Duration can be calculated from Start and End dates using =End-Start.
How do I add dependencies to an Excel Gantt chart?
Excel doesn't natively support Gantt dependencies. Workarounds: draw connector lines manually using Insert → Shapes; use conditional formatting to link related tasks; or switch to Smartsheet or a dedicated PM tool if dependencies are essential.
Can I show progress on a Gantt chart in Excel?
Yes. Add a third data series for completed duration (Duration × % Complete). Chart it as another stacked bar in a different color. You'll see the completed portion filled and remaining as a lighter shade.