Guide

S-curve in Excel: how to build it step by step, with an example

Short answer

An S-curve in Excel is built from an activity table (value, start date and end date), a formula that spreads each value across the days and a cumulative sum divided by the total. The guide gives the formula, a worked example and the most common mistakes; it does not offer a file to download.

Updated November 6, 2026 · Published by Renka Consulting

What you need and what it is for

An S-curve in Excel (or any spreadsheet) is built from a table of activities and a formula that spreads each activity's value over its days. Adding up by cut-off date gives the cumulative planned value, which is what the curve plots.

For each activity you need the planned value (its cost in the budget), the start date and the end date. To compare against reality you also need the physical progress measured at the cut-off date.

It is an easy sheet to maintain when one person keeps it. Its limit shows up when several people measure progress at the same time or when the plan changes often.

How the sheet is laid out

One row per activity and one column per cut-off date. These are the columns of the example sheet.

How the sheet is laid out
ColumnWhat it holdsExample cells
AActivity name (A2 to A5)A2:A5
BPlanned value in pesos (B2 to B5)B2:B5
CPlanned start date (C2 to C5)C2:C5
DPlanned end date (D2 to D5)D2:D5
E onwardsOne column per cut-off date: the date goes in row 1 and below it the cumulative planned value of each activityE1, E2:K5

The formulas, step by step

  1. In row 1, starting at column E, type the cut-off dates (weekly or monthly, including the start and the end of the project).
  2. In the first cell of the table (E2) enter the formula below and drag it right and down. Each cell says how much of that activity should be done by that date.
  3. Add up each column in a totals row: that row is the cumulative planned value (PV) at each cut-off date.
  4. Divide each total by the total project value if you want the curve as a percentage, and insert a line chart with the dates on the horizontal axis.
E2 = $B2 * MAX(0, MIN(1, (E$1 - $C2 + 1) / ($D2 - $C2 + 1)))

Written with Excel's English function names; the same functions have localized names in other languages.

Worked example

The same project as the S-curve guide: COP 400,000,000 with four activities. The values, dates and progress figures are invented for the example; the figures in the tables come from the same code the platform uses and match what the sheet formula would give.

Activities in the example
ActivityPlanned valueStartEndProgress measured at March 31
FoundationsCOP 60,000,0002026-01-012026-01-31100%
StructureCOP 120,000,0002026-02-012026-03-3150%
Masonry and roofCOP 90,000,0002026-03-012026-04-3020%
Finishes and building servicesCOP 130,000,0002026-04-012026-05-310%
Result of the totals row at six cut-off dates
Cut-off dateCumulative planned value% of total
2026-01-01COP 1,935,4840.5%
2026-01-31COP 60,000,00015%
2026-03-02COP 123,967,76931%
2026-04-01COP 229,344,26257.3%
2026-05-01COP 336,065,57484%
2026-05-31COP 400,000,000100%

At March 31 the plan said COP 225,737,705 should have been completed (56.4% of the project). What has been measured equals COP 138,000,000 (34.5%). Dividing what was done by what was planned gives 0.61: the project is behind the plan.

Common mistakes in the sheet

  • Dates typed as text: subtracting them gives an error or zero. Check that Excel right-aligns them.
  • Forgetting the first day when counting days: the formula adds one so that whole days are counted.
  • Overwriting a formula with a number without noticing: the curve is wrong and nothing warns you.
  • Changing the baseline every month without keeping the previous one: the planned curve stops being a reference.

When the spreadsheet stops being enough

If several people measure progress, if the plan is changed every week, or if you need the actual curve month by month and not only today's point, the sheet forces you to reconcile versions by hand. That is when a system that stores each measurement with its date helps. Until then, a well-kept sheet does the job.

Limits of this guide

It describes the straight-line spread of each activity's value, the general-purpose method. It does not replace critical-path scheduling and it does not set a mandatory way to draw the curve: your contract or your supervisor may ask for another. This guide does not offer an Excel file to download.

Frequently asked questions

How do I make an S-curve in Excel?

Build a table with value, start and end per activity, use a formula to work out how much should be done at each cut-off date, add up each column and plot the totals with a line chart.

Which formula spreads an activity's value?

The value multiplied by the fraction of days elapsed: the value times the smaller of one and the days since the start (counting the first day) divided by the total days, and never below zero.

Curve in pesos or in percentage?

In pesos if you use it inside one project; in percentage if you want to compare projects of different size.

Where can I download a template?

This guide does not include a file to download. With the column table and the formula you can build your own in a few minutes.

Sources

  • General-purpose method (planned value and earned value); it does not depend on a standard or on external data. The example figures are calculated by Renka's code and are invented for illustration.
S-curve in Excel: step by step · Renka Consulting