Excel Stacked Line Chart Explained

An Excel stacked line chart plots each series as a running total of the series before it, rather than showing every series from a shared zero baseline. In Microsoft Excel for Microsoft 365 on Windows, select your data, then choose Insert > Insert Line or Area Chart > Stacked Line; use this chart when the cumulative total matters more than comparing each series’ individual values.

What a stacked line chart shows

A regular line chart draws each data series independently. If three products sell 10, 5, and 3 units in a month, their lines show 10, 5, and 3. A stacked line chart instead draws the first series at 10, the second at 10 + 5 = 15, and the third at 10 + 5 + 3 = 18. The top line therefore represents the combined total across the series.

The lines between the bottom and top boundaries represent contributions added to earlier series. Their vertical positions are cumulative, not the original values in the source table. That distinction is crucial: the second product’s value is 5, even though its plotted upper boundary is at 15. The thickness between its boundary and the first series’ line corresponds to its contribution, but the chart does not make that difference as immediately readable as a standard line chart does.

Excel offers both a Stacked Line chart and a 100% Stacked Line chart. The first displays cumulative values in the units in your data. The 100% version scales each category to 100%, showing how cumulative shares change over time instead of how totals change.

How Excel builds the lines

Excel reads the series in the order they appear in the chart. It plots the first series on its own, then adds the second series’ values to the first, then adds the third to the previous cumulative result, and so on. For example, with monthly ticket counts arranged as Billing, Delivery, and Account, January values of 10, 5, and 3 produce cumulative positions of 10, 15, and 18. If February values are 12, 4, and 6, the positions become 12, 16, and 22.

Changing series order changes which contribution sits above which, although the final total remains the same. This can affect how easy the chart is to read. The bottom series has a stable zero baseline, while the next series is measured from the changing boundary beneath it. Higher series have even less stable reference points. A rising boundary does not necessarily mean that the series represented by the space beneath it rose; it may reflect changes in several earlier series.

Categories usually appear along the horizontal axis, such as months, dates, or stages. Excel connects the plotted points in category order. For a time series, arrange dates chronologically in the worksheet; a chart generally follows the order of the source categories rather than correcting a misordered list for you.

When a stacked line chart is useful

Use this chart when you need to show both a changing overall total and how several nonnegative components contribute to that total over a sequence. It can be useful for tracking a combined workload, total energy use by source, or the cumulative number of requests across departments. The top line makes the total visible, while the lower boundaries show how the composition builds up.

Consider a support team tracking Billing, Delivery, and Account tickets each month. A stacked line chart can make it easy to see that total tickets have grown from 18 to 22 while the mix of ticket types has also changed. If the main question is instead whether Billing tickets rose from 10 to 12, a standard line chart is usually clearer because the Billing line is not affected by the other categories.

Choose a stacked line chart when the cumulative total and its changing composition are the main story.
Choose a standard line chart when readers need to compare each series’ actual values directly.
Choose a 100% stacked line chart when the share of the total matters more than the total size.

How to create one in Excel

Arrange the data in a rectangular table. Put category labels, such as months, in the first column and series names in the first row. Place one numeric value at each category-and-series intersection.
Select the table, including its labels. On the ribbon, choose Insert > Insert Line or Area Chart > Stacked Line. Choose 100% Stacked Line instead if you want to show proportions.
Check that Excel assigned the categories and series correctly. If the lines represent months while the horizontal axis shows product names, select the chart and choose Chart Design > Switch Row/Column.
Add a descriptive chart title and, if useful, axis titles or a legend. Select the chart, then use Chart Design > Add Chart Element to find these options.
Review the series order and labels. If you need a different series order, use Chart Design > Select Data and adjust the series list in the Select Data Source dialog.

If you already have a chart, you can change its type without rebuilding the source table: select the chart and choose Chart Design > Change Chart Type. Excel for Mac has similar chart-creation and chart-design controls, though ribbon placement and dialog presentation can differ slightly. In Excel for the web, available chart-editing controls can vary; if a particular design option is missing, open the workbook in the desktop app.

Preparing data and choosing a layout

A clear source table makes the chart easier to interpret and update. Use one header row for series names, one category label per row, and consistent units across the series. Avoid including subtotals or a total column as another series: Excel will stack that total on top of the component values and exaggerate the displayed total.

