Line of Balance Spreadsheet: Build and Track Projects

How-to basics · Updated November 22, 2026

A line of balance spreadsheet is a project schedule that plots when repetitive work is planned at each location or production unit. In Excel, organize each activity by quantity, production rate, and start time, then chart time against cumulative units completed; the resulting lines help show workflow, handoff gaps, and potential crew conflicts.

What a Line of Balance Spreadsheet Shows

Line of balance (LOB) is a planning method for projects where similar work repeats across locations or units. Examples include building the same tasks on several floors, installing utilities along road sections, or completing identical work packages across a set of houses. Instead of showing only task dates, an LOB schedule connects time with the progress of each activity through those units.

A typical chart has time on the horizontal axis and location or cumulative units on the vertical axis. Each activity appears as a line. Its position indicates when the crew reaches each unit; its slope represents the planned production rate. A steep line on a chart with time on the horizontal axis indicates more units completed per day. Different software and textbooks may choose different axis orientations, so label both axes clearly.

The spreadsheet is the calculation and data source; the chart is the visual schedule. There is no single official Excel template that suits every project. A useful one keeps assumptions visible, makes the activity sequence understandable, and allows the schedule to be updated when quantities or production rates change.

How the Lines Represent Production

For a simple plan, each activity has a quantity, a production rate, and a start time. If a crew is expected to complete 10 floors at 2 floors per day, its planned production duration is five elapsed days. A line from zero to 10 completed floors over that interval represents the assumed steady pace. Real crews rarely produce at a perfectly constant rate, so treat the line as a planning model, not a promise of exact daily output.

The space between two sequential activity lines matters. If one crew must finish a location before the next begins there, the schedule needs an appropriate handoff gap. Lines that run at the same rate remain parallel, preserving that gap. If a following crew has a faster rate, it may catch the earlier crew; if the lines cross, the plan may imply that the later task overtakes work it depends on. That is a signal to review the sequence, rates, buffers, or work zones.

LOB is most informative when work is genuinely repetitive. A one-off design approval or a project with unrelated tasks may be better represented by a conventional precedence network or Gantt chart. Many schedules use more than one view: a network to represent logic and an LOB chart to manage production flow across locations.

Build the Calculation Table in Excel

In Excel for Microsoft 365 on Windows, create a worksheet with these columns: Activity, Quantity (units), Rate (units per day), Start (elapsed day), Duration (days), and Finish (elapsed day). Use the same unit and time basis throughout. For a first model, elapsed days are simpler than calendar dates; day 0 means the project’s chosen starting point.

For example, suppose the first activity has 10 units, a rate of 2 units per day, and a start time of day 0. Put its quantity in B2, its rate in C2, and its start time in D2. With those column headings, calculate duration in E2 using =B2/C2. The result is 5 days. Calculate its finish coordinate in F2 with =D2+E2; the result is day 5. Enter corresponding values for other activities and fill the formulas down. Check that quantities and rates are positive and that the rate uses the same unit as the quantity.

This finish value is a continuous elapsed-time coordinate, not necessarily a numbered workday on an inclusive calendar. If a task starts at day 0 and takes five elapsed days, its finish coordinate is day 5. If you instead want working dates that skip weekends or holidays, add a calendar-based method and define the workweek and holiday rules; do not silently treat calendar days as working days.

To draw the LOB chart, make a small helper table with two points per activity: its start time with zero units complete, and its finish time with the full quantity complete. For a 10-unit activity starting at day 0 and finishing at day 5, those points are (0, 0) and (5, 10). This cumulative-progress convention makes the line easy to calculate. Some plans use location numbers starting at 1 instead; just state the convention and apply it consistently.

Create the Line Chart

Excel needs each activity’s two endpoints as a separate data series. In the helper table, place each activity’s start and finish points on two adjacent rows, with columns for Activity, Time, and Units complete. For example, rows 2–3 could hold the two points for framing, rows 4–5 for mechanical work, and rows 6–7 for drywall. The activity name is a label; the time and unit columns provide the plotted coordinates.

  1. Select a blank cell, then choose Insert > Scatter (X, Y) > Scatter with Straight Lines.
  2. On the chart, choose Chart Design > Select Data > Add to create a series for the first activity.
  3. Set the series X values to that activity’s two time cells and its Y values to the matching two units-complete cells. Repeat for each activity.
  4. Add axis titles, a chart title, and a legend that identifies the activities. Label the horizontal axis with the time unit and the vertical axis with floors, sections, or another location unit.

An XY scatter chart is appropriate because time is a numeric scale, not merely a list of categories. If dates are used, ensure the time cells contain real Excel dates rather than text that only looks like a date. The instructions above are for Excel for Microsoft 365 on Windows. Excel for Mac also has scatter charts and chart-data controls, though ribbon layout can differ; Excel for the web may present a more limited or differently arranged chart-editing interface.

Worked Example: Ten Repeated Floors

