Quarterly Gantt Chart Excel Template: Free Options

Charts & pivot tables · Updated November 20, 2026

Yes. You can get a free quarterly Gantt chart template for Excel when one is available in a template library, or make one in a blank workbook with dates and conditional formatting. A simple sheet can show which quarters each task overlaps; it does not require a paid add-in or a special Gantt chart feature.

What a quarterly Gantt chart shows

A Gantt chart places tasks against a time scale so readers can see when work starts, how long it lasts, and where tasks overlap. A quarterly version uses one column per quarter rather than one column per day or week. For example, a 2026 schedule might have columns for Q1, Q2, Q3, and Q4, with a colored cell marking every quarter touched by a task.

This level of detail suits annual plans, portfolio reviews, product roadmaps, and projects where dates are still approximate. It is less useful for coordinating daily work: a task scheduled from March 30 to April 2 appears in both Q1 and Q2, even though it lasts only a few days. The chart communicates the broad planning window, not the exact duration within each quarter.

In Excel, this kind of display is usually a worksheet grid with conditional formatting, not a dedicated chart type called a quarterly Gantt chart. The cells act as the timeline, and a rule colors cells when a task’s dates overlap the quarter.

Where to find a free Excel template

Microsoft Create maintains a collection of templates, including Excel workbooks, but its catalog can change and may not always contain a template designed specifically for quarterly Gantt planning. Search its current Excel offerings for project schedules, timelines, or Gantt charts, then check whether the time scale can be changed to quarters. Excel files from other template publishers are another option, but free access, reuse rights, and features depend on the publisher’s terms.

You can also start with a blank workbook. That is often the clearest free option because you can choose the dates, task fields, colors, and level of detail yourself. Excel for the web is available with a Microsoft account, while desktop Excel for Microsoft 365 is generally part of a Microsoft 365 plan or other license. A free template file does not necessarily mean that the Excel application or every collaboration feature is free.

  • Check that the file opens as an Excel workbook, usually with an .xlsx extension.
  • Look for editable start and finish dates, not just a picture or a pre-filled example.
  • Review whether the template uses macros. A basic Gantt grid does not need them.
  • Read the site’s terms before using a template for commercial work or sharing it publicly.

A practical worksheet layout

For a compact annual overview, put task information in columns A through E and the four quarter-start dates in F1:I1. Use these task fields: A for task name, B for owner, C for start date, D for finish date, and E for status. Put actual Excel dates in the quarter header cells: January 1, April 1, July 1, and October 1 for the year being planned. Format C and D as dates so that they are easy to read and enter.

For a label row beneath the dates, with the quarter-start dates in F1:I1, enter this formula in F2 and fill it right through I2: ="Q"&ROUNDUP(MONTH(F1)/3,0)&" "&YEAR(F1). It returns Q1 2026 for a date of January 1, 2026, and the later cells return Q2 2026, Q3 2026, and Q4 2026. The dates in row 1 remain the underlying timeline values; row 2 is only a readable label. You can hide row 1 after setup if you prefer, since hiding it does not remove the dates used by the formatting rule.

Start task rows on row 3. Use one row per task and make sure the start and finish columns contain real Excel dates rather than date-looking text. If you want to list milestones, give them the same start and finish date; the chart will mark the quarter containing that date, though a separate milestone symbol may communicate the event more clearly.

Build the quarter bars with conditional formatting

In Excel for Microsoft 365 on Windows, select the timeline area for the tasks, such as F3:I20. Choose Home > Conditional Formatting > New Rule, then choose Use a formula to determine which cells to format. With task names in A3:A20, start dates in C3:C20, finish dates in D3:D20, and quarter-start dates in F1:I1, use this rule formula:

=AND($A3<>"",ISNUMBER($C3),ISNUMBER($D3),F$1<=$D3,EOMONTH(F$1,2)>=$C3)

Choose Format, select a fill color, and confirm the rule. The formula checks whether the task row has a name and valid dates, then tests whether the quarter starts on or before the task finish and ends on or after the task start. Those two overlap tests mean that even a partial-quarter task gets a colored cell. The row number adjusts for each task, while the header reference moves across the quarter columns.

For a concrete check, suppose row 3 is a website redesign with a start date of March 15, 2026, and a finish date of July 10, 2026. With quarter starts in F1:I1, the rule colors Q1, Q2, and Q3, but not Q4: the task overlaps March 15–31, all of Q2, and July 1–10. Format the range with borders or alternating row shading if adjacent tasks are hard to distinguish. In Excel for Mac, the conditional-formatting feature is also available; the dialog wording and layout can vary by release. Excel for the web supports conditional formatting, but its menus and rule editor may look different from the Windows desktop steps.

What the date logic does—and does not—mean

The rule treats start and finish dates as inclusive. A task ending on March 31 overlaps Q1, while one starting on April 1 overlaps Q2. A task that crosses a quarter boundary appears in both adjacent columns. That is appropriate for a planning overview, but it does not imply that the work fills every day in those quarters.