For example, a suitable layout might have Month in column A, Billing in column B, Delivery in column C, and Account in column D. Each month occupies one row. Keep the series names descriptive and short enough to fit in the legend. If there are many categories or series, consider whether the chart will remain legible at the size readers will see it.

Missing values deserve attention. A blank is not the same as a measured zero: a zero says the component had no value, while a blank may mean the value is unknown or unavailable. Select the chart, choose Chart Design > Select Data, and use Hidden and Empty Cells to review how empty cells are displayed. Excel provides options such as showing empty cells as gaps, as zero, or connecting data points with a line. Choose based on what the source data means, not just on which option makes the picture look continuous.

Stacked line versus other chart types

A standard line chart is often the better choice for comparing trends across several independent series. Every line uses the same vertical scale and baseline, so a value of 5 means the same vertical position wherever it appears. In a stacked line chart, only the bottom series has that direct baseline; upper series are offset by earlier ones.

A stacked area chart uses the same cumulative logic but fills the spaces between boundaries. The filled bands often make part-to-whole composition easier to see, especially when the overall total is important. However, area fills can obscure smaller series, and the same moving-baseline limitation applies to comparing exact values. A regular area chart, by contrast, does not necessarily stack series.

A 100% stacked line chart expresses each series as a share of its category’s total. When all values are positive, the top cumulative boundary is 100% at each category. This can reveal that one component’s share is growing even if the total itself is falling. It hides changes in absolute size, though: a category with 100 total units and one with 1,000 units can both add up to 100% on the chart.

Common problems and ways to improve readability

Readers mistake cumulative positions for individual values. State in the title or a note that the chart is stacked. If exact values matter, add data labels selectively or provide a companion table or standard line chart.
The series order tells the wrong visual story. Put the most important or most stable series at the bottom when that makes sense, and check the order after chart creation. Avoid implying that an upper series has a fixed baseline.
Too many lines make the display crowded. Limit the chart to meaningful components, group minor categories where appropriate, or use small separate charts. A long legend and many crossings can make the story difficult to follow.
Colors are hard to distinguish. Use clearly different colors and do not rely on color alone. Keep the legend visible, use markers when they help distinguish points, and check contrast for readers with color-vision differences.
Negative values make the total confusing. Stacking is easiest to interpret when components are nonnegative contributions to a total. If values include gains and losses or mixed positive and negative amounts, a standard line chart or another carefully chosen visualization may communicate the data more honestly.
The chart uses the wrong orientation. If dates appear as separate lines instead of the horizontal categories, use Chart Design > Switch Row/Column and confirm that the legend and axis labels now match the intended meaning.

For crowded charts, simplify the time span, remove unnecessary gridlines, and format the vertical axis with sensible units. Avoid smoothing lines if it could suggest values between observations that were not measured. A clear title should name the measure and, where needed, indicate that the values are cumulative or percentages.

Frequently Asked Questions

What is the difference between a line chart and a stacked line chart in Excel?
A line chart plots every series independently from the same value scale. A stacked line chart adds each series to the preceding series, so the upper lines show cumulative positions and the top line shows the combined total.

How do I make a 100% stacked line chart in Excel?
Select the data, then choose Insert > Insert Line or Area Chart > 100% Stacked Line. Excel converts each category’s component values into shares of that category’s total, so the chart shows composition rather than absolute totals.

Why are the values on my stacked line chart different from my worksheet?
The worksheet contains each series’ individual values, but the chart’s upper boundaries are cumulative sums. A series with a value of 5 may have its boundary plotted at 15 because an earlier series contributed 10.

Can I change the order of lines in a stacked line chart?
Yes. Select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, adjust the order of the series. Their cumulative positions will change, so check that the revised order still supports a fair interpretation.

Should I use a stacked line chart or a stacked area chart?
Use a stacked line chart when you want unfilled boundaries and a lighter visual treatment. Use a stacked area chart when filled bands make the changing composition easier to see. Both stack values, so neither is ideal for precise comparison of upper-series values.

Can a stacked line chart show percentages?
Yes. Choose 100% Stacked Line to show each series’ proportion of the total at each category. This is useful for comparing mix over time, but it does not show whether the underlying total is increasing or decreasing.

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.