Excel Gantt Chart With a Today Line

Yes. For a Gantt chart made from worksheet cells, apply conditional formatting to the date grid so the column for today gets a distinctive border; it updates automatically each day. If you mean an actual stacked-bar chart, Excel has no built-in Gantt chart type or automatic today-line switch, so you can add a manually positioned line or use a more involved chart overlay.

What a today line shows

A today line is a vertical marker aligned with the current date on a project timeline. It helps readers compare the plan with the present: tasks behind the line may be overdue or underway, while tasks to its right are scheduled for the future. The marker does not calculate progress or prove that a task is on schedule. It is a visual reference, and it is most useful when the schedule also contains reliable start dates, finish dates, and status information.

Excel does not provide a dedicated Gantt chart button that automatically adds this marker. A Gantt view is usually built either as a formatted grid of date cells or as a stacked bar chart. The best way to show today depends on which kind you have: conditional formatting is simple and dynamic in a cell-based Gantt, while a line added to a chart needs extra care to stay aligned with the chart’s date scale.

Build a cell-based Gantt grid

A worksheet grid is a practical choice for a small or medium schedule, especially when the people reading it need to see task names and dates together. Set up one row per task, with a task name, start date, and finish date in the first columns. Across the top of the timeline area, enter consecutive real Excel dates and format them to display as days, weeks, or month labels. The displayed format can be concise while the cell still contains a full date.

For example, assume task start dates are in B2:B20, finish dates in C2:C20, and daily timeline dates begin in D1. Select the task-and-date grid, such as D2:AG20, and create a rule through Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With the layout just described, use this formula for the task bars:

=AND(D$1>=$B2,D$1<=$C2)

Choose a fill color for the rule. The dollar signs keep the header row and the start and finish columns fixed as the rule evaluates other cells, while the column and row references that need to move remain relative. If your dates or timeline begin in different cells, adjust the references before applying the rule.

Add the automatically updating today marker

With the same layout—timeline dates in D1:AG1 and task rows in D2:AG20—select D2:AG20 and create another formula-based conditional-formatting rule. Use:

=D$1=TODAY()

In the rule’s format settings, choose a noticeable left border, right border, or both, such as a thick red border. A border is often more useful than a solid fill because it can mark today without hiding the task-bar color underneath. The rule checks the date in each column header; when that date equals the current date, the matching cells receive the border. Because TODAY() recalculates, the marker moves as the date changes, subject to Excel’s calculation settings and when the workbook recalculates.

To make the line easier to follow, apply a similar rule to the date-header row, using the header cell reference appropriate to that selection. You can also give today’s header a contrasting font or fill. If the schedule includes blank rows between tasks, the line will have gaps there; apply the rule to the full timeline area, including those rows, if you want a more continuous marker.

Make the timeline and dates reliable

The today rule works only when the headers contain actual Excel dates, not text that merely looks like a date. A quick check is to change a header cell temporarily to a general number format: a genuine date displays as a serial number. Restore the desired date format afterward. Make sure the timeline includes today; a rule cannot mark a date column that is not present.

For a daily timeline, consecutive dates make the marker precise. For a weekly timeline, decide what each header represents. If the header contains the week’s first day, an exact equality rule marks that day only. If you want today’s week highlighted, use a rule that checks whether today falls between the week’s start and end dates, or put explicit week-start and week-end dates in helper rows. This avoids a common mismatch where a reader expects a line for today but the chart displays only weekly buckets.

Excel’s TODAY() uses the computer’s current date and returns no time component. If the workbook is configured for manual calculation, formulas may not refresh immediately; press F9 on Windows to recalculate, or check Formulas > Calculation Options. On Mac, use the Formulas tab’s calculation options where available, and the F9 shortcut may require the Fn key depending on keyboard settings.

Use a stacked bar chart instead

If you need a conventional chart with task names on one axis and dates on the other, create a stacked bar chart. Arrange each task with a start date and a duration. A duration can be the number of calendar days from the start to the finish; decide whether your project treats the finish date as inclusive, since that choice changes whether the duration is the date difference or the date difference plus one. Select the start-offset and duration data, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar. Format the start-offset series with no fill so only the task-duration bars remain visible, and format the horizontal axis as dates or a suitable date scale.

