Yes. Excel for Microsoft 365 can plot negative values in a Stacked Area chart: select the category labels and data series, then choose Insert > Insert Line or Area Chart > 2-D Area > Stacked Area. Positive values stack upward from zero and negative values stack downward, so the chart does not show them as one ordinary cumulative total.
How a stacked area chart handles negative values
A stacked area chart adds the series values at each category, such as a month, and fills the area between the series boundaries. With positive-only data, each series builds on the previous one above the horizontal axis. When values are negative, Excel stacks the negative contributions below zero, separately from the positive contributions above zero.
For example, suppose a month has three series with values 10, -4, and 6. The positive regions rise to a combined height of 16, while the negative region extends to -4. The net sum is 12, but that net figure is not the upper boundary of the positive stack. This distinction matters: the chart shows positive and negative magnitudes on opposite sides of zero, rather than a single running total that nets them together.
The horizontal zero line is therefore a meaningful reference, not just an axis decoration. A series can change direction from one category to the next, crossing from the upper region to the lower one. The chart can show this, but overlapping filled shapes may make individual series harder to follow than they would be in a line chart.
Prepare the data before inserting the chart
Lay out the worksheet with one row or column for category labels and a separate series for each measure. For example, put months in A2:A7, Revenue in B2:B7, Adjustments in C2:C7, and Costs in D2:D7. Enter negative amounts with a minus sign, and make sure each series has a value aligned with the correct month.
Keep the categories in chronological or otherwise meaningful order. Stacked area charts connect adjacent points, so an unsorted list can create a misleading shape. Also check that values are genuinely signed quantities. A cost might be recorded as a negative contribution if the goal is to show its direction relative to a total; if costs are stored as positive values, Excel will stack them upward instead.
- Use clear series names in the header row or column. Excel uses these names in the legend.
- Use consistent units across the series, such as dollars throughout or units throughout.
- Check for blanks, text entries, and accidental zeros. A blank may be treated differently from an entered zero in a chart.
- Avoid merging cells in the chart data range, since merged headers can complicate selection and series labels.
Create the chart in Excel for Microsoft 365 on Windows
Select the complete data range, including the category labels and series headers. On the ribbon, choose Insert > Insert Line or Area Chart, then under 2-D Area select Stacked Area. Excel creates a chart with the series represented as filled layers. If Excel puts months in the legend and data series along the horizontal axis, select the chart and use Chart Design > Switch Row/Column.
If you already have a chart, you can change its type without rebuilding it. Select the chart, choose Chart Design > Change Chart Type, and select Stacked Area under the area chart options. The exact arrangement of chart galleries can vary slightly with window size or ribbon layout, but the chart type is named Stacked Area.
Excel for Mac has the same general chart type. Select the data and use the Insert tab to choose a stacked area chart; ribbon labels and gallery layout can differ between Mac releases. Excel for the web also offers chart creation, though some formatting controls may be more limited or arranged differently than in the Windows desktop app.
Read the chart without confusing totals
Read the area boundaries relative to zero. The top boundary of the positive stack represents the sum of positive series at that category. The bottom boundary represents the combined negative values extending downward. If a reader needs the net result, calculate or display that net separately rather than expecting the upper boundary to show it.
For instance, imagine a chart of monthly additions, corrections, and removals. Additions of 120 and corrections of 15 could stack upward to 135, while removals of -30 extend below zero. The net change is 105, but neither outer boundary by itself equals 105. A separate net-change line or a small data table can make the distinction clear.
Stacked area is most useful when the focus is on the broad combined magnitude and how components contribute over an ordered sequence. It is less effective when the key question is how each series moves independently. Only the bottom layer has a fixed baseline; the other layers sit on top of changing totals, which makes their individual rises and falls harder to judge accurately.
Format the zero line, scale, and labels
Excel usually includes zero in the value-axis range when a series contains negative values. If the axis range is too wide or too narrow, right-click the vertical value axis and choose Format Axis. Under Axis Options, review the Minimum and Maximum bounds. Automatic bounds are often a sensible starting point; fixed bounds can help when comparing several charts, but they can also clip data if chosen carelessly.
To make the baseline easier to see, format the horizontal axis line or add a subtle gridline at zero if the layout permits. The axis crossing controls are in the Format Axis pane, but their wording and available choices depend on which axis is selected. Avoid moving the horizontal axis to the bottom of the plot just to make the chart look conventional: doing so can hide the most useful reference for signed data.
Use a restrained color palette and distinguish series with both color and legend labels. Strong transparency can reveal overlaps, but excessive transparency may make colors muddy. Data labels on every point often crowd an area chart; consider labeling only important points or showing the underlying values in a nearby table.
Choose the right stacking order
Series order affects the visual layers. To change it, select the chart and choose Chart Design > Select Data. In Legend Entries (Series), select a series and use the move controls to reorder it. The series closest to the baseline is generally easiest to compare because it has a consistent reference; upper layers are harder to assess precisely.
Put the series that readers most need to track near the baseline, and keep the legend in an order that matches the visual layers. If there are many series, the chart can become difficult to read even when the data are correct. Combining minor categories, using fewer series, or switching to a different chart type may help more than adding colors or labels.
When another chart is clearer
A regular Stacked Area chart is not the only option for signed data. Choose a chart based on the question the reader needs answered, not simply on whether Excel accepts negative numbers.
- Line chart: Prefer this when comparing the direction and exact pattern of several individual series is more important than showing their combined area.
- Clustered column chart: Consider this for a modest number of discrete periods, especially when comparing positive and negative values around a visible zero line.
- Waterfall chart: Use this when the main story is how sequential increases and decreases build from a starting amount to an ending amount. It is not a replacement for showing multiple changing series over time.
- Stacked area: Keep it when the emphasis is on cumulative positive and negative contributions across a continuous sequence and readers can interpret the separate sides of zero.
A 100% Stacked Area chart is intended to emphasize proportions rather than absolute totals. With signed values, the idea of each component being a share of a positive whole becomes difficult to interpret. For a dataset that includes meaningful negatives, a standard stacked area or a chart that plots each series against zero is usually easier to explain.
Common problems and fixes
If negative values appear to be missing, check that they are numeric values rather than text. A value imported with a leading apostrophe, unusual dash character, or incompatible number format may not be treated as a number. Click a cell and inspect its contents, then correct the source data before changing the chart type.
If the chart seems to show the wrong categories, use Chart Design > Select Data to check the chart data range and horizontal axis labels. If series and categories are reversed, try Chart Design > Switch Row/Column. If the chart has an unexplained break, inspect the source cells for blanks and review how Excel is plotting empty cells through Select Data and Hidden and Empty Cells.
If the areas look like they hide one another, that is partly inherent to the chart: filled layers are drawn in a stack, not as independent lines. Reordering can improve emphasis, but it cannot make every layer equally easy to compare. A line chart or a separate panel for positive and negative series may be a better presentation.
Frequently Asked Questions
Can an Excel stacked area chart show negative numbers?
Yes. Excel plots negative values below zero and stacks them separately from positive values, which extend upward. Check the zero baseline and explain that the two sides do not represent one netted stack.
Why does the top of my chart not equal the net total?
The top boundary is the sum of the positive values at that category. Negative values are accumulated below zero, not subtracted from that upper boundary. Display a calculated net separately if readers need it.
Can I use a 100% stacked area chart with negative values?
It is usually a poor choice for signed data. Percent-of-total charts imply components form meaningful shares of a whole, which negative contributions can undermine. Use a standard stacked area or another chart type when direction matters.
How do I change which series is in front?
Select the chart, open Chart Design > Select Data, and reorder the entries under Legend Entries (Series). The order changes the layers, but it does not change the values or their signs.
Should I use a stacked area chart or a line chart?
Use stacked area when the combined contributions are central to the story. Choose a line chart when you need readers to compare individual series over time, especially when positive and negative movements cross zero.
Related
- Excel Shortcut for Selecting a Column in One Step
- Excel Shortcut for Filtering a Table: Keys and Tips
- Excel Shortcut for Inserting a Row on Windows and Mac
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table Repeat Row Labels: How to Do It EasilyTo repeat row labels in an Excel PivotTable, select the PivotTable, choose PivotTable Design > Report Layout >…
- Excel Histogram: Change the Number of Bins or Bin WidthTo change an Excel histogram’s bin count in Microsoft 365 for Windows, click the chart’s horizontal axis, right-click…
- Google Sheets Chart Series Name: Meaning and FixesIn Google Sheets, a chart series name is the label that identifies one set of plotted values, usually…
- Excel Double Column Chart: Create, Compare, and Format DataIn Excel for Microsoft 365 on Windows, a “double column chart” usually means a clustered column chart that…
- Pivot Table in Excel Not Working? Fix Common CausesIf a PivotTable in Excel is not working, first select a cell inside it and choose PivotTable Analyze…
- How to Make a Chart in Excel From Your DataTo make a chart in Excel, select the cells containing your data, choose Insert > Recommended Charts, pick…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.