Back to ArticlesBack

Join 50,000+ PM Professionals

Get expert PM insights, PMP prep tips, and earn PDUs with exclusive content delivered weekly.

MPUG

By default, the lag set between tasks is displayed in the Predecessor column of the Gantt chart view. Neither Microsoft Project 2007 nor Project 2010 has a separate field to display the lead or lag of specific tasks.

You can display the lag as a separate field by following these steps:

  1. In Project 2007 choose Tools, Customize Fields. In Project 2010 choose Project ribbon | Custom Fields in the Properties group.
  2. In the Custom Fields dialog, select the Task radio button. Then choose the Type drop down and select Text.
  3. Select Text1 and click the Rename button. Change the name to “Lag” and choose OK. This will display “Lag (Text1).”
  4. Click the Formula button of Custom attributes, enter the following formula, and click OK:IIf(InStr([Predecessors],”+”)<>0, Mid([Predecessors],InStr([Predecessors],”+”),Len([Predecessors])), “”)You’ll get a warning message that existing data in the Lag field will be deleted because now all values will be calculated by the formula. Click OK.
  5. Insert a column with the Field name as Lag (Text1) in Project 2007 by choosing Insert | Column. In the Field name dropdown, choose Lag (Text1). In Project 2010, just right-click on the column next to which you want the new column added and choose Insert Column. Scroll down to Lag (Text1) and select it.

How To Display Lag between Tasks in Your Gantt Chart

You may be wondering about that formula I’ve asked you to enter. What does the code mean?

For the purposes of illustration, let’s say the lag between Prepare and Review tasks is 1FS+2days (translated to: “The task is planned to Start with a lag time of two days after the Finish of its predecessor task”).

The part of the code that specifies:

InStr([Predecessors],”+”)

returns the position of + in the [Predecessors] field. That’s four in the example shown in the screenshot.

This code:

Mid([Predecessors],InStr([Predecessors],”+”),Len([Predecessors]))

extracts the text from + to the end of the string, which is “+2days.”

If you want display the lag to the right or left of the task bar, follow these steps:

  1. In Project 2007 choose Format | Bar Styles. In Project 2010, choose Format ribbon | Bar Styles in the Bar Styles group.
  2. Select the rows in the top area that you want the lag displayed next to.
  3. Select the Text tab in the bottom and choose the dropdown for Left or Right.
  4. Select the field name Lag (Text1) and press OK.

Get Weekly PM Insights

Join 50,000+ PMs receiving updates on the latest PM methodologies, PDU opportunities, tool reviews, career tips, and member exclusives.

PMI ATP
PMI Authorized Training Partner
REP #4082

Learning Paths

PMP® TrainingCAPM® TrainingPgMP® TrainingPMI-ACP® TrainingMS ProjectMS PlannerMS TeamsJira

PM Resources

PDU TrackerLive WebinarsSalary CalculatorTool ComparisonsJob BoardKnowledge BasePM Glossary

Community

Discussion ForumStudy GroupsEvents Calendar

Follow Us

LinkedInYouTubeTwitterFacebook
MPUG Logo

© 2026 MPUG. All rights reserved.

TermsPrivacySitemap
Articles

How To Display Lag between Tasks in Your Gantt Chart

By default, the lag set between tasks is displayed in the Predecessor column of the Gantt chart view. Neither Microsoft Project 2007 nor Project 2010 has a separate field to […]

2 min read
•over 14 years ago••
S
Sai PrasadAuthor
Project Management
Microsoft Project
Best Practices
Productivity
S
Sai Prasad

Content Writer

B Sai Prasad, PMP®, PMI-SP®, MVP Project, Senior Manager - Learning & Development, has been with service provider Cognizant Technology Solutions India Pvt. Ltd since 2001 where he was named winner of the company's Global Trainer of the Year award. He has spent 13,000-plus hours in mentoring, coaching, training 9000-plus practitioners on project management topics ranging from project management concepts, project risk management, project scheduling, Microsoft Office Project® to software estimation techniques. He is a Champion of Project Management from PMI India and also Associate Champion Advisory Committee, PMI India. He is awarded the Champion of the Quarter (Q4 – 2012) and Delivery Excellence Award (2011-2012, 2012-2013) from PMI India. He's also the editor of the project management book, Forecast Scheduling with Project 2010. He is a Microsoft Certified Technology Specialist (MCTS) in Project 2010.

View all articles by Sai Prasad
Related Content

Continue Reading

Discover more insights and articles that complement your current reading

Two Project Manager Agent Features You Might Like
Articles
5 min read

Two Project Manager Agent Features You Might Like

Discover two game-changing features of Microsoft’s Project Manager Agent including agent-to-agent communication and the new integrated interface in Planner.

E
Erik van Hurck
about 2 months ago
Read
Master Dependency Analysis in Microsoft Project with SSI Tools!
Articles
2 min read

Master Dependency Analysis in Microsoft Project with SSI Tools!

Learn how to master dependency analysis in Microsoft Project using SSI Tools’ Directional Path, Connecting Path, and Dependency Tracer to analyze predecessors, successors, and project logic.

K
Kenny Arnold
2 months ago
Read
A PM’s Halloween Survival Guide
Articles
5 min read

A PM’s Halloween Survival Guide

Discover the spooky parallels between Halloween and project management, from scope creep monsters to ghosted team members, in this fun survival guide for PMs.

R
Ronald B. Smith, MBA, PMP
3 months ago
Read
Explore All Articles