Learn How to Create Area Charts in Google Sheets

0
138

Google Sheets offers endless possibilities in data visualisation. There are different types of charts in Google Spreadsheets. Google Sheets can intelligently identify which type of chart is suitable for you from your data and can make suggestion. This time let us learn how to create area charts in Google Sheets. Learn almost all different types of area charts in the possible simplest way.

If you think that you are new to area charts and don’t know anything about creating different Area Charts, You are in the right spot. Here I’ll explain you, what is an area chart and how to create different area charts in Google Sheets.

Area Charts are almost similar to Line Charts. Then where the difference lies? In Area Charts the the area below the line is filled in with a certain shade of colour. First of all you should understand what’s a line graph. This will make things easy for you in your endeavour to learn different Area Charts in Google Sheets.

all types of area charts in google sheets

So let us first try to understand Line Chart. A Line chart as well as an Area Chart can be used for comparison purposes just like column or bar charts. Unlike bar chart or column chart, an Area Chart is used to show graphical display of information that changes continuously over a short or long period of time. So in this type of charts, the X-axis data is normally time, date or year.

Steps to Create Area Charts in Google Sheets

There are six different types of area charts in Google Sheets. They are;

  1. Area Chart
  2. Stacked Area Chart
  3. 100% Stacked Area Chart
  4. Stepped Area Chart
  5. Stacked Stepped Area Chart
  6. 100% Stacked Stepped Area Chart.

We will use the below sales report over a period of 10 years to plot all the above different area charts in Google Spreadsheets.

sample data to create Area Charts in Google Sheets

How to Insert an Area Chart in Google Sheets?

From Google Sheets’ Insert Menu you can insert a Chart. Once inserted your desired chart, just double click the chart to format it, if necessary.

Now to let us learn to create different types of Area charts and where to use it. It’s quite easy to create Area Charts in Google Sheets if you arrange your data in proper way. Just select your data and insert the desired area chart from the insert menu Chart.

Area Chart in Google Sheets

The below area chart shows the trend of the sales of two products, Product A and Product B, over a period of 10 years. We used the data above for all the below charts.

Area Chart Graph - Info Inspired

Stacked Area Chart in Google Sheets

There is a slight difference between area chart and stacked area chart. Before you create stacked area charts in Google Sheets you should understand this difference first.

When multiple data series are there in your data, you can consider stacked area chart. In this type of charts, each data series start from the point where the the previous data series left by. I will make it clear below.

Check our above data to see the total sales of Product A and Product B in 2010. It’s 500+455=955. So the second data series will start from this point value of 955. The advantage is you can see the cumulative sales along with the data trend from the stacked area chart.

Stacked Area Chart - Info Inspired

100% Stacked Area Chart in Google Sheets

This is percentage contribution of each data series over a time period in stacked form.

Again see our above sample data and check the Product A and Product B contribution in 2010.

Total Product A and Product B sales in 2010 = 955

Product A percentage = 500/955×100% = 0.52%

Product B percentage = 455/955×100% = 0.48%

Now look at the chart below to see the effect.

Create percentage Stacked Area Chart in Google Sheets

Stepped Area Chart in Google Sheets

Stepped Area Chart is similar to normal Area Chart. Only the visual appearance is different. It’s in the stepped form as you can see in the below stepped area chart. Therefore I think no explanation is required to make you understand it.

Create Stepped Area Charts in Google Sheets

Stacked Stepped Area Chart in Google Sheets

Stepped Stacked Area Chart is similar to Stacked Area Chart but in stepped form.

Create Stacked Stepped Area Charts in Google Sheets

100% Stacked Stepped Area Chart in Google Sheets

This is similar to 100% Stacked Area Chart. Since I’m not explaining it in detail.

Create 100% Stepped Stacked Area Charts in Google Sheets

The above are the 6 different types of area charts in Google Sheets. From this tutorial I hope you got answers to your following chart related queries.

  • How to Create Area Charts in Google Sheets?
  • What is Area Charts in Google Sheets?
  • How to create stacked area charts?
  • How to create stepped area charts?
  • Difference between Area Chart and Line Charts?

I hope you enjoyed this tutorial where I tried to touch especially relevant things in Area Chart creation. See you again with another topic. Also there are more spreadsheet tutorials in the pipeline.

LEAVE A REPLY

Please enter your comment!
Please enter your name here