How to Make a Gantt Chart in Excel (2 Easy Methods)

Excel has no “Gantt chart” button, but you can build one in about 10 minutes. There are two ways: a stacked bar chart (best for a clean picture to put in a report) and a conditional formatting grid (best for a plan you update every week). Both use the same simple task table. Prefer to skip the building? Download our free automatic Gantt chart template.

Step 1: Set up your task table

Start with four columns. Enter real dates in Start and End, then calculate Duration:

A: Task B: Start C: End D: Duration
2 Agree goals 1 Dec 2026 3 Dec 2026 3
3 Write content 4 Dec 2026 12 Dec 2026 9
4 Design and build 7 Dec 2026 19 Dec 2026 13
5 Testing 20 Dec 2026 23 Dec 2026 4
6 Launch 24 Dec 2026 24 Dec 2026 1

Duration in D2: =C2-B2+1 (the +1 counts both the start and end day). Copy it down.

Method 1: Stacked bar chart

  1. Select A1:B6 (Task and Start), then go to Insert → Charts → Bar → Stacked Bar.
  2. Add the duration: right-click the chart → Select Data → Add. Series name: D1. Series values: D2:D6. Click OK twice.
  3. Hide the start bars: click the first (Start) series → Format Data Series → Fill → No fill. Only the duration bars remain, floating at the right dates.
  4. Put the first task at the top: click the task labels (vertical axis) → Format Axis → Categories in reverse order.
  5. Remove empty space on the left: click the dates (horizontal axis) → Format Axis → Bounds → Minimum. Type the first start date as a number: 1 Dec 2026 is 46357 (format a copy of the date cell as General to see its number). Set Maximum to 46387 (31 Dec 2026).
  6. Finish: set the Major unit to 7 for weekly gridlines, add a title, remove the legend, and reduce the Gap Width to about 50% for thicker bars.

Good for: a picture of the plan for slides and reports. Weak spot: it does not show progress or today’s date without extra work.

Method 2: Conditional formatting grid

  1. In F1 type the first date of the project (1 Dec 2026). In G1 type =F1+1 and copy it right for as many days as you need (for example to AJ1 for 31 days).
  2. Format row 1 as d (day number only) and make the columns narrow (about 3 wide).
  3. Select the grid F2:AJ6 → Home → Conditional Formatting → New Rule → Use a formula.
  4. Enter =AND(F$1>=$B2, F$1<=$C2), choose a fill colour and click OK. Each task now fills the days between its start and end.
  5. Add a today marker: new rule =F$1=TODAY() with a yellow fill, placed above the first rule.
  6. Shade weekends (optional): rule =WEEKDAY(F$1,2)>5 for Saturday–Sunday, or =OR(WEEKDAY(F$1)=6, WEEKDAY(F$1)=7) for a Friday–Saturday weekend, with a light grey fill.

Good for: a living project plan. Change a date and the bar moves instantly. This is how our Gantt chart template works, with progress shading and overdue alerts added.

Which method should you use?

Stacked bar chart Conditional formatting
Looks like A chart A coloured calendar grid
Best for Reports and presentations Day-to-day project tracking
Shows today / progress Needs extra work Easy with extra rules
Long projects Easy (change axis bounds) Many columns; switch to weeks

Tips

  • Keep tasks short (1–10 days). Long bars hide problems.
  • Use an Excel table (Ctrl + T) for the task list so new rows pick up formulas. See Excel tables.
  • Print on one page for meetings: how to print Excel on one page.
  • Google Sheets: Method 2 works the same way with Format → Conditional formatting → Custom formula.

FAQ

Does Excel have a Gantt chart template?
Excel has no built-in Gantt chart type, but you can build one with a stacked bar chart or conditional formatting, or download a free ready-made Gantt chart template.

How do I make a Gantt chart in Excel with dates?
Put Start and End dates in a table, calculate Duration with =End-Start+1, then create a stacked bar chart from Task and Start, add Duration as a second series and hide the Start bars.

Why does my Excel Gantt chart start in 1900?
The horizontal axis is starting at zero. Set the axis Minimum to your first start date as a number (for example 46357 for 1 Dec 2026).

Can I make a Gantt chart in Google Sheets?
Yes. Use the conditional formatting method with a custom formula, or upload our free template to Google Sheets.

Related guides

Leave a Comment