Excel Gantt Chart Template Monthly: Build One That Works

Yes. You can make a monthly Gantt chart template in Excel by listing each task with its start and finish dates, placing consecutive months across the worksheet, and using conditional formatting to shade each month that overlaps a task. This makes a practical, editable schedule without needing a special Gantt chart feature.

What a monthly Gantt chart shows

A Gantt chart lays tasks against a timeline so readers can see when work is scheduled and how tasks overlap. In a monthly version, each timeline column represents one calendar month. A shaded cell indicates that some part of the task occurs during that month. For example, a task running from March 20 to April 8 shades both March and April, even though it does not occupy either month in full.

Excel does not provide a dedicated, one-click Gantt chart type. A common approach is to build a grid and use conditional formatting to display bars. The underlying data remains a normal worksheet table, which is useful when you need to sort tasks, update dates, or add project notes.

Monthly views work well for project roadmaps, construction phases, marketing calendars, product launches, and other schedules where the important question is which months contain activity. They are less suitable when a team needs to coordinate exact days, shifts, or short dependencies. A monthly cell cannot show whether work takes place on the first or last day of that month.

Set up the worksheet

Start with a blank worksheet in Excel for Microsoft 365 on Windows. Use columns A through D for task information, and columns E onward for the monthly timeline. Put a control date in B2 and label A2 “Timeline begins.” This date tells the template which month to show first; it does not have to be the exact start date of a task.

In A4:D4, enter the headers Task, Start, Finish, and Duration.
Enter a task name in A5, its start date in B5, and its finish date in C5. Add more tasks on the rows below.
In E4, create the first month header. In F4, create the next one, then copy that formula right.
Format B2, B5:C20, and the timeline headers as dates. Display the timeline headers as mmm yyyy so they read, for example, Mar 2026.

With the timeline start date in B2, put this formula in E4 to make the first header the first day of the month containing B2: =DATE(YEAR($B$2),MONTH($B$2),1). In F4, use =EDATE(E4,1) and copy it to the right to create consecutive months. For example, if B2 contains March 18, 2026, E4 is March 1, 2026, and the next header is April 1, 2026. The display format can show the month and year while the cell retains a real date value.

To calculate elapsed calendar days, put =C5-B5+1 in D5 and fill it down. With a task starting March 20 and finishing April 8, the result is 20 days: 12 days from March 20 through March 31, plus 8 days from April 1 through April 8. This is inclusive calendar duration, not a count of working days. If your schedule uses working days, document that convention and use a separate calculation rather than interpreting this value as workdays.

Make the monthly bars with conditional formatting

First, select the grid that should display the bars, such as E5:Z20. On the Home tab, choose Conditional Formatting > New Rule, select “Use a formula to determine which cells to format,” and enter the rule below. Choose a fill color in the formatting options, confirm the rule, and check that the Applies to range covers the timeline cells for all task rows.

For a grid with month-start dates in row 4 and task dates in columns B and C beginning on row 5, use this conditional-formatting formula: =AND($B5<>"",$C5<>"",E$4<=$C5,EOMONTH(E$4,0)>=$B5). The test shades a cell when the month starts on or before the task’s finish date and the month ends on or after its start date. The dollar signs keep the task-date columns fixed and the header row fixed while Excel adjusts the month column and task row through the selected grid.

For example, a task dated March 20 through April 8 shades the March and April cells, but not February or May. EOMONTH finds the last date of a month, including February in leap years, so you do not need to hard-code the number of days in each month. The formula also checks for blank start and finish cells so unused task rows stay unshaded.

To change the appearance later, select a cell in the schedule and open Home > Conditional Formatting > Manage Rules. Inspect the rule’s formula and Applies to range if bars disappear or extend into the wrong columns. Excel for Mac uses the same general conditional-formatting approach, though the ribbon presentation can differ slightly by release. The formulas shown use standard Excel syntax and work with actual date values.

Choose the right month range and level of detail

Decide how much of the project readers need to see. A six-month product launch may fit in six or seven timeline columns, while a multi-year facilities plan may need many more. Copy the month formula right far enough to include the project’s finish dates, then use Freeze Panes or a suitably sized print layout if the timeline becomes wide. In Microsoft 365 for Windows, select the cell below and to the right of the rows and columns to keep visible, then choose View > Freeze Panes > Freeze Panes.

Use one row per activity when the goal is a readable overview. If the schedule needs phases and subtasks, add an indented task-name convention or separate columns for workstream and owner. Grouping tasks by team or phase can help readers find related work, but avoid merging cells across task rows: merged layouts can make sorting and editing harder.

