Gantt Chart Template: Plan Projects in Sheets or Excel

A Gantt chart turns a messy to-do list into a visual timeline: every task becomes a horizontal bar, positioned by start date and stretched by duration. One glance tells you what's happening this week, what's late, and which tasks depend on each other. It's the single most useful planning artifact for a small business owner juggling a product launch, a store build-out, or a client project.

The good news: you don't need Microsoft Project or a paid tool. You can build a working Gantt chart in Google Sheets or Excel in about 15 minutes, and you can start from a free template that does most of the setup for you.

How do I make a Gantt chart?

Here's the short answer, then we'll walk through both tools in detail.

A Gantt chart is really a stacked bar chart in disguise. You give the spreadsheet two numbers per task: how many days after the project's start the task begins (the offset), and how long it lasts (the duration). You then plot both as a stacked horizontal bar and make the "offset" portion invisible. What's left is a colored bar floating at the right spot on the timeline. That's your Gantt bar.

Neither Google Sheets nor Excel has a native "Gantt chart" button, so this stacked-bar technique is the standard method both Microsoft and Google recommend. Below is the exact process for each.

Step 1: Build your task table

Whatever tool you use, start with the same columns. Open a blank sheet and enter:

Keep tasks in the order they start. If you're mapping out a company from scratch, this list often mirrors the steps in /how-to-start-a-business/ - registration, banking, and setup all become rows here.

Add one more helper column, Start Offset, which is the number of days between the project's first start date and each task's start date. In the cell for the first task's offset, subtract the earliest start date from that task's start date. For row two it might be =B3-$B$2, and so on. This offset is what positions each bar along the timeline.

How to make a Gantt chart in Google Sheets

Google Sheets is the easiest option because it's free and shareable. Here's the build.

Insert a stacked bar chart

1. Select your Task, Start Offset, and Duration columns (including headers).
2. Go to Insert > Chart.
3. In the Chart editor, open the Chart type dropdown and choose Stacked bar chart.

You'll see two-color bars: one segment for the offset, one for the duration.

Hide the offset segment

This is the trick that turns a bar chart into a Gantt chart:

1. In the Chart editor, click the Customize tab, then Series.
2. Select the Start Offset series from the dropdown.
3. Set Fill opacity to 0%.

The offset segment vanishes, leaving each task's duration bar floating at the correct start position. Fix the reversed order (Sheets lists the first task at the bottom by default) by reversing your rows or flipping the axis, and you have a finished Gantt chart. This stacked-bar-with-transparent-offset method is exactly what template guides from TeamGantt and Coefficient walk through.

Or just copy a template

If you'd rather skip the setup, copy a pre-built Google Sheets Gantt template, replace the sample tasks with yours, and the chart updates automatically. Most free templates use the same underlying formula structure described above, so you can still tweak colors and dates without breaking anything.

How to make a Gantt chart in Excel

The Excel process mirrors Google Sheets, with slightly different menu labels.

1. Build the same task table with a Start Offset helper column.
2. Highlight your task names and start dates, then go to Insert > Bar > Stacked Bar.
3. Right-click the chart, choose Select Data, and add your Duration as a second series.
4. Click the blue Start Offset bars, open the format pane, and set the fill to No fill - this hides the offset just like the 0% opacity trick in Sheets.
5. Right-click the vertical axis, choose Format Axis, and check Categories in reverse order so your first task sits at the top.

Microsoft's own template gallery (File > New) includes a few basic project-timeline files, but none are fully interactive Gantt charts, so the stacked-bar build or a free third-party template like Vertex42's is usually the better route. Forbes Advisor and Microsoft both document this same approach.

Turning the template into a real plan

A chart is only as good as the thinking behind it. Before you fill in dates:

• Break work into tasks small enough to see progress weekly. A bar that says "Launch business" and spans three months tells you nothing. "Finalize supplier contracts" over five days is trackable.
• Sequence dependencies. If ordering inventory can't start until the bank account is open, stagger those bars. Mapping who owns each task pairs well with a /raci-matrix-explained/, which assigns responsibility so no bar sits ownerless.
• Tie milestones to goals. Each phase should ladder up to an outcome. Writing those outcomes as /smart-goals-guide/ keeps your timeline honest instead of aspirational.
• Add buffer. Real projects slip. Pad durations by 10-20% rather than planning to the day.

Color-code by phase or owner, and consider a "% complete" column you can shade to show progress - a simple conditional format does this in both tools.

When a spreadsheet isn't enough

Spreadsheet Gantt charts are perfect for solo founders and small teams running one or two projects. They break down when you need automatic dependency shifting (move one task and everything downstream reschedules), team assignments, resource loading, or many overlapping projects.

At that point, a dedicated tool earns its cost. If your business is scaling past a handful of concurrent projects, compare options in our guide to the /best-project-management-software/ - most include drag-and-drop Gantt views that recalculate dependencies for you. But for planning a launch or mapping your first quarter, the free template does the job.

Conclusion

A Gantt chart is nothing more than a stacked bar chart with the offset hidden - and once you understand that, you can build one in Google Sheets or Excel from scratch or from a free template in minutes. Start with a clean task table, add a start-offset helper column, plot the stacked bar, and make the offset transparent. That's the whole trick.

Grab a free template, drop in your real tasks and dates, and you'll have a project timeline you actually look at. When your workload outgrows a spreadsheet, upgrade to dedicated software - but not a moment before you need to.

---

Sources: TeamGantt - Google Sheets Gantt Chart Template, Coefficient - How to Make a Gantt Chart in Google Sheets, Forbes Advisor - Gantt Chart Excel Template, Vertex42 - Free Gantt Chart Template for Excel