Consider a 10-floor building with three sequential activities: framing at 2 floors per day, mechanical work at 2 floors per day, and drywall at 1 floor per day. Assume framing starts at elapsed day 0, mechanical work at day 3, and drywall at day 6. These are illustrative planning assumptions, not standard rates. Using the table formula, framing takes 5 days and finishes at day 5; mechanical takes 5 days and finishes at day 8; drywall takes 10 days and finishes at day 16.

The helper-table endpoints are framing (0, 0) to (5, 10), mechanical (3, 0) to (8, 10), and drywall (6, 0) to (16, 10). Framing and mechanical have equal rates, so their lines are parallel, with a three-day start offset. Drywall progresses more slowly, so its line is flatter and takes longer to reach the tenth floor. At day 8, the model shows framing and mechanical complete, while drywall has completed two floors. That result follows from its start at day 6 and rate of one floor per day.

This simple example assumes a constant rate and clean handoffs. A practical schedule may need buffers for inspections, material delivery, access restrictions, or uneven floor conditions. If a predecessor must be complete before the successor starts on each floor, check the timing at individual locations, not just the overall finish dates.

Read and Maintain the Schedule

Read the chart from left to right to follow time, and compare lines at the same location to understand the planned handoff. A gap can represent a deliberate buffer, a wait for inspection, or an avoidable delay. A tight gap can support continuous crew flow, but may leave too little room for variation. The best interval depends on dependencies, workspace, safety controls, and the project’s operating assumptions.

Update actual progress separately from the original plan. One practical approach is to maintain a baseline table and a current forecast table, each with its own start, rate, and finish assumptions. Record the date and source of changes. Replacing the baseline with new estimates makes it harder to see whether production is ahead of or behind the original commitment.

  • Use consistent units, such as floors throughout, rather than mixing floors, rooms, and percentages without a clear conversion.
  • Record whether rates mean units per calendar day, working day, shift, or crew-hour.
  • Show assumptions about crew availability, work zones, handoffs, and planned nonworking periods.
  • Compare forecast progress with actual quantities completed, not just elapsed time.

Common Errors and Limits

A frequent mistake is treating the line as evidence that production will be steady. The slope is a target or forecast based on an assumed rate; actual output may vary. Another is comparing rates that use different units or calendars. For example, a rate per working day cannot be compared directly with a start-to-finish interval measured in calendar days unless the calendar conversion is explicit.

Lines can also look orderly while hiding important constraints. A single line for an activity may conceal different crews, access limits, curing or inspection time, or a location that cannot be worked simultaneously with another. Break the plan into zones or separate crews when that distinction changes the sequence or rate. Conversely, adding too many detailed series can make a chart unreadable; keep supporting detail in the worksheet and chart the level that helps people make decisions.

A line crossing is a warning to investigate, not automatic proof that the schedule is impossible. Activities may be independent, use separate work areas, or follow a different local sequence. But where a successor depends on a predecessor at each location, a crossing can expose an inconsistent rate or start plan. Confirm the logic with the people responsible for the work.

When to Use a Spreadsheet or Another Tool

Excel is a reasonable choice for a small or moderately sized repetitive project when the team needs a transparent schedule, familiar formulas, and a chart that can be adjusted quickly. It also makes assumptions easy to inspect. Its limits become more apparent when many locations, calendars, resource constraints, dependencies, or frequent updates need to be coordinated. A spreadsheet does not automatically resolve those constraints just because its lines look balanced.

For a project with complex task logic, a Gantt chart or critical-path schedule may show dependencies and milestones more clearly. For repetitive production, an LOB chart can reveal the pace and handoffs more directly. A project scheduling application may be useful when the plan needs shared updates, resource assignments, baseline tracking, or automated calendar logic. These tools can complement rather than replace one another: choose the view that answers the planning question, and keep the underlying quantities and assumptions consistent.

Frequently Asked Questions

What does a line of balance chart show?
A line of balance chart shows planned activity progress across repeated locations over time. The line’s slope represents the planned production rate, while its position relative to other lines helps reveal handoff timing and possible conflicts.

How do I make a line of balance chart in Excel?
Calculate a start and finish time for each activity, create two time-and-progress points per activity, then add each pair as a separate series in an XY scatter chart with straight lines. Label the axes and confirm that all activities use consistent units.

Is a line of balance the same as a Gantt chart?
No. A Gantt chart emphasizes task durations across a timeline. An LOB chart emphasizes how repeated work progresses across locations as time passes. A project may use both views for different planning needs.

What does it mean when LOB lines cross?
Crossing lines can mean that a following activity is forecast to catch or overtake a predecessor. Check the location-by-location dependencies, rates, start times, and work zones before deciding whether the plan is actually infeasible.

Can I use calendar dates instead of elapsed days?
Yes. Use real Excel date values and a consistent rate basis. If production occurs only on working days, account for the project calendar and holidays rather than assuming that every calendar day is a production day.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.