How to Create an Area Chart in Google Sheets

There are many different kinds of area charts. Learn how to navigate the creation of these charts in Google Sheets to better model your data and statistics.

Table of Contents
  1. How to create an area chart
  2. How to create a stacked area chart
  3. How to create a 100% stacked area chart
  4. How to create stepped area charts
  5. A sample sheet to check
Table of contents
Chapter 1
Chapter 2
Chapter 3
  1. How to create an area chart
  2. How to create a stacked area chart
  3. How to create a 100% stacked area chart
  4. How to create stepped area charts
  5. A sample sheet to check

Unsure which chart type to use? Click here to find the right chart for your data and the ideas that you want to convey.

Google Sheets offers three types of area charts: the simple area chart, the stacked area chart, and the 100% stacked area chart. These types of area charts come either simple or stepped.

Simple area chart
Simple area chart


Stepped area chart
Stepped area chart


This tutorial is a straightforward guide to inserting an area chart in Google Sheets with some notes on the type of data that it requires you to have. 

How to create an area chart

Here are the steps in creating an area chart from an existing dataset in Google Sheets:

Step 1: Select the range of data that you want to visualize.

The dataset to be visualized, selected
The dataset to be visualized, selected


Step 2: Click Insert, then click Chart.

Insert option selected on the main menu, drop down box, Chart highlighted
Insert option selected on the main menu, drop down box, Chart highlighted

Step 3: The selected chart type is not an area chart by default. On the right side, the Chart editor sidebar is loaded. Click the Setup tab if it is not already selected, then click the drop-down box below Chart type. A list of possible chart types will be loaded. Look for the Area chart, and click it. 

Chart editor, Setup tab, Chart type, Area chart selected
Chart editor, Setup tab, Chart type, Area chart selected


Step 4: We now have an area chart. To add a title to the chart, go to the Customize tab in the Chart editor, then click Chart axis & titles

Chart editor, Customize tab. Chart & axis titles option highlighted.
Chart editor, Customize tab. Chart & axis titles option highlighted.


Step 5: If you want to add a chart title, make sure that the drop-down box displays the option Chart title. On the text box below the drop-down box, type the title of the chart.

Chart & axis titles option. Chart title selected. Title text: Annual Sales 2020.
Chart & axis titles option. Chart title selected. Title text: Annual Sales 2020.


Step 6: Here are some options for modifying the title of the chart:

  • To change the font of the title, click the drop-down box below the label Title font. There are 12 fonts to choose from, such as Arial, Georgia, and Verdana. 
  • To change the size of the title, click the drop-down box below the label Title font size. You can select from size 10 to 36. You can also specify a value beyond the given options. Lastly, you can choose Auto to let Google Sheets adjust the font size fit for the given chart.
  • To center align the title, go to Title format and click the Alignment option. Click the Center option. 

We now have the following chart!

Area chart with title and axis labels
Area chart with title and axis labels


Click here to learn how to add the title or axis labels, as well as how to change the colors.

How to create a stacked area chart

Unlike a typical area chart which we had in the previous section, a stacked area chart visualizes the components of a certain quantity, thus adding another dimension to your area chart. This means that the dataset should have multiple columns.

Before you follow the steps, make sure that your data also contains the breakdown of the values of the components.

Step 1: Select the range of data that you want to visualize.

The dataset to be visualized, selected
The dataset to be visualized, selected


Step 2: Click Insert, then click Chart.

Insert option selected on the main menu, drop down box, Chart highlighted
Insert option selected on the main menu, drop down box, Chart highlighted


Step 3: The selected chart type is not a stacked area chart by default. On the right side, the Chart editor sidebar is loaded.  Click the Setup tab if it is not yet selected, then click the drop-down box below Chart type. A list of possible chart types will be loaded. Look for Stacked area chart and click it.

Chart editor, Setup tab, Chart type, Stacked area chart selected
Chart editor, Setup tab, Chart type, Stacked area chart selected


Step 4: We now have a stacked area chart. To add a title to the chart, go to the Customize tab in the Chart editor and click Chart axis & titles.

Chart editor, Customize tab. Chart & axis titles option highlighted.
Chart editor, Customize tab. Chart & axis titles option highlighted.


