PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

CREATE AREA CHART IN EXCEL

INTRODUCTION

CHARTS are the graphic representation of any data . As we know that EXCEL is a super analytical tool.

Analysis of data is the process of deriving the inferences by finding out the trends, averages etc. about different parameters.

Excel provides us with a variety of charts and graphs to make our life easier. Although any chart can be used for any type of data, even then there are certain types which are apt for a particular type of data.

For example, if we want to compare, column charts are best, if we want to know the transition in any parameter, line charts are best. Similarly if we want to know the percentage contribution of a particular contributing factor among all.

In this article we are going to learn AREA CHARTS and its details.

WHEN TO USE AREA CHARTS

AREA CHARTS CAN BE USED PREFERABLY WHEN
  • We want to see the trend of any parameter with respect to time.
  • We can also use this chart to see the incremental change over time.

BUTTON LOCATION FOR AREA CHARTS

The button for column chart is found under the INSERT TAB under the CHARTS SECTION.

AREA MAP BUTTON LOCATION
EXCEL:BUTTON LOCATION FOR 2D AREA MAPS

STEPS TO INSERT AN AREA CHART IN EXCEL

EXAMPLE DETAILS

We can demonstrate the chart using an example.
We are taking the example of a class.
We will create an AREA CHART for the wheat growth of the two years for an area. The details are as given.
WHEAT GROWTH (MILLION TON)
 20192020
APRIL3214
MAY2111
JUNE65
JULY11

The procedure to insert a doughnut chart are as follows:

STEPS TO INSERT AN AREA CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.[We have already created in the form of table above]
  • Refer to our data above, we have  the wheat growth for four months in the two consecutive years.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click the 2D AREA CHART under  LINE OR AREA CHART SECTION as shown in the BUTTON LOCATION above and in the following picture for reference.
  • The chart will be created and shown to you as the following figure.
 
 The complete process of creating an AREA CHART is shown in the animated picture below.

 

How to create an AREA CHART in Excel
EXCEL:STEPS TO CREATE AREA CHART

So , we have successfully created an AREA CHART.

The first series is shown by the blue color and represents the values as shown in the data. The area under the value is filled to create the area for that particular value.

The next series is created above the area of the first series.

It means , if we had taken the 2020 column first, the entire 2019 column would have been obscured by the 2020 column and we couldn’t see anything. So simple AREA CHART is not a great choice unless it is needed anywhere and specially for multi-series data.

For a single series, it is great.

2D AREA CHART IS GREAT FOR

A single series data where we just want to check the increase or decrease in the values.

Multiseries where we just want to check the comparison , but the order is very important.

AREA OF THE LAST SERIES WOULD COVER THE TOP OF THE CHART IN THE Z AXIS.

 

STEPS TO INSERT A STACKED AREA CHART IN EXCEL

We have already learnt how to make a simple 2 D Area Chart.

Now let us take up one variation of the AREA CHART which we call as 2D STACKED AREA CHART.

The STACKED CHARTS as the word itself suggests, Stacks the values one over the other.

THE STATCKED AREA CHART IS USED WHEN WE NEED TO KNOW THE TOTAL VALUE AT EACH POINT, THE CONTRIBUTION OF THE EVERY INDIVIDUAL VALUE TO THE TOTAL AND THE CHANGE IN THE VALUE OVER TIME.

Let us take the example to understand how to create stacked area chart.

EXAMPLE DETAILS

We will create a 2D STACKED AREA CHART for the harvest of the two years for a city. The details are as given.

WHEAT GROWTH (MILLION TON)
 20192020
APRIL3214
MAY2111
JUNE65
JULY11

The procedure to insert a 2D AREA CHART chart are as follows:

STEPS TO INSERT A 2D STACKED AREA CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.[We have already created in the form of table above]
  • Refer to our data above, we have  the wheat growth for four months in the two consecutive years.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click the 2D STACKED AREA CHART under  LINE OR AREA CHART SECTION as shown in the BUTTON LOCATION SECTION above and in the following picture for reference.
  • The chart will be created and shown to you as the following figure.
 
 The complete process of creating an AREA CHART is shown in the animated picture below.

 

HOW TO CREATE STACKED AREA MAP
EXCEL:STEPS TO CREATE 2D STACKED AREA CHART

So , we have successfully created a 2D STACKED AREA CHART.

The first series is shown by the blue color and represents the values as shown in the data. The area under the value is filled to create the area for that particular value.

The next series is stacked over the area of the first series.

THE FIRST SERIES IS AT THE BOTTOM AND SECOND IS STACKED OVER THE FIRST ONE AND SO ON.

 

2D STACKED AREA CHART IS GREAT FOR:

To keep a check on the total values at every point.

Comparison between the values of different series at any point.

STEPS TO INSERT A 100% STACKED AREA CHART IN EXCEL

We have already learnt how to make a simple 2 D 100 % Area Chart and Stacked Area Chart.

Now let us take up one more variation of the AREA CHART which we call as 2D 100 % STACKED AREA CHART.

The 100 % STACKED CHARTS as the word itself suggests, Stacks the values one over the other.

THE 100 % STACKED AREA CHART IS USED WHEN WE NEED TO KNOW THE PERCENTAGE CONTRIBUTION OF THE INDIVIDUAL COMPONENTS, COMPARATIVE CONTRIBUTION OF THE INDIVIDUAL COMPONENTS OR THE PERCENTAGE CHANGE IN THE VALUE OF ANY COMPONENT.

Let us take the example to understand how to create 100% acked area chart.

EXAMPLE DETAILS

We will create a 2D 100 % STACKED AREA CHART for the wheat growth of the two years for a city. The details are as given.

WHEAT GROWTH (MILLION TON)
 20192020
APRIL3214
MAY2111
JUNE65
JULY11

The procedure to insert a 2D 100% AREA CHART chart are as follows:

STEPS TO INSERT A 2D 100% STACKED AREA CHART IN EXCEL:

  • The first requirement of any chart is data. So create a table containing the data.[We have already created in the form of table above]
  • Refer to our data above, we have  the wheat growth for four months in the two consecutive years.
  • Select the complete table including the HEADER NAMES.
  • Go to INSERT TAB> CHARTS> and click the 2D  100% STACKED AREA CHART under  LINE OR AREA CHART SECTION as shown in the BUTTON LOCATION SECTION above and in the following picture for reference.
  •  
  • The chart will be created and shown to you as the following figure.
 
 The complete process of creating a 2D 100% AREA CHART is shown in the animated picture below.

 

HOW TO CREATE 2D 100% STACKED AREA CHART
EXCEL:STEPS TO CREATE 2D 100% STACKED AREA CHART

So , we have successfully created a 2D 100% STACKED AREA CHART.

The first series is shown by the blue color and represents the values as shown in the data.

THE VALUES ARE SHOWN AS THE RELATIVE PERCENTAGES OF THE TOTAL.

The next series is stacked over the area of the first series.

THE FIRST SERIES IS AT THE BOTTOM AND SECOND IS STACKED OVER THE FIRST ONE AND SO ON.

2D 100% STACKED AREA CHART IS GREAT FOR:

To keep a check on the total values at every point.

Comparison between the values of different series at any point.

NOTE:

FOR ALL OTHER TASKS LIKE CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC. VISIT HERE [HOW TO CREATE A CHART IN EXCEL].

 

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]