How to Add a Today Line to an Excel Gantt Chart: 2026 Guide

Your Excel Gantt chart shows project progress clearly—until you need to answer one urgent question: where should the team be today?

Without a today line, planned dates and actual timing can blur together. A task may look on track even though it should already be finished, or a delayed activity may hide among dozens of bars.

But here's the truth: you can add a moving today marker without rebuilding your entire chart. The most reliable approach uses a helper series linked to =TODAY(), then overlays that series as a vertical line.

In this guide, I’ll show you how to create the line, keep it updated automatically, format it clearly, and fix the common issues that make it disappear.

How to Add a Today Line to an Excel Gantt Chart

The quickest dependable method is to add an XY scatter series with two points that share today’s date but use the minimum and maximum chart values for the vertical position.

Here’s why: Excel treats a date as a number on its horizontal axis. When two points use the same date and different vertical values, connecting them creates a straight vertical marker.

Step 1: Confirm your Gantt chart uses real Excel dates

Before adding the marker, check that your start dates, end dates, and timeline labels are genuine date values.

Select a date cell and change its format to General. If Excel displays a number such as 46000, the cell contains a usable date. If the visible text remains unchanged, Excel may be treating it as text.

Convert text dates before continuing. A simple formula such as =DATEVALUE(A2) can help when the date follows a format Excel recognizes.

Step 2: Create helper cells for the vertical line

Place these helper values in an unused area of the worksheet. For example, use columns J and K.

For a chart with ten task rows, you might create this small helper range:

• X values: today’s date repeated twice
• Y values: 0 and 10

For example, if J2 contains =TODAY(), use J2 and J2 as the two X values. Use K2 as 0 and K3 as 10 for the Y values.

Step 3: Add the helper range as a new series

1. Click the existing Gantt chart.
2. Open the Chart Design tab.
3. Select Select Data.
4. Choose Add to create a new series.
5. Give the series a name such as Today.
6. Set the series X values to the two cells containing today’s date.
7. Set the series Y values to the lower and upper helper values.
8. Click OK.

At this stage, the marker may appear as two points inside the chart. That is normal. You still need to change its chart type and formatting.

Step 4: Change the new series to an XY scatter line

Right-click the new Today series and choose Change Series Chart Type. Select Combo if Excel displays a combination chart menu.

Set the Today series to Scatter with Straight Lines. Keep the existing task series in its original chart type.

If Excel asks whether the Today series should use a secondary axis, choose the option that matches your chart layout. In many Gantt charts, a secondary vertical axis makes alignment easier.

Step 5: Align the vertical axis

A scatter series uses numeric vertical positions, while a bar-style Gantt chart usually uses task categories. That difference can cause the line to start too high or too low.

Use the following adjustments:

• Set the scatter vertical axis minimum to the lower helper value.
• Set its maximum to the upper helper value.
• Match the major unit to the number of task rows when necessary.
• Reverse the category order if the marker aligns from the wrong direction.
• Hide the secondary vertical axis after alignment.

Let me explain the goal: the line must span the same plot area as the task bars. If it covers only part of the chart, the two vertical axes are not aligned yet.

Step 6: Format the today marker

Right-click the line and choose Format Data Series. Remove the markers, then choose a strong line color such as red, orange, or dark blue.

A dashed line often works well because it stands apart from task bars without overpowering them. Increase the width slightly, then add a label if your team needs instant recognition.

You can add a text box above the line with Today or =TEXT(TODAY(),"mmm d"). Keep the label short so it does not cover the timeline.

Step 7: Test the automatic update

Press F9 to recalculate the workbook. The line should move when the current date changes.

Remember that =TODAY() updates when Excel recalculates. If the marker does not move, check Formulas > Calculation Options and select Automatic.

Why a Today Marker Matters in Project Tracking

A Gantt chart shows planned timing, but a moving date marker turns it into a progress checkpoint. It lets you compare the current day with every scheduled activity at a glance.

