Excel Gantt Chart by Month: Build, Format, and Update

To make an Excel Gantt chart by month, set up one column for each month and use conditional formatting to shade the months that overlap each task’s start and finish dates. In Microsoft Excel for Microsoft 365 on Windows, this creates a clear monthly timeline without relying on approximate 30-day chart intervals; a stacked bar chart is another option when you want a conventional chart.

What a monthly Gantt chart shows

A Gantt chart places tasks down the page and time across it. Each task appears as a bar spanning its planned duration. In a monthly version, the timeline is divided into calendar months, so readers can see which months contain work and how projects overlap.

“By month” can mean two different things. A monthly planning grid uses one column per calendar month and marks a month if a task overlaps any part of it. A date-based bar chart plots precise start dates and durations, then displays the date axis with month labels. The grid is usually easier to read for a portfolio or long-range plan. The chart is useful when the exact relative length and timing of tasks matter.

A month-wide mark does not mean that the task occupies every day in that month. For example, a task running from January 29 to February 3 will be marked in both January and February in a monthly grid. Keep the actual start and finish dates beside the timeline so the shaded cells are not mistaken for precise daily scheduling.

Choose a layout before entering data

Start with a simple table. Put one task on each row, and use actual Excel dates rather than text that only looks like a date. A practical layout is:

A: Task name
B: Start date
C: Finish date
D onward: One column for each month in the planning window

For a small plan, months across the top make the schedule easy to scan. For a project lasting several years, consider grouping columns by year or displaying a rolling window, such as the next 12 months. Freeze the task-name column or the top row if the schedule is wide; on Windows, use View > Freeze Panes. On Mac, the Freeze Panes command is also on the View tab, though the ribbon arrangement can vary by window size.

Decide how to treat dates at month boundaries. The examples below use inclusive start and finish dates: a task starting and finishing on the same date has a duration of one day. A monthly grid marks every calendar month touched by those dates.

Enter task dates and month headers

Enter task names in A2:A20, start dates in B2:B20, and finish dates in C2:C20. In row 1, enter the first day of the first planning month in G1, then format it as a month label. For example, select the cell and use Home > Number Format to choose a date format such as Mar 2026, or use Format Cells to apply a custom format such as mmm yyyy. The stored value remains a date even when the display shows only a month.

To generate the next month header, with the first month start in G1, enter this in H1 and fill right: =EOMONTH(G1,0)+1. If G1 contains January 1, 2026, the formula returns February 1, 2026. EOMONTH returns the last date of the specified month; adding one advances to the next month’s first day. EOMONTH is available in current Microsoft 365 Excel.

Check that the dates are genuine date values. If Excel treats an entry as text, date comparisons and formatting may fail. You can test a date cell by changing its number format to General: an Excel date displays as a number when shown that way. Correct imported text dates before building the timeline, and use consistent date conventions where day and month could be confused.

Build the month-by-month timeline with conditional formatting

The core rule asks whether a task’s date range intersects a month. A task overlaps a month if its start is on or before the month’s last day and its finish is on or after the month’s first day. This works even when a task lasts only a day or spans just a few days at a month boundary.

Select the timeline area, for example G2:R20, with G2 as the active cell.
Choose Home > Conditional Formatting > New Rule.
Select Use a formula to determine which cells to format.
With month-start dates in row 1, task starts in column B, and finishes in column C, enter the formula below.
Select Format, choose a fill color, and confirm the rule. Use a light fill or a distinct palette so the task labels and month headings remain legible.

For the selected range G2:R20, with G1 holding the first month start and the dates for the first task in B2 and C2, use =AND(G$1<=$C2,EOMONTH(G$1,0)>=$B2). For a task that runs January 29 through February 3, the rule evaluates as TRUE in both its January and February cells, because the task overlaps both months. The dollar signs keep the header row and date columns fixed appropriately as Excel evaluates the rule across the selected grid.

Use Conditional Formatting > Manage Rules if you need to check the Applies to range or edit the formula. If you add more task rows or month columns later, extend the range or update the rule. A copied format is not always a substitute for checking the rule’s range, especially after inserting columns.

Make the timeline easy to read

Format the month headings consistently and make them distinct from task rows. A thin border between months can help readers follow a long timeline, while a stronger border at the start of each year can make a multi-year plan easier to navigate. Avoid coloring every cell heavily: the point is to make active periods visible without burying the task names.