This chart is useful for presentations, but it does not behave exactly like a cell grid. A line shape can be placed over the plot area at today’s position, but it is a visual object rather than a date-aware chart element. It will not automatically move when the day changes, and it may need repositioning if the date axis, plot-area size, or chart dimensions change. Add it through Insert > Shapes > Line and check its alignment after editing or resizing the chart.

A more technical option is to overlay an XY scatter series whose x-value is today and whose y-values span the task positions, then align the secondary axes with the bar chart’s plot area. This can produce a data-driven vertical marker, but it takes careful axis configuration: the secondary date bounds must match the chart’s date range, and the vertical scale and category order must line up. A mismatch can put the marker in the wrong place or make it appear outside the task bars. For many schedules, a cell-based Gantt or a manually maintained chart line is easier to understand and maintain.

Choose the right approach

Use a conditional-formatting grid when the schedule is maintained in Excel, the audience needs to scan task dates directly, and an automatically moving marker matters. Use a stacked bar chart when the chart itself is important for a report or presentation and you are comfortable checking the line after changes. If a project has many dependencies, multiple calendars, frequent status updates, or several people editing at once, consider whether a dedicated project-planning tool would be more suitable than a complex workbook.

Cell grid: straightforward to build, easy to edit, and a TODAY()-based border updates automatically.
Stacked bar chart: compact and presentation-friendly, but the today marker needs a shape or a carefully configured overlay.
Project software: may offer scheduling and dependency features beyond a visual Gantt, but involves choosing and learning another tool.

Whichever option you choose, distinguish the current date from actual progress. A today line says where the calendar is; it does not say how much work is complete. A progress fill, percent-complete field, or status column communicates that separate information.

Common problems and fixes

No marker appears: confirm that today is within the displayed timeline and that the header contains a real date equal to today. Check that the conditional-formatting rule applies to the intended cells.
The marker is one column off: check the first timeline column in the formula. The relative column reference must match the first cell in the selected range, while the header row should be fixed, as in D$1 when the range starts in column D.
The marker hides the task bars: use a border instead of a fill, or adjust the rule’s formatting so it does not replace the bar fill. Conditional formatting can be layered, but overlapping rules and their priority can affect the result.
The marker does not move: check Formulas > Calculation Options and ensure calculation is not set to Manual. Recalculate the workbook and verify that the computer’s date is correct.
The chart line drifts: a drawn shape is not tied to the date axis. Reposition it after changing the chart size or date bounds, or use a data-driven overlay if you need the position to follow dates.

Frequently Asked Questions

Can Excel add a today line to a Gantt chart automatically?
In a cell-based Gantt, yes: a conditional-formatting rule using TODAY() can mark the matching date column and update when Excel recalculates. A standard stacked bar chart does not have a built-in automatic today-line option.

What formula marks today in a Gantt chart?
For a timeline header in row 1 and a selected grid beginning in column D, use =D$1=TODAY() as a formula-based conditional-formatting rule. Change D and the row reference to match the first header cell in your layout.

Why is TODAY() not updating?
Excel may be using manual calculation, or the workbook may not have recalculated since the date changed. Check Formulas > Calculation Options and recalculate. Also confirm that the computer’s system date is correct.

Can I make the today line red without covering the Gantt bars?
Yes. Set the today rule’s border to red and leave its fill unset. A left or right border creates a visible vertical marker while preserving the bar color in the cell.

Does a today line show whether a task is late?
No. It shows the current date against the planned schedule. To identify late work, compare actual status or completion dates with the plan; the line alone cannot tell whether a task has started, finished, or slipped.

Keep the marker meaningful

A useful today line depends on a trustworthy timeline and clearly defined task dates. For a maintained worksheet schedule, a conditional-formatting border is usually the simplest option: it follows the date automatically and leaves the Gantt bars visible. For a presentation chart, decide whether a manually placed line is acceptable or whether the extra setup of a scatter-series overlay is worthwhile, and verify its alignment whenever the chart changes.

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.