The EOMONTH part calculates the last day of the quarter from its first day: two months after January 1 is March 31, for example. This works when the header dates are quarter starts. If the headers are arbitrary dates, or the chart uses fiscal quarters that do not begin in January, adjust the header dates to the fiscal quarter starts and keep the same overlap logic. Avoid typing labels such as Q1 into the date row, because text labels cannot be compared reliably with task dates.

A quarterly grid also hides within-quarter sequencing. If Task B must begin only after Task A finishes, the colored bars alone do not show that dependency. Add a predecessor column, notes, or a finer monthly or weekly view when sequence and handoffs matter.

Choosing between a template and a custom sheet

A downloaded template is convenient when it already has the right fields, a useful legend, and a timeline that spans the planning period. A custom sheet is often easier to maintain if you need a particular fiscal year, several years, or organization-specific status categories. Before committing to either, try it with a few real tasks: one contained within a quarter, one crossing a boundary, and one that starts and ends on a boundary date.

  • Choose a ready-made workbook if its date range, labels, and instructions fit your use and you can edit its inputs.
  • Choose a blank workbook if you need a simple annual overview or want to avoid unfamiliar formulas, macros, and extra formatting.
  • Use a more detailed schedule if teams need week-level coordination, dependencies, resource assignments, or frequent progress updates.

Do not judge a template only by its colors or dashboard. Check how it handles dates, blank rows, tasks that span a year boundary, and edits to the planning period. A polished file can still be awkward if its timeline is fixed or its chart is made from pasted images instead of editable cells.

Common problems and useful improvements

If no bars appear, first check that the start and finish values are genuine dates and that the task name is not blank. Then inspect the conditional-formatting rule’s Applies to range: it should cover the quarter cells for all intended task rows, such as F3:I100. Confirm that the formula refers to the first cell of that range, F3, and to the dates in row 1. A rule entered with a different starting row can shift its references and produce unexpected results.

If every quarter is colored, check for empty or reversed dates and make sure the formula includes the task-name and date checks. A finish date earlier than the start date is a data problem, not a chart-formatting problem. You can prevent many such errors by using Data > Data Validation to require dates within an appropriate range, and by adding a clear note about the expected date format.

For a wider plan, add more quarter-start columns and extend the conditional-formatting range. Keep the dates in chronological order and include the correct year in every header. If tasks may cross from December into the next year, include quarter columns for both years; otherwise, the chart will appear to stop at the edge even when the task continues. Freeze the task-name and owner columns with View > Freeze Panes when a wide schedule becomes difficult to navigate.

Use a small legend to explain what the bar color means. If color also represents status, avoid using the same fill to represent both timing and progress without a clear convention. One simple approach is to let the quarter cells show timing and keep status as text in column E. This preserves the chart’s meaning when it is printed in grayscale or viewed by someone who cannot distinguish the chosen colors.

Quarterly Gantt charts compared with alternatives

A quarterly grid is easy to scan and edit, but it is a coarse time scale. A monthly Gantt view shows more timing detail while remaining readable for many annual plans. A weekly or daily view is more appropriate for short projects with tightly coordinated work, although it needs more columns and can become unwieldy across a full year.

An Excel stacked bar chart can also be used to create a more conventional Gantt-style graphic, typically by plotting an invisible start-date series and a visible duration series. That approach can be helpful for a presentation, but it takes more setup and may be less convenient for editing a large task list. Project-management software may be preferable when automatic dependency scheduling, workload management, permissions, or ongoing team updates are central requirements. A spreadsheet is a reasonable choice for a lightweight overview, not a substitute for every scheduling system.

Frequently Asked Questions

Does Excel have a built-in quarterly Gantt chart template?
Excel has template collections and charting tools, but a particular quarterly Gantt template may not always be listed. You can adapt a suitable project template or create the quarter grid with conditional formatting in a blank workbook.

Can I make a quarterly Gantt chart in Excel for free?
The worksheet itself can be created without a paid Gantt add-in, and Excel for the web is available with a Microsoft account. Whether you can use desktop Excel at no additional cost depends on your existing license or plan.

Can a task appear in more than one quarter?
Yes. The overlap rule colors every quarter touched by the task dates. A task running from March through July appears in Q1, Q2, and Q3, even if it occupies only part of the first and last quarters.

Can I use fiscal quarters instead of calendar quarters?
Yes. Enter the actual start date of each fiscal quarter in the timeline header, in chronological order. The overlap formula works with those quarter-start dates as long as each column represents a three-month quarter.

Why does my quarterly Gantt chart show no bars?
Check that task dates are real Excel dates, the task-name cell is filled in, and the conditional-formatting rule applies to the intended grid. Also confirm that each finish date is on or after its start date and that the header cells contain quarter-start dates.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.