Sort tasks in a useful order, such as workstream, project phase, or start date.
Use a legend if color represents more than task activity, such as status or team.
Keep status information in a separate column rather than relying on color alone.
Use a contrasting font or an adjacent status label so the sheet remains understandable when printed in grayscale.
Set print orientation and scaling deliberately; a 24-month schedule may be too wide to read if forced onto one page.

For a visual status layer, add a separate status column with values such as Not started, In progress, and Complete, then apply different formatting rules to that column. Avoid making a single conditional-formatting rule do several jobs at once. Clear visual conventions make the schedule easier to update and less likely to be misread.

Make a conventional stacked bar Gantt chart

A stacked bar chart can show exact date positions, but it needs a hidden offset series. Create a small adjacent chart-source table with task names, start dates, and durations. With start dates in B2:B20 and finish dates in C2:C20, enter this in D2 and fill down: =C2-B2+1. For a task from January 30 through February 2, the result is 4 days because both endpoints are included.

For a chart source, place task names, start dates, and the duration values next to one another in columns F:H, with headers in row 1. Select that table, then choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Excel plots the start-date series as the offset and the duration series as the visible bar. Select the start-date series, open Format Data Series, and set its fill to No fill so only the duration appears. If the tasks display in an inconvenient order, format the category axis and use Categories in reverse order.

Format the horizontal value axis to show dates and set its minimum and maximum bounds to the schedule’s date range where appropriate. A number format such as mmm yyyy can provide month-style labels. Keep in mind that the chart’s date axis is based on numeric date values: setting a fixed interval of 30 days does not create true calendar-month spacing, because months have different lengths. Use the monthly grid when equal-width calendar-month columns are essential; use the chart when proportional date spacing is more important.

Common problems and practical fixes

No cells are shaded: Check that the month headers and task dates are real dates, that the rule’s Applies to range includes the timeline, and that the formula references the correct columns.
The highlight is one column off: Confirm that G1 is the first month header and G2 is the top-left cell of the selected range. The formula’s relative column reference should move from G to H as the rule moves right.
A task ending on the first day of a month is missing: The overlap formula includes the finish date. Check that the finish date in column C is correct and has not been stored as text.
The bar chart starts far from zero: That is expected when start dates are used as the hidden offset series. Hide the offset series rather than setting the axis minimum to zero, which would compress the actual schedule.
Month labels repeat or look crowded: Widen the chart or reduce the number of displayed labels. For a long schedule, a monthly grid may be clearer than trying to label every interval on a chart axis.

Also decide how to handle missing finish dates. A blank finish date should not silently be treated as a completed schedule. Either enter a planned finish date, use a separate rule for active tasks, or show the task’s status explicitly. If your plan includes milestones, represent them separately—such as with a milestone column or a chart marker—rather than implying that a one-day task is a milestone without labeling it.

When to use a template or another tool

An Excel template can save setup time, but inspect its date logic before relying on it. Confirm whether it uses calendar months or fixed-width periods, whether finish dates are inclusive, what happens when you insert rows, and whether conditional formatting extends to new tasks. Remove sample data and check formulas before sharing the file.

Excel is a reasonable choice for a small or medium schedule that benefits from familiar tables, formulas, and flexible formatting. A monthly grid is especially useful for reporting across departments or showing a high-level roadmap. For a schedule with many linked tasks, dependencies, resource assignments, or frequent changes, a dedicated project-management tool may handle relationships and updates more conveniently. You can still export or summarize its dates in Excel for a monthly overview.

Frequently Asked Questions

Can Excel make a Gantt chart by month?
Yes. Put calendar-month start dates across the top, task start and finish dates in separate columns, and use conditional formatting to mark each month a task overlaps. A stacked bar chart is another option for a date-based visual.

How do I show months instead of days in an Excel Gantt chart?
For a grid, use one column per month and format each heading to display a month and year. For a stacked bar chart, format the date axis labels as months, but remember that labels do not turn the axis into equal-width calendar-month periods.

Can a task that lasts only a few days appear in a monthly Gantt chart?
Yes. The monthly grid marks a month whenever the task overlaps any date in it. Keep start and finish dates visible because the month mark does not show how many days the task occupies.

Why does my Gantt chart show the start date as a bar?
In a stacked bar Gantt chart, the start-date series positions each task’s duration bar along the timeline. Format that first series as No fill; the duration series remains visible as the task bar.

Is a monthly grid or a bar chart better?
Choose a monthly grid for clear calendar-month columns and high-level planning. Choose a stacked bar chart when proportional spacing between precise dates matters. Some schedules benefit from keeping both: a monthly overview for readers and a detailed chart or date table for scheduling.

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.