How to make a Gantt chart in Excel — step by step, and when to switch

Excel is where most plans actually live. Here's how to turn one into a Gantt chart — and the faster route when that chart has to go on a slide.

Excel is where most project plans actually live — a tab of tasks, start dates and durations that you keep more or less up to date. Turning that into a Gantt chart is a natural next step, and Excel can do it. The friction shows up later, when the chart has to leave the spreadsheet and land on an executive slide.

Here are the two ways to build a Gantt in Excel, honestly — then where each one stops being worth the effort.

Method 1 — The stacked bar chart

This produces real proportional bars, which is what most people picture when they say “Gantt chart”.

1. Lay out three columns: Task, Start date, and Duration (in days). One row per task.
2. Select the range and insert a Stacked Bar chart (Insert → Charts → Bar → Stacked Bar).
3. Click the Start date series → format it with No Fill. That invisible series offsets each bar to its start date, so only the Duration bars show.
4. Right-click the vertical (category) axis → Format Axis → tick Categories in reverse order so task 1 sits at the top.
5. Tighten the date axis: set its minimum and maximum to the serial numbers of your project's start and end dates so the bars fill the width.
6. Recolor the bars to your palette, add data labels, and drop a thin vertical shape for the “today” line.

Where Excel runs out of road

The Excel Gantt is fine for you. It struggles the moment it has to become a presentation:

• It's not slide-shaped. The chart is sized for a spreadsheet; pasted into PowerPoint it's either a fuzzy image or a live object that breaks when someone opens the deck without your data.
• No dependencies. Move a task and nothing downstream follows — every knock-on date is manual.
• Default styling looks like a spreadsheet. Getting it to boardroom quality means fighting Excel's chart defaults every time.
• No drill-down. Execs want 5–7 phases; the delivery team wants every task. In Excel that's two separate sheets that drift apart.
• Brand colors are manual. Recolor each series by hand, and it drifts from the program deck.

The faster route: keep Excel, change the last step

You don't have to abandon Excel — it's a fine place to keep the raw plan. Change only the last step: instead of wrestling Excel's chart engine, paste the same rows into a purpose-built Gantt tool and export an editable PowerPoint slide. That's what GANTT360° does:

• Paste straight from Excel. Copy your Task / Start / End / Owner columns and paste — the tasks appear instantly, dependencies and all. (It also imports .xlsx/.csv files directly, parsed in your browser — nothing is uploaded.)
• Auto-reflow. Drag one bar and every dependent task cascades — no manual date-fixing.
• Drillable phases. One chart collapses to phases for the exec view and expands to every task for the team.
• Editable .pptx export. Real grouped PowerPoint shapes, not an image — recolor and edit text after export.
• On-brand automatically. Per-folder themes keep every chart on the program palette.

How to choose

• You're tracking a small plan for yourself: the Excel stacked-bar or grid method is plenty.
• The chart has to go in front of executives, on-brand, and get updated regularly: keep planning in Excel, but build and export the presentation Gantt in a dedicated tool.

The dividing line is simply how often the chart is seen. If it's a recurring exec slide, the two-minute paste-and-export beats re-styling an Excel chart every cycle. See the same trade-off for building a Gantt in PowerPoint, or paste your Excel plan in and export a slide now.