How to Create an Area Chart in Google Sheets

In this tutorial, you will learn how to create an area chart in Google Sheets.

How to Create an Area Chart in Google Sheets

An area chart combines the line and bar charts to demonstrate how the numeric values of one or more groups vary as a second variable, usually, time, progresses.

The inclusion of shade between lines and a baseline, similar to a bar chart, distinguishes an area chart from a line chart.

To have a better understanding, we can get started by using real-life scenarios to help you understand how to create area charts in Google Sheets.

Creating an Area Chart

Before we begin we will need a group of data to be used to create the area chart.

Step 1 – Group your data

Make sure your group of data is displayed in a clean and tidy manner. This will help us to create the area chart easily.

Untitled

Step 2 – Select data & insert chart

Select the entire data cell, choose Insert, and select Chart.

Untitled

Step 3 – Setup chart type

By default, Google Sheet will use the selected group of data to generate a line chart.

We can simply change it to an area chart by selecting it in the Chart Type.

Untitled

Step 4 – Change to an Area chart

Now, you can customize the area chart to your preference.

We will change the chart title to ‘Business Revenue 2021’ for a better representation of the area chart.

Also, to emphasize the chart title, we will change the text color to black, bold it, and also align it to the center.

Untitled

Step 5 – Gaze (lovingly) upon your chart

As you can see, compared to a line chart, an area chart is basically the same but with the area shaded.

We have shown below the difference between an area chart and a line chart for your reference.

Untitled

Untitled

While the image above simply shows a single line with a shaded area, an area chart is generally used with numerous lines to show how a whole is broken into component pieces or to compare groupings (called series).

As a result, there is another type of area chart called a stacked area chart.

Creating a Stacked Area Chart

In most cases, when the term “area chart” is used, it refers to a stacked area chart.

Lines are plotted one at a time in a stacked area chart, with the height of the most recently drawn group serving as a sliding baseline.

As a result, when summing over all groups, the fully-stacked height of the topmost line will correspond to the total.

Let’s go through an example to fully understand when to use a stacked area chart in Google Sheets.

Step 1 – Group your data

Similar to the previous example, make sure to organize your data group properly and select the entire group of data to create the stacked area chart.

Untitled

Step 2 – Select data & insert chart

Select the entire data cell, choose Insert, and select Chart. By default, Google Sheet will use the selected group of data to generate a line chart.

We can simply change it to the stacked area chart by selecting it in the Chart Type.

Once you are done with the chart customization, your chart will look something like this:

Untitled

Summary

That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to make categories in google sheets. Want more? Check out all the Google Sheets Tutorials.