Question 1

How does the GanttChart sheet auto-generate bar colors?

Accepted Answer

The 65-column GanttChart sheet uses conditional formatting rules combined with date-comparison formulas. Each weekly column checks whether the task's start and end dates fall within that week's range. If yes, the cell fills with the bar color. A second rule shades completed portions differently based on the % Complete value — so you can visually distinguish work done from work remaining directly on the Gantt bars.

Question 2

Can I change the timescale from weekly to daily or monthly?

Accepted Answer

The template defaults to weekly columns, but you can modify the column headers and formulas to switch to daily or monthly granularity. For daily view, add more columns and update the date formulas. For monthly view, consolidate weeks into month blocks. The Help sheet (98 rows of documentation) includes step-by-step instructions for changing the timescale.

Question 3

What is the GanttChartPro sheet and do I need it?

Accepted Answer

The GanttChartPro sheet is a preview of the Google Sheets Pro edition, which adds advanced features like automated dependency lines, critical path highlighting, and resource loading views. It is included for reference — if the standard GanttChart sheet meets your needs, you can ignore or hide the Pro sheet. There is no upsell popup or lock; it is purely informational.

Question 4

How do I handle tasks that span more than 52 weeks?

Accepted Answer

The template has 65 total columns on the GanttChart sheet, with the weekly columns covering approximately one year at weekly granularity. For projects longer than 52 weeks, you can insert additional week columns by copying the formula pattern rightward, or switch to a monthly timescale (each column = 1 month) to cover a longer horizon with fewer columns.

Question 5

Can I add task dependencies or predecessors?

Accepted Answer

The standard GanttChart sheet does not include built-in dependency logic (Finish-to-Start, etc.) — it is a manual scheduling template. You can add a "Predecessor" column and enter task IDs that must finish before the current task starts, but the dates will not auto-shift. For automatic dependency scheduling, the GanttChartPro edition (Google Sheets) adds this feature.

Question 6

Is this compatible with Microsoft Project import/export?

Accepted Answer

While not a direct MS Project converter, you can use this template alongside MS Project. Export your Project tasks to Excel (File > Export > Save as Excel), then map the columns (Task Name, Start, Finish, Duration, Resource) to the corresponding columns on the GanttChart sheet. The bars will generate based on the imported dates. Reverse workflow: build your schedule here first, then import into MS Project if needed.

Sheet	What it does
Start Here	Quick-start guide with navigation tips, setup instructions, and a tour of the Gantt chart layout. Read this first to understand how the workbook fits together.
GanttChart	The main scheduling sheet with 65 columns across 51 task rows. Enter your Project Name at the top, set the Project Start Date and Display Week number. Core columns include: Task ID, Task Name, Start Date, End Date, Duration (days), Assigned To, % Complete, and weekly time-phased columns (Week 1 through Week 52+) that auto-fill with color-coded bars based on your dates. Conditional formatting distinguishes completed segments from remaining work. The far right column shows the copyright footer.
Help	Comprehensive 98-row reference sheet covering how to add/remove tasks, adjust the timeline scale, customize colors, troubleshoot bar display issues, and adapt the template for different project types.
GanttChartPro	A preview and upgrade path to the Google Sheets Pro edition with enhanced features. Details what the Pro version adds over the standard template.
About	Template credits, version info, and terms of use.

Gantt Chart Excel Template

Who it's for

What's included — sheet-by-sheet

Preview

Preview 1

Preview 2

Preview 3

Preview 4

How to use this template

Works with

Frequently asked questions

How it works

Customer reviews