Step 5. If you want to add a chart title, make sure that the drop-down box displays the option Chart title. On the text box below the drop-down box, type the title of the chart.

Chart & axis titles option. Chart title selected. Title text: Annual Sales 2016-2020.
Chart & axis titles option. Chart title selected. Title text: Annual Sales 2016-2020.


Step 6. Here are some options for modifying the title of the chart:

  • To change the font of the title, click the drop-down box below the label Title font. There are 12 fonts to choose from such as Arial, Georgia, and Verdana. 
  • To change the size of the title, click the drop-down box below the label Title font size. You can select from a range of 10 to 36. You can also specify a value beyond the given options. Lastly, you can choose Auto to let Google Sheets adjust the font size fit for the given chart.
  • To center align the title, go to Title format and click the Alignment option. Then click the Center option.

We now have the following chart!

Stacked area chart with title and axis labels
Stacked area chart with title and axis labels


Click here to learn how to add the title, axis labels, or change the colors.

How to create a 100% stacked area chart

Sometimes you’re not interested in the total quantity but instead with the differences in the composition of certain quantities over time. For this, a 100% stacked area chart is sufficient. A 100% stacked area chart only differs from a stacked area chart visually: the stacked areas are of the same length. This highlights the differences in the composition of each stacked area.

Step 1: Select the range of data that you want to visualize.

The dataset to be visualized, selected
The dataset to be visualized, selected


Step 2: Click Insert, then click Chart.

Insert option selected on the main menu, drop down box, Chart highlighted
Insert option selected on the main menu, drop down box, Chart highlighted


Step 3: The selected chart type is not a column chart by default. On the right side, the Chart editor sidebar is loaded.  Click the Setup tab if it is not yet selected, then click the drop-down box below Chart type. A list of possible chart types will be loaded. Look for the 100% stacked area chart, and click it.

Chart editor, Setup tab, Chart type, 100% stacked area chart selected
Chart editor, Setup tab, Chart type, 100% stacked area chart selected


Step 4: We now have a 100% stacked area chart. To add a title to the chart, go to the Customize tab in the Chart editor, then click Chart axis & titles.

Chart editor, Customize tab. Chart & axis titles option highlighted.
Chart editor, Customize tab. Chart & axis titles option highlighted.


Step 5. If you want to add a chart title, make sure that the drop-down box displays the option Chart title. On the text box below the drop-down box, type the title of the chart.

Chart & axis titles option. Chart title selected. Title text: Annual Sales 2020.
Chart & axis titles option. Chart title selected. Title text: Annual Sales 2020.


Step 6. Here are some options in modifying the title of the chart:

  • To change the font of the title, click the drop-down box below the label Title font. There are 12 fonts to choose from such as Arial, Georgia, and Verdana. 
  • To change the size of the title, click the drop-down box below the label Title font size. You can select from a range of 10 to 36. You can also specify a value beyond the given options. Lastly, you can choose Auto to let Google Sheets adjust the font size fit for the given chart.
  • To center align the title go to Title format, then click the Alignment option. Click the Center option.

We now have the following chart!

100% stacked area chart with title and axis labels
100% stacked area chart with title and axis labels


Click here to learn how to add the title, axis labels, or change the colors.

How to create stepped area charts

Stepped area charts combine features of column and area charts, and can be used to show the progression of values over time. Once you have inserted a chart, go to the Chart editor sidebar on the right side of Google Sheets. Click Setup tab, then click the drop-down box below Chart type. A list of possible chart types will be loaded. Take note of the following icons to select a type of stepped area chart:

Stepped area chart

Chart editor, Setup tab, Chart type, stepped  area chart selected
Chart editor, Setup tab, Chart type, stepped  area chart selected


Stacked stepped area chart

Chart editor, Setup tab, Chart type, stacked stepped area chart selected
Chart editor, Setup tab, Chart type, stacked stepped area chart selected


100% stacked stepped area chart

Chart editor, Setup tab, Chart type, 100% stacked stepped  area chart selected
Chart editor, Setup tab, Chart type, 100% stacked stepped  area chart selected


The resulting charts are as follows:

Stepped area chart

Stepped area chart
Stepped area chart

Stacked stepped area chart

Stacked stepped area chart
Stacked stepped area chart