A month-by-month chart is a summary, not proof that a task runs continuously every day in that month. If an activity pauses, has multiple separate work periods, or is only a one-day milestone, a single shaded monthly cell hides that distinction. For milestones, consider a separate milestone column or a symbol and a clear legend. For short tasks and daily coordination, use a daily or weekly view instead.

Keep the template accurate as dates change

A template is only as reliable as its input dates. Enter real Excel dates rather than text that merely looks like a date. If a value is left-aligned or does not behave like other dates, check the cell format and regional date interpretation. When copying dates from email or another system, verify a few entries before relying on the chart.

Agree whether the finish date is inclusive. The duration formula above assumes that it is.
Decide whether weekends and holidays matter. The monthly overlap bars do not distinguish working days from nonworking days.
Use a consistent rule for uncertain dates, such as leaving them blank until confirmed, instead of entering a guessed date that looks final.
Review the timeline end after adding tasks. A project that extends beyond the last visible month can appear to stop early even though its dates are correct.
Add a legend that explains what the fill color means, especially if colors identify owners, status, or task categories.

For a longer-lived template, convert the task list into an Excel table using Insert > Table. Tables make it easier to filter and maintain task records as rows are added. The timeline grid and conditional formatting may still need to be extended when you add tasks or months, so check the rule’s Applies to range after structural changes.

Common problems and what they mean

If no bars appear, check that the start and finish values are valid dates, that the month headers are dates rather than typed month names, and that the conditional-formatting rule covers the selected grid. Also confirm that each task’s finish date is on or after its start date. A reversed date range will not describe a valid task interval.

If bars appear one column too early or late, check the first month header and the formula’s relative references. The header must be in row 4 in the example layout, and the first selected task cell must be E5. When applying the rule from another starting cell, adjust the formula so its unanchored column matches the first timeline column and its task-row reference matches the first task row.

If a bar appears in every month for a task, the date cells may contain unexpected values, or the formula may have been entered with incorrect dollar signs. If only the first task row works, make sure the row number in the task references is relative, as in $B5 and $C5, rather than fixed as $B$5 and $C$5. If the chart looks compressed when printed, switch to landscape orientation or print only the relevant columns; forcing a very wide multi-year schedule onto one page can make labels unreadable.

Monthly templates compared with other approaches

A conditional-formatting grid is often the simplest choice when you want a monthly overview that stays connected to task dates. It is easy to inspect and customize, but the monthly cells show overlap rather than exact duration within the month. A stacked bar chart can create a more chart-like visual, but it generally takes more setup and is less convenient for a large, frequently edited task table.

A weekly or daily grid provides finer scheduling detail, at the cost of more columns and a wider sheet. A project-management application may be a better fit when you need automatic dependency links, shared updates, notifications, or workload management. Excel remains useful for a lightweight plan, a printable overview, or a schedule maintained by a small group. The right format depends on how often dates change and how precise decisions need to be.

There is no single universal monthly Gantt template that suits every project. A useful template makes its assumptions visible: what a bar means, whether dates are inclusive, what units the duration uses, and which months are displayed. If you download a workbook, inspect its formulas, date range, and conditional-formatting rules before entering important project information. If you build your own, save a clean copy before adding project-specific data so it can be reused.

Frequently Asked Questions

Does Excel have a built-in Gantt chart template?
Excel does not have a dedicated Gantt chart chart type. You can start from a workbook template if one suits your needs, or build a grid with task dates and conditional formatting as described above.

How do I show months instead of days in an Excel Gantt chart?
Put real month-start dates across the timeline, format them as mmm yyyy, and use a conditional-formatting overlap rule. Each shaded cell then represents a month in which the task is active.

Can one monthly cell show a task that starts and ends within the same month?
Yes. If the task dates overlap that month, the cell is shaded. The view does not show how many days the task occupies, so keep the exact start and finish dates visible in the task table.

How do I extend the chart when the project gets longer?
Copy the month-header formula into additional columns and extend the conditional-formatting Applies to range to include them. Confirm that the new headers continue in monthly order.

Is a monthly Gantt chart better than a weekly one?
It is better for a high-level roadmap or long project where month-level timing is sufficient. Choose a weekly or daily timeline when teams need to coordinate short tasks, specific handoffs, or exact work dates.

Make the view useful to its readers

Before sharing the workbook, add a descriptive title, identify the project owner, and state the date on which the schedule was last updated. Keep task names concise, make date formats consistent, and include a legend if color has a meaning beyond “active during this month.” These small details prevent readers from mistaking a broad planning view for a detailed commitment.

A monthly Excel Gantt chart is most effective when its level of detail matches the decisions it supports. Use the date table as the source of truth, let the monthly grid communicate overlap, and check the visible time range whenever the schedule changes. That combination produces a simple template that can be understood and maintained without concealing what the monthly view cannot show.

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.