An area chart turns a rise from 40 to 50 into a larger patch of color, not merely a higher point on a line. It shows a quantity across an ordered scale, usually time, by filling the space beneath the line. That fill makes magnitude conspicuous, but it can also make the wrong comparison look convincing.

The first decision is what the color should mean. Does each region show an independent quantity, or does it contribute to a shared total? That distinction governs how you read the chart and how you prepare its data in Excel.

In This Article

• Understand What the Fill Represents
• Choose the Right Type
• Read a Stacked Example
• Arrange the Source Data
• Build the Chart in Excel
• Make the Chart Easy to Read
• Know When to Use Another Chart
• Key Takeaways
• Frequently Asked Questions
• What the Fill Reveals

Understand What the Fill Represents

The top edge of a single filled series marks its values; the shaded region extends to a baseline. The horizontal axis usually carries dates or times, while the vertical axis measures something such as revenue in dollars. An area line chart uses this same construction: a line supplies the boundary, and the fill gives the quantity visual weight.

That visual weight has a history. William Playfair’s The Commercial and Political Atlas (1786) introduced early area charts alongside line and bar charts. In that volume, he plotted the value of England’s imports and exports across years. The subject suited connected observations: trade changed through time, and the reader could follow its course.

A connection still makes a claim, even when the software draws it automatically. A slope between monthly observations suggests a transition without showing what happened on intervening days. Dates support that reading; unrelated departments arranged side by side do not. Unlike separate bars, a filled boundary invites the eye to follow a continuous sequence. Put unrelated categories along that boundary and you manufacture a journey.

Choose the Right Type

Choose the arrangement by asking what calculation connects the series. Independent measurements need their own baselines. Additive components can share a stack; components expressed as shares can fill a percentage scale. In each case, identify the question first, then judge whether the fill makes its answer readable.

Standard and Overlapping Fills

A standard area chart displays one series from its baseline. Add another independent series and the fills can overlap on the same vertical scale. Reservoir storage at two sites, for example, might warrant comparison without implying that the sites form a single reservoir. Each series retains its own upper boundary.

The danger is literal concealment. A large foreground region can cover the smaller series, making a steady quantity appear to vanish. Transparency exposes some covered boundaries, but the blended colors may resemble extra categories. Drawing order matters too: whichever fill sits in front gets the clearest showing.

Keep an overlapping comparison small enough that readers can follow every boundary. If the series cross repeatedly, a line chart usually preserves the comparison with less visual interference.

Stacked Fills

A stacked area chart places each component above the preceding one. The outer boundary gives the total, and each band’s thickness gives its contribution. Support requests divided into mutually exclusive contact channels fit this structure: the units and reporting periods match, and each request enters the total once.

Temperature readings from different cities do not fit. Stack a city at 20 degrees above another at 15 degrees and the chart acquires a 35-degree summit that describes neither place. The arithmetic works; the supposed total does not.

Sales categories need a different check. If one transaction belongs to two categories, stacking counts it twice. Establish what belongs in the sum before giving that sum a persuasive silhouette.

Percentage-Stacked Fills

A percentage-stacked chart makes every position on the horizontal axis total 100%. Its bands show composition, so the question becomes which groups are gaining or losing share. Population groups younger than 30, ages 30–60, and older than 60 could form such a display, provided their definitions remain consistent.

A shrinking share does not necessarily mean a shrinking count. One group can grow while others grow faster, leaving it with a narrower band. The percentage chart deliberately discards total size to expose that relative change.

When total size matters too, provide a separate total series or a compact companion chart in the original units. Otherwise, the reader cannot distinguish a changing mix within a growing population from the same mix within a shrinking one.

Read a Stacked Example

Consider an area chart example with monthly support requests from email and chat. In January, email contributes 40 requests and chat contributes 20. In February, the counts are 50 and 30. Put email at the bottom and chat above it.

Email’s upper edge moves from 40 to 50 because its lower edge stays on the baseline. Chat’s upper edge moves from 60 to 80, but those are combined totals, not chat counts. To recover chat, subtract the email boundary beneath it: the vertical gap is 20 in January and 30 in February.

That subtraction separates workload from composition. The outside profile answers how much work arrived overall; the thickness of each band answers where it arrived. A title such as “Monthly Support Requests by Contact Channel” gives readers the measure before they begin tracing boundaries.

In a separate hypothetical, hold February’s chat count at 20 while email still rises to 50. Chat’s upper edge would rise anyway. The band climbs without growing.

Arrange the Source Data

Use one actionable layout rule for a direct spreadsheet chart: put ordered dates in the first column and one numeric series in each following column, beneath a single header row. Each row must refer to the same observation point across all series. Store dates as actual dates, not inconsistent text labels.

Other source arrangements may need reshaping before they fit that rule:

Source-table layouts for area chart time and series data

Source-table option	Example field arrangement	Best for	Pros	Cons
Wide: one column per series	Date | Product A | Product B; one row per date	Building an area chart directly in Excel or Google Sheets	Series names become legend labels; values share one date column	Adding a product requires a new column; duplicate dates need aggregation
Long: one row per date–series pair	Date | Product | Sales; two products produce two rows per date	Database exports and chart tools with series or color mappings	New products append as rows; easy filtering by product	For the ordinary Excel chart below, reshape into one row per date and one column per product; tools with field mappings can use the long layout directly
Transposed: dates across columns	Product | Jan 2026 | Feb 2026; one row per product	Small spreadsheet reports already organized by month	Product rows are easy to compare across a few periods	Select series in rows or transpose; each new period adds a column
Separate source tables: one per series	Table A: Date | Sales A; Table B: Date | Sales B	Combining measurements exported by different systems	Each source can retain its original update schedule	Join on dates before charting; matching row numbers can misalign observations

Suppose a missing chat export leaves February blank. Replace that blank with zero and the chart may show chat disappearing for the month, although nobody measured an absence of requests. A zero is an observation; a blank can be a failure to observe. Document how you treat missing observations and distinguish them from measured zeros.

Matching dates also means matching reporting windows. Weekly totals cannot stand beside monthly totals as though they describe equal periods. Align components before stacking, aggregate duplicate dates where needed, and use a horizontal scale that reflects elapsed time when intervals are unequal. Otherwise, a long reporting gap can look like an ordinary short interval.

Build the Chart in Excel

Excel can produce a plausible-looking chart of the wrong columns. The most disruptive version treats dates as another numeric series. Excel stores dates as serial numbers, so that accidental series can dominate the scale and squeeze the actual measurements into a thin strip. Formatting the strip will not repair the selection.

To build the support-request example in Excel, use the illustrative counts: January email 40 and chat 20; February email 50 and chat 30.

1. Arrange the monthly observations in Date, Email and Chat columns, then select the range, including its headers.
2. Choose Insert → Insert Line or Area Chart → Stacked Area, using the two-dimensional subtype.
3. Check that the horizontal axis shows the months and the legend lists Email and Chat. With email at the bottom, the total should reach 60 in January and 80 in February.

If the legend includes Date, open Chart Design → Select Data, remove Date from the series list, and assign the date cells as the horizontal-axis labels. If series names appear where dates should be, use Chart Design → Switch Row/Column when the table’s orientation is the problem; otherwise, correct the assigned ranges. These instructions apply to ordinary charts: PivotCharts use PivotTable fields instead.

Compare plotted observations with their source cells after changing the assignments, especially after adding rows or editing headers. Inspect blank-cell and hidden-data handling in the chart’s settings as well. Only then add the title and vertical-axis unit. Currency needs its currency name; counts need the thing being counted. A polished chart of the date column is still wrong.

Make the Chart Easy to Read

When a filled series rises on a vertical axis that begins above zero, the visible height can exaggerate the measured increase. The fill can turn a modest increase into a much stronger visual claim. Keep the baseline at zero when shaded magnitude carries the message; use another display if subtle movement needs a tighter scale.

With that distortion removed, make adjacent bands distinguishable at the final display size. Do not rely entirely on red versus green. Clear boundaries and direct labels help when colors become difficult to separate, especially in grayscale or a reduced-size chart. Three-dimensional effects work against this goal by obscuring boundaries and distorting apparent thickness.

Keep stacking order consistent through time and across related charts. Put the priority component at the bottom if it needs the most accurate reading. Combine tiny categories into “Other” only when doing so preserves the comparison readers came to make.

Thin boundaries and light gridlines can support that reading without competing with the fill. Avoid smoothing that invents unsupported curves. An annotation may identify a documented reporting-method change, but coincident timing alone does not establish a cause. Label the evidence, not your guess.

Know When to Use Another Chart

Use lines when readers need to compare individual trends that cross frequently. Small multiples offer another solution: separate panels with consistent scales let each series keep a stable baseline without covering its neighbors. Both choices sacrifice the solid overall profile to make individual paths easier to follow.

Negative values can make that sacrifice essential. Net cash flow, for example, can cross zero as receipts and payments change. A single filled series can show those crossings, but stacking mixed positive and negative components makes the total harder to interpret. Percentage stacking fails outright when its total is zero: there is no total by which to divide the components.

A diverging bar chart can separate gains from losses more clearly. For financial balances, also distinguish movement during a period from the amount remaining at its end; cash flow and cash balance answer different questions.

Even positive data need not become a filled chart. A continuous profile earns its space when it reveals sustained growth or a changing mix. If the task is to retrieve exact amounts for a handful of periods, kill the chart. Use a table.

Key Takeaways

• The filled region represents either an independent quantity or a contribution to a total.
• A stacked total is meaningful only when its components can usefully be added.
• Upper stacked components show their values through vertical thickness, not height above zero.
• Dates and missing observations affect the chart’s meaning.
• Fill is useful when it makes the intended comparison clearer.

Frequently Asked Questions

What is the difference between an area chart and a line chart?

An area chart shades the space beneath a boundary, while a line chart leaves that space unfilled. That extra color gives magnitude more visual weight, but it can also hide another series that a line would leave visible.

How do I create an area chart in Excel?

Select your dated series with their headers and insert the area subtype that matches the comparison. If the result looks wrong, fix the source assignments before formatting; a legend containing the date field is a useful warning that Excel has plotted the wrong quantity.

Why are charts with stacked fills harder to compare precisely?

Most stacked components have two moving edges, so reading their values requires judging the gap between them. To test your reading, trace both edges of one band across the same interval; following only the top edge can reverse your impression of its change.

Can negative values make filled comparisons misleading?

Yes, mixed positive and negative components can cancel, leaving a stacked total that conceals substantial activity. Equal receipts and payments, for example, produce no net change without implying that nothing happened.

How many series should I include in an area chart?

Include only as many series as remain individually identifiable at the intended display size; there is no universal limit. Judge the finished chart where readers will see it, because bands that look distinct on a large working screen can become unreadable in a small report panel.

What the Fill Reveals

An area chart gives magnitude a visible shape, but that shape means different things in different arrangements. A single series shows values above a baseline; a stack shows a total and its components; a percentage stack shows composition without total size. The support-request example illustrates the central distinction: an upper band’s boundary marks a cumulative total, while its thickness gives the component’s count. The chart succeeds when those visual differences make the intended comparison clear rather than merely making the display more colorful.