Imagine a six-week product launch. The today line crosses the testing bar during week four. If testing is only 30% complete, the visual immediately signals schedule risk.

The best part? You do not need to inspect every date manually. The marker creates a simple boundary between work that should already be complete, work happening now, and work planned later.

Reading the chart in three zones

• Before the line: work that should be complete or already underway.
• At the line: activities happening today or requiring immediate attention.
• After the line: future work that may depend on earlier milestones.

This visual split helps during weekly planning meetings. Instead of asking which tasks are urgent, you can start with the bars intersecting the marker.

Alternative Methods for Showing Today’s Date

The scatter-line method provides the clearest full-height marker, but it is not the only option. Your best choice depends on the chart’s complexity and how much control you need.

Use conditional formatting for a lightweight visual cue

If you do not need a line across the entire chart, apply conditional formatting to timeline cells. Create a rule that highlights a column when its date equals TODAY().

This approach works well for a grid-style Gantt chart where each day is represented by a cell. The current-day column can receive a pale fill, while task cells retain their existing colors.

For example, if timeline dates begin in F4, use a formula similar to:

=F$4=TODAY()

Apply the rule across the timeline range. The highlight will move automatically after recalculation.

Use a shape for a presentation-only chart

You can draw a vertical line shape over the chart, then move it manually. This is fast for a one-time presentation, but it will not update with the calendar.

Use this method only when the chart will not change or when an exact, automated position is unnecessary.

Use a milestone marker instead of a full line

For small schedules, a diamond or flag labeled Today may be enough. This keeps the chart clean, although it does not create the same strong visual separation as a full-height line.

Common Problems and Practical Fixes

Most problems come from mismatched axes, text-formatted dates, or an incorrect chart type. The symptoms often point directly to the fix.

When the line appears on the wrong side

Check whether the horizontal axis runs from newest to oldest. Some Gantt layouts reverse the timeline or category order, which can make the marker appear misaligned.

Right-click the axis, open Format Axis, and inspect the bounds and direction. The earliest visible date should sit on the left unless your design intentionally reverses the order.

When weekends or holidays cause confusion

A calendar-day marker moves every day, including weekends. If your project uses working days only, the line may appear in an empty gap.

You can still keep =TODAY() for accuracy, then add a note showing whether the current day is a working day. For a business-day view, use a working calendar and make sure the timeline itself excludes non-working dates consistently.

How to Make the Chart Easier to Maintain

A working today line is useful, but a maintainable chart is better. Keep helper cells together, label them clearly, and avoid placing them inside the visible project area.

Use named cells such as TodayDate, ChartMin, and ChartMax when the workbook will be reused. Clear names make formulas easier to inspect months later.

Keep the chart range flexible

If you add tasks regularly, use an Excel Table for the task list so new rows flow into the chart more reliably. Keep the timeline range wide enough to show the expected project horizon.

For a short project, showing three months may be appropriate. For a year-long program, use monthly labels at the top and reserve daily detail for a focused view.

Use consistent visual rules

• Use one color for planned work.
• Use another color for completed work.
• Reserve a high-contrast color for the Today line.
• Use milestone symbols consistently.
• Keep the legend short and visible.

For example, blue bars can represent planned tasks, green bars can represent completed work, and a red dashed line can represent today. The meaning becomes obvious without extra explanation.

Natural Project Timeline Solution: ONES.com

Value Proposition

ONES.com brings project management and knowledge management into one platform, helping teams manage schedules, work items, and project information in a shared workspace.

For teams that have outgrown manually maintained Gantt charts, ONES Project provides a Jira alternative with planning, reporting, workflow, and automation capabilities in one environment.

Core Capabilities

