How to Make a Gantt Chart in Excel (Step-by-Step)
Build a Gantt chart in Excel with a stacked bar: set up tasks and dates, hide the Start series, reverse categories, and fix the date axis — plus when to use a template instead.
You already have the task list in a spreadsheet. What you lack is a timeline leadership can read in one glance. Learning how to make a gantt chart in excel with a stacked bar chart is the classic path — no add-in required, no new login.
This walkthrough follows the same pattern Microsoft Support and popular tutorials teach: Task + Start + Duration → Stacked Bar → hide the Start fill → reverse categories → tighten the date axis. If you would rather choose a pre-built file than format charts, start with our excel gantt chart template selection guide.
More spreadsheet guides live in our template guides and tips.
Key takeaway: To make a Gantt chart in Excel: build a task table with start dates and durations, insert a stacked bar chart, set the Start series to No Fill, reverse category order, then set horizontal axis bounds to your project dates.
What You Will Build
Excel does not ship a chart type named "Gantt." Microsoft Support is explicit: you simulate a Gantt by customizing a stacked bar chart so the left portion of each bar (the start offset) becomes invisible and the right portion (duration) shows as the task bar.
Expect a working timeline for a few dozen tasks. You will not get automatic dependency shifting or multiplayer editing — those limits matter when you decide later whether to stay in Excel or move to software (covered in our gantt chart excel software guide).
DIY Excel Gantt
- Create columns: Task Name, Start Date, End Date (optional), Duration
- Calculate Duration with a consistent formula
- Insert a 2-D Stacked Bar chart using Task, Start, and Duration
- Format Start series → No Fill / No Line
- Format vertical axis → Categories in reverse order
- Format horizontal axis → Date number format + min/max bounds
- Remove clutter (legend, chart title) if the sheet already labels the project
Step 1: Lay Out Task Data
Open a blank sheet. In row 1 enter:
- A: Task Name
- B: Start Date
- C: End Date (optional but useful)
- D: Duration (Days)
Enter tasks in chronological or WBS order. Format B and C as Date. In D2 use either =C2-B2 or =C2-B2+1 — TeamGantt notes that +1 counts both start and end calendar days. Pick one rule for the whole file.
Optional columns that pay off later: % Complete, Assigned To, Priority, Predecessor. Keep them off the chart series list for now so Excel does not invent extra bars.
Step 2: Insert a Stacked Bar Chart
Select Task Name, Start Date, and Duration (use Ctrl/Cmd to multi-select non-adjacent columns if End sits between them). Go to Insert → Charts → Bar → Stacked Bar.
If Excel grabs the wrong series, right-click the chart → Select Data. You want two series: Start Date and Duration, with Horizontal Axis Labels pointing at Task Name.
TechnologyAdvice sometimes converts dates to General before charting, then converts back — useful when Excel plots serial numbers instead of calendar ticks. If your axis shows 45000-style values, fix Number format on the axis to Date after the chart exists.
Step 3: Format Bars Into a Gantt
Click the Start portion of any bar (usually the left color). On Format, set Shape Fill → No Fill and remove the border. The duration segments now float at the correct offset — that is your Gantt.
Right-click the vertical axis (task names) → Format Axis → check Categories in reverse order so Task 1 sits at the top like a project plan, not the bottom like a default bar chart.
Delete the legend if it only says "Start Date" and "Duration" — stakeholders do not need that chrome. Keep a short chart title with the project name if you paste the chart into slides.
Step 4: Fix Dates, Order, and Print Layout
Right-click the horizontal axis → Format Axis:
- Number → Date (readable format)
- Bounds → Minimum = project start (or a few days earlier), Maximum = project end
- Major unit → 7 for weeks, ~30 for months
Warning: If bars look shifted, check that Start cells are real dates (not text) and that Duration matches your +0/+1 convention.
For printing: set a print area that includes both the task table and chart, or move the chart to its own sheet. Freeze panes under the header row so task names stay visible while you scroll dates in the table.
Optional Upgrades: Progress, Milestones, Predecessors
Progress: Split Duration into Completed (=Duration*%Complete) and Remaining. Chart series order: invisible Start → Completed → Remaining with two related fills.
Milestones: One-day tasks with a distinct bar color. Diamond shapes look nice in decks but do not move automatically when dates change.
Predecessors: A text/WBS column is enough documentation in Excel. Formulas that auto-push successor starts exist, but they are brittle — most small teams update dates by hand and note the dependency.
When these upgrades turn into a weekly maintenance tax, a structured template or online Gantt tool is usually cheaper than another hour of chart babysitting.
When a Template Beats DIY
Build from scratch when you are learning, teaching a teammate, or customizing a one-off visual. Download a template when you need labeled rows, weekly columns, and a Start Here sheet before the next meeting.
Free libraries from Microsoft Create and Smartsheet cover many cases. For a structured PlanoraNest workbook with weekly bars and dependency-ready inputs, see the Gantt Chart Excel Template — one-time purchase, instant download; check the product page for live pricing. Selection criteria live on the pillar guide.
Sample Mini Project You Can Copy
Use a five-task website launch as practice data before you touch a real client plan:
| Task | Start | End | Duration | | Kickoff brief | 2026-08-10 | 2026-08-11 | 2 | | Wireframes | 2026-08-12 | 2026-08-15 | 4 | | Visual design | 2026-08-16 | 2026-08-20 | 5 | | Build pages | 2026-08-21 | 2026-08-30 | 10 | | QA and launch | 2026-08-31 | 2026-09-03 | 4 |
Enter those rows exactly, build the chart, then change Wireframes end date forward three days. Watch whether Duration formulas and bars still agree. That single experiment teaches more than reading another screenshot.
If the bars refuse to move, your chart series range is probably locked to the old rows — reopen Select Data and include the full table. Save a named version (Website_Gantt_practice.xlsx) so you can reset without rebuilding formatting.
When the practice file feels boring, that is the signal you are ready for a template: the mechanics are no longer the bottleneck — labeled columns and weekly grids are.
Keep a Working Copy and a Snapshot Copy
After the chart looks right, duplicate the sheet or the whole workbook before every steering meeting. Name the working tab Plan_Live and the freeze tab Plan_2026-07-12. Stakeholders who only need a picture can receive a PDF of the snapshot; editors keep editing Plan_Live.
This habit prevents the classic failure mode where someone "helpfully" changes dates on the only copy five minutes before the call. It also gives you a crude history without SharePoint version archaeology.
If you collaborate in OneDrive or Google Drive, still keep snapshots. Cloud version history helps after disasters; named snapshots help during normal reviews when you need to say "here is what we promised last Friday."
Frequently Asked Questions
Can I turn an Excel spreadsheet into a Gantt chart? Yes. Organize Task, Start, and Duration columns, insert a stacked bar chart, hide the Start series fill, and reverse the category axis.
Is Excel good for Gantt charts? Excel works well for small plans with one primary editor. It is weaker for live multi-user edits and automatic dependency shifting.
Is there a free Gantt chart template in Excel? Search File > New for Gantt or project timeline, or download free files from Microsoft Create and Smartsheet. Structured shops sell one-time-purchase workbooks too.
Does Microsoft have a Gantt chart tool? Microsoft Project includes native Gantt views. Excel relies on templates or stacked-bar formatting, as Microsoft Support documents.
How long does a DIY Excel Gantt take? A simple chart can take about 15 minutes once you know the steps; first-time builds often take longer because of axis formatting.