100% stacked stepped area chart

100% stacked stepped area chart
100% stacked stepped area chart


A sample sheet to check

If you got a bit lost, or just want to check if you are doing it right, here is a sample sheet that you can open to see how they work:

Area Chart Sample Sheet

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

May 10, 2021

How to Create an Area Chart in Google Sheets

Google Sheet spreadsheet

Unsure which chart type to use? Click here to find the right chart for your data and the ideas that you want to convey.

Google Sheets offers three types of area charts: the simple area chart, the stacked area chart, and the 100% stacked area chart. These types of area charts come either simple or stepped.

Simple area chart
Simple area chart


Stepped area chart
Stepped area chart


This tutorial is a straightforward guide to inserting an area chart in Google Sheets with some notes on the type of data that it requires you to have. 

How to create an area chart

Here are the steps in creating an area chart from an existing dataset in Google Sheets:

Step 1: Select the range of data that you want to visualize.

The dataset to be visualized, selected
The dataset to be visualized, selected


Step 2: Click Insert, then click Chart.

Insert option selected on the main menu, drop down box, Chart highlighted
Insert option selected on the main menu, drop down box, Chart highlighted

Step 3: The selected chart type is not an area chart by default. On the right side, the Chart editor sidebar is loaded. Click the Setup tab if it is not already selected, then click the drop-down box below Chart type. A list of possible chart types will be loaded. Look for the Area chart, and click it. 

Chart editor, Setup tab, Chart type, Area chart selected
Chart editor, Setup tab, Chart type, Area chart selected


Step 4: We now have an area chart. To add a title to the chart, go to the Customize tab in the Chart editor, then click Chart axis & titles

Chart editor, Customize tab. Chart & axis titles option highlighted.
Chart editor, Customize tab. Chart & axis titles option highlighted.


Step 5: If you want to add a chart title, make sure that the drop-down box displays the option Chart title. On the text box below the drop-down box, type the title of the chart.

Chart & axis titles option. Chart title selected. Title text: Annual Sales 2020.
Chart & axis titles option. Chart title selected. Title text: Annual Sales 2020.


Step 6: Here are some options for modifying the title of the chart:

  • To change the font of the title, click the drop-down box below the label Title font. There are 12 fonts to choose from, such as Arial, Georgia, and Verdana. 
  • To change the size of the title, click the drop-down box below the label Title font size. You can select from size 10 to 36. You can also specify a value beyond the given options. Lastly, you can choose Auto to let Google Sheets adjust the font size fit for the given chart.
  • To center align the title, go to Title format and click the Alignment option. Click the Center option. 

We now have the following chart!

Area chart with title and axis labels
Area chart with title and axis labels


Click here to learn how to add the title or axis labels, as well as how to change the colors.

How to create a stacked area chart

Unlike a typical area chart which we had in the previous section, a stacked area chart visualizes the components of a certain quantity, thus adding another dimension to your area chart. This means that the dataset should have multiple columns.

Before you follow the steps, make sure that your data also contains the breakdown of the values of the components.

Step 1: Select the range of data that you want to visualize.

The dataset to be visualized, selected
The dataset to be visualized, selected


Step 2: Click Insert, then click Chart.

Insert option selected on the main menu, drop down box, Chart highlighted
Insert option selected on the main menu, drop down box, Chart highlighted


Step 3: The selected chart type is not a stacked area chart by default. On the right side, the Chart editor sidebar is loaded.  Click the Setup tab if it is not yet selected, then click the drop-down box below Chart type. A list of possible chart types will be loaded. Look for Stacked area chart and click it.

Chart editor, Setup tab, Chart type, Stacked area chart selected
Chart editor, Setup tab, Chart type, Stacked area chart selected


Step 4: We now have a stacked area chart. To add a title to the chart, go to the Customize tab in the Chart editor and click Chart axis & titles.

Chart editor, Customize tab. Chart & axis titles option highlighted.
Chart editor, Customize tab. Chart & axis titles option highlighted.


Step 5. If you want to add a chart title, make sure that the drop-down box displays the option Chart title. On the text box below the drop-down box, type the title of the chart.

Chart & axis titles option. Chart title selected. Title text: Annual Sales 2016-2020.
Chart & axis titles option. Chart title selected. Title text: Annual Sales 2016-2020.


Step 6. Here are some options for modifying the title of the chart:

  • To change the font of the title, click the drop-down box below the label Title font. There are 12 fonts to choose from such as Arial, Georgia, and Verdana. 
  • To change the size of the title, click the drop-down box below the label Title font size. You can select from a range of 10 to 36. You can also specify a value beyond the given options. Lastly, you can choose Auto to let Google Sheets adjust the font size fit for the given chart.
  • To center align the title, go to Title format and click the Alignment option. Then click the Center option.

We now have the following chart!

Stacked area chart with title and axis labels
Stacked area chart with title and axis labels


Click here to learn how to add the title, axis labels, or change the colors.

How to create a 100% stacked area chart

Sometimes you’re not interested in the total quantity but instead with the differences in the composition of certain quantities over time. For this, a 100% stacked area chart is sufficient. A 100% stacked area chart only differs from a stacked area chart visually: the stacked areas are of the same length. This highlights the differences in the composition of each stacked area.

Step 1: Select the range of data that you want to visualize.

The dataset to be visualized, selected
The dataset to be visualized, selected


Step 2: Click Insert, then click Chart.

Insert option selected on the main menu, drop down box, Chart highlighted
Insert option selected on the main menu, drop down box, Chart highlighted


Step 3: The selected chart type is not a column chart by default. On the right side, the Chart editor sidebar is loaded.  Click the Setup tab if it is not yet selected, then click the drop-down box below Chart type. A list of possible chart types will be loaded. Look for the 100% stacked area chart, and click it.

Chart editor, Setup tab, Chart type, 100% stacked area chart selected
Chart editor, Setup tab, Chart type, 100% stacked area chart selected


Step 4: We now have a 100% stacked area chart. To add a title to the chart, go to the Customize tab in the Chart editor, then click Chart axis & titles.

Chart editor, Customize tab. Chart & axis titles option highlighted.
Chart editor, Customize tab. Chart & axis titles option highlighted.


Step 5. If you want to add a chart title, make sure that the drop-down box displays the option Chart title. On the text box below the drop-down box, type the title of the chart.

Chart & axis titles option. Chart title selected. Title text: Annual Sales 2020.
Chart & axis titles option. Chart title selected. Title text: Annual Sales 2020.


Step 6. Here are some options in modifying the title of the chart:

  • To change the font of the title, click the drop-down box below the label Title font. There are 12 fonts to choose from such as Arial, Georgia, and Verdana. 
  • To change the size of the title, click the drop-down box below the label Title font size. You can select from a range of 10 to 36. You can also specify a value beyond the given options. Lastly, you can choose Auto to let Google Sheets adjust the font size fit for the given chart.
  • To center align the title go to Title format, then click the Alignment option. Click the Center option.

We now have the following chart!

100% stacked area chart with title and axis labels
100% stacked area chart with title and axis labels


Click here to learn how to add the title, axis labels, or change the colors.

How to create stepped area charts

Stepped area charts combine features of column and area charts, and can be used to show the progression of values over time. Once you have inserted a chart, go to the Chart editor sidebar on the right side of Google Sheets. Click Setup tab, then click the drop-down box below Chart type. A list of possible chart types will be loaded. Take note of the following icons to select a type of stepped area chart:

Stepped area chart

Chart editor, Setup tab, Chart type, stepped  area chart selected
Chart editor, Setup tab, Chart type, stepped  area chart selected


Stacked stepped area chart

Chart editor, Setup tab, Chart type, stacked stepped area chart selected
Chart editor, Setup tab, Chart type, stacked stepped area chart selected


100% stacked stepped area chart

Chart editor, Setup tab, Chart type, 100% stacked stepped  area chart selected
Chart editor, Setup tab, Chart type, 100% stacked stepped  area chart selected


The resulting charts are as follows:

Stepped area chart

Stepped area chart
Stepped area chart

Stacked stepped area chart

Stacked stepped area chart
Stacked stepped area chart


100% stacked stepped area chart

100% stacked stepped area chart
100% stacked stepped area chart


A sample sheet to check

If you got a bit lost, or just want to check if you are doing it right, here is a sample sheet that you can open to see how they work:

Area Chart Sample Sheet

Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.