One column per series: stack them to show how the total is built, or overlap them to compare. The chart downloads as SVG or PNG with no account and no watermark.
How to make an area chart
- Put the dates or steps in the first column, in order.
- Put each series in its own column, with its name in the header.
- Paste the cells in the Data panel.
- Choose stacked or overlapping in the Design panel, then download.
Stacked or overlapping
Stacked areas sit on top of each other. The top edge is the total and each band is one series’ contribution. Use it when the parts add up to something real: visits by channel, revenue by product, energy by source.
Overlapping areas all start at zero and are drawn translucent. Use it for two or three series you want to compare directly. With more, the overlaps turn muddy and a line graph is clearer.
Do not stack series that cannot be added, such as an average and a maximum, or prices of different things. The total would be a number that means nothing.
Reading a stacked area
Only the bottom band has a flat baseline. The others ride on the bands below, so a band that looks as if it is rising may only be pushed up. Read the thickness of a band, not the height of its top edge. Put the series you most want readers to follow at the bottom: it is the first value column in your table.
Gaps and zeros
In an overlapping area an empty cell breaks the shape, as in a line graph. In a stacked area an empty cell counts as zero, because a missing band would make every band above it fall. If a value is unknown, a stacked chart is not the right form for that period.
Related charts
For totals at a few separate moments instead of a continuous period, stacked bars show the same idea with exact, labelled segments. For shares of one total at one moment, see the pie chart maker.