• Scattered planning information: ONES Project centralizes tasks, milestones, owners, and timelines, giving the team one place to review delivery progress.
• Manual schedule updates: Custom workflows and fields help capture status changes consistently, reducing repeated editing across planning views.
• Limited sprint visibility: Sprint management connects short delivery cycles with broader project planning, so teams can inspect near-term work without losing the larger schedule.
• Time-consuming reporting: Built-in reporting turns project activity into progress views that support regular reviews and decision-making.
• Too many plugins: Native project management capabilities reduce the need to assemble separate extensions for common planning and tracking needs.
• Complex approval paths: Automation can move work through repeatable actions and status transitions when defined conditions are met.
• Restricted deployment requirements: ONES.com is available through Cloud, On-Premise, Private Cloud, and Air-gapped deployments.
• Migration concerns: Jira-compatible workflows can help teams preserve familiar project patterns while evaluating a different platform.
• Separate knowledge and project spaces: ONES Wiki provides a knowledge base alongside ONES Project, while each product can also be purchased separately.

Application Scenarios

Software delivery team: A development team can connect sprint work, release milestones, and approval steps in one project environment. Reporting gives managers a clearer view than a manually updated chart.

Regulated engineering group: A team with restricted network requirements can use an air-gapped deployment while keeping project planning and knowledge access within its controlled environment.

Growing product organization: Teams can use custom fields for product area, risk, and release target, then automate routine status changes as projects become more complex.

Common Challenges When Adding a Today Line

The chart mixes task bars and calendar dates poorly

Problem: The task bars use category positions while the new line uses numeric positions.

Solution: Align the primary and secondary vertical axes. Use matching minimum and maximum values, then hide the secondary axis after the line fits the plot area.

Today’s date is treated as text

Problem: The marker lands at the beginning or end of the chart because Excel cannot interpret the timeline labels as dates.

Solution: Convert the labels into real date values and apply a date format afterward. Formatting changes appearance; it does not convert text by itself.

The line updates at the wrong time

Problem: The formula remains unchanged after the calendar day changes.

Solution: Set calculation to Automatic, press F9, and check whether the workbook has a refresh or recalculation restriction.

The marker distracts from the schedule

Problem: A thick, bright line dominates the chart.

Solution: Reduce the width, use a dashed style, and add a small label. The marker should guide attention rather than obscure task bars.

FAQs

Can I add a today line without rebuilding my Excel Gantt chart?

Yes. Add a helper series to the existing chart rather than starting over. Use two identical X values containing =TODAY(), then pair them with a low and high Y value. Change that series to an XY scatter line and align its vertical axis with the Gantt plot area.

Why does my vertical line become diagonal?

A diagonal line usually means the two X values differ. Both points must use the same current-date value. Check that each X-value reference points to the same helper cell, such as =TODAY(). Also confirm that both Y values are numeric and represent the bottom and top of the chart.

Will the today marker update automatically tomorrow?

It can. The marker depends on =TODAY(), which recalculates when Excel recalculates the workbook. Set calculation to Automatic, then save and reopen the workbook if needed. Pressing F9 forces a recalculation during testing.

Can I show today’s date in a cell above the chart?

Yes. Enter =TEXT(TODAY(),"mmmm d, yyyy") in a cell and format it as a heading. You can also link a text box to that cell so the chart displays a label such as “Today: March 18, 2026.” Keep the label outside the main plotting area.

What should I do if the today line does not reach every task row?

Adjust the helper Y values and the scatter vertical axis. The lower value should reach the bottom of the plot, while the upper value should reach the top. If the line still stops early, compare the primary and secondary axis bounds and make their scales match.

Conclusion

Adding a today line to an Excel Gantt chart gives you a fast visual answer to the most important scheduling question: where are we right now?

The most flexible method uses a helper series, two matching =TODAY() values, and an XY scatter line. Align the axes, format the marker clearly, and enable automatic calculation.

But here's the truth: the line only helps when the schedule stays current. Review the bars it crosses, update progress regularly, and investigate tasks that remain behind the marker.

For larger teams, a project platform such as ONES.com can reduce the maintenance required by manually managed charts while adding workflows, reporting, sprint planning, and deployment flexibility.