Excel Cumulative Line Graph: How to Create One

To make a cumulative line graph in Excel, add a running-total column beside your values, then chart the dates or categories against that column. If your values are in B2:B13, enter =SUM($B$2:B2) in C2 and fill it down; select the category column and cumulative column, then choose Insert > Insert Line or Area Chart > 2-D Line.

What a cumulative line graph shows

A cumulative line graph plots a running total: each point equals the current value plus all earlier values in the chosen sequence. The line therefore shows how a total builds over time or across an ordered set of categories. It is useful for tracking year-to-date sales, project expenses, units produced, sign-ups, rainfall, or other quantities that accumulate.

Excel does not have a separate chart type called a cumulative line graph. You calculate cumulative values in worksheet cells and display those values with a standard line chart. This distinction matters: choosing a line chart alone does not make the data cumulative. If you chart the original values, the result shows each period’s individual amount, not the running total.

The order of the rows defines the order in which the total accumulates. For dates, sort the entire data range by date from oldest to newest before calculating the running total. For categories, arrange them in the sequence that makes sense for the question. A cumulative total across unsorted or inconsistently ordered rows may be mathematically correct but tell a misleading story.

Set up the worksheet

Put one observation on each row, with a label or date in the first column and a numeric value in the next. Add a third column for the running total. For example, use headings Date, Sales, and Cumulative Sales in A1:C1, with the first observation in row 2. Keep the values in one consistent unit, such as dollars or units sold.

With the individual amounts in B2:B13 and the cumulative results beginning in C2, enter =SUM($B$2:B2) in C2. The dollar signs keep the first cell of the range fixed, while the second reference moves down as the formula is copied. Fill the formula down through the last data row. In row 2 it totals B2; in row 3 the copied formula totals B2:B3, and each subsequent row expands the range by one value.

Check the final cumulative value against the sum of the original values. If there are 12 observations, the value in C13 should equal the total of B2:B13. This quick check can catch a missed row, a formula that was not filled all the way down, or data stored as text rather than as numbers. Blank cells are treated as zero by SUM, but text entries that look like numbers may need to be converted.

Create the line chart in Excel

Confirm that dates or categories are in column A and the cumulative figures are in column C, with headings in row 1.
Select A1:A13. Hold Ctrl on Windows and select C1:C13 as well, so the chart uses the labels and cumulative values without plotting the original amounts in column B. On a Mac, hold Command while selecting the second range.
Choose Insert > Insert Line or Area Chart > 2-D Line. Excel inserts a chart using the selected labels and running totals.
Click the chart title and replace it with a specific description, such as Cumulative Sales by Month. Add axis titles if readers may not know the units: use Chart Design > Add Chart Element > Axis Titles.
Check the horizontal axis labels and the first and last plotted values. If Excel has included the wrong series or labels, use Chart Design > Select Data to review the chart’s data range and series.

If selecting separate ranges is awkward, place the category labels and cumulative values next to each other in a small helper range and chart those two columns. Avoid selecting A:C as a single block unless you also want Excel to plot the original values in column B; otherwise the chart may show both the individual-period series and the cumulative series.

Worked example: monthly sales

Suppose monthly sales are 120, 80, 150, and 50 units. The cumulative figures are 120 after month one, 200 after month two, 350 after month three, and 400 after month four. The plotted line rises by 80 units between the first and second points, then by 150, then by 50. The height of a point represents the total so far; the steepness of a segment reflects the amount added during that interval.

This is different from plotting the monthly sales themselves, which would give points of 120, 80, 150, and 50. That ordinary line would rise, fall, rise, and fall, because it shows each month’s amount. The cumulative line rises throughout this example because all four values are positive. If the underlying data includes returns, refunds, or losses, the cumulative line can fall when a negative amount is added.

Choose a line with markers when the exact observation periods matter, especially for a small number of dates or categories. For many closely spaced observations, a plain line can be less cluttered. Use a descriptive title and, where useful, number formatting such as currency or whole numbers on the vertical axis. The axis should communicate the unit without requiring a reader to infer it from the worksheet.

Show cumulative percentages

A cumulative percentage answers a different question from a running total: what share of the overall total has accumulated by each point? It is helpful when comparing progress across datasets of different sizes, or when communicating how much of a total has been reached. The denominator should cover the complete set of observations, not just the current row.

With amounts in B2:B13 and the first cumulative percentage in C2, enter =SUM($B$2:B2)/SUM($B$2:$B$13) in C2 and fill down. Format the results as Percentage using Home > Number. For the example amounts 120, 80, 150, and 50, the total is 400, so the percentages are 30%, 50%, 87.5%, and 100%. Chart the category labels against these percentage values and label the vertical axis as Cumulative percentage.

For nonnegative values, the final cumulative percentage should be 100%, subject to display rounding. Negative values can make the percentage decline or behave unexpectedly, and a zero overall total makes the calculation invalid. In those cases, check whether a percentage-of-total chart is appropriate before presenting it. A Pareto chart is a related but different display: it typically orders categories from largest to smallest and overlays a cumulative-percentage line on columns. A chronological cumulative line should generally preserve chronological order instead.

Make the chart easier to read

Choose a horizontal axis that matches the data. If the labels are dates, Excel may display them at uneven intervals or treat them as text depending on the source data and chart settings. If the chart’s date spacing looks wrong, right-click the horizontal axis, choose Format Axis, and review Axis Options and the Axis Type choices available for that data. A date axis spaces dates according to elapsed time; a text axis spaces each label equally.

For a cumulative total, a vertical axis beginning at zero often helps readers judge the scale and compare values. A very large starting value or a narrow axis range can exaggerate small changes in the line. On the other hand, an axis that begins at zero may make small changes hard to see when totals are large. If you adjust the bounds, make the scale clear and avoid suggesting that small movements are larger than they are.

Use units in the title, an axis title, or number formatting. Keep gridlines subtle and avoid unnecessary effects that compete with the data. If you add a trendline, explain its purpose: a trendline summarizes a pattern but is not the same as the cumulative series and does not change the underlying running-total calculation.

Common problems and what to check

The line shows period values, not a running total: Check that the chart’s series points to the cumulative column, not the original values column.
The total starts over unexpectedly: Inspect the formulas for a fixed range such as =SUM($B$2:B2). If the first reference moved while filling down, the formula may be totaling only part of the history.
The line skips or ends too early: Look for missing formula cells, gaps in the source range, or rows excluded from the chart. Use Chart Design > Select Data to inspect the plotted range.
The graph is in the wrong order: Sort the full dataset by its date or intended sequence. Sorting only one column can separate values from their labels and corrupt the relationship between them.
The line drops even though the measure should only increase: Look for negative entries, corrections, or refunds. If all source values should be nonnegative, check for mistaken signs or incorrect source data.
The chart plots a blank or zero unexpectedly: Check whether a source cell contains zero, a formula returning an empty string, or text that resembles a number. These are not always treated identically in charts.

When a cumulative line is—and is not—the right choice

Use a cumulative line when the reader needs to see accumulated progress or total-to-date across an ordered sequence. It is especially informative when the rate of accumulation matters: a steeper segment means a larger addition over that interval, while a flatter segment means little was added. If intervals have different lengths, however, segment steepness is not a fair comparison of rates unless the time spacing is considered.

Use a regular line chart when the goal is to compare the value in each period, such as monthly temperatures or weekly sales. Use columns when individual category amounts need direct comparison. Use a cumulative-percentage line when the audience needs proportions of a whole, and consider a Pareto chart when categories are intentionally ranked from largest to smallest. The right choice depends on whether the question is about individual values, accumulated totals, or shares of a total.

If the data will be extended regularly, converting the range to an Excel table with Insert > Table can make it easier to add rows and maintain consistent formulas and formatting. A chart based on a table can generally include newly added table rows. Still, check that the chart’s source includes the new observations and that the cumulative formula has filled into the added rows; do not assume either happened without looking at the result.

Frequently Asked Questions

Is a cumulative line graph the same as a running-total chart? Yes. “Running total” describes the calculation, while “cumulative line graph” describes a line chart that plots those running totals in sequence.

How do I make the cumulative total start at zero? Add a starting point with a value of zero before the first observation, if that presentation suits your data. Otherwise, the first plotted point is normally the first observation’s value, because that is the first running total.

Can a cumulative line graph go down? Yes, if a negative value is added, such as a refund or a loss. With only nonnegative values and a correctly calculated running total, it should stay level or rise.

Why does my cumulative percentage not end at 100%? Check that the denominator includes every intended value, the chart includes the last row, and the source figures are numeric. Rounding can make the displayed endpoint look slightly different, but the underlying result should equal the complete total divided by itself when that total is nonzero.

Can I make a cumulative chart without a formula? The chart needs cumulative values somewhere in its source data. You can calculate them with worksheet formulas, enter them manually, or obtain them from another data process, but a standard line chart will not automatically convert ordinary values into a running total.

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.