Area charts

Much like a line chart, an area chart tracks one or more data series graphically, and is particularly useful when expressing changes in value between categories of data.

Data Format

In the first column, enter a label to describe the data you’re displaying in the area chart. For example, you could enter dates or times. The remaining columns will each represent an area on the chart and must contain numeric data. You can have one or more of these columns to display on the area chart. All data values must be positive in an area chart. The data format for a area chart is the same as the data format for bar, line, and column charts.

You may also want to name each of the columns containing your data. If you do so, we’ll automatically detect these names and use them as labels for your data on the chart. You can also set or change this setting by selecting the checkbox that reads ‘Use Row A as headers.’

Last, you can chart uncertainty about your data using boolean values.

area chart

Stacked area chart

A stacked area chart is used in similar instances as an area chart or a line chart, but shows the relationship of the part to the whole. The data format for a stacked area chart is the same as an area chart, although you’ll need two or more columns containing numeric data. The following example shows Gold, Silver and Bronze Olympic medals as a portion of the total medals earned by each country.

area chart

stacked area chart