PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
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.
The button for column chart is found under the INSERT TAB under the CHARTS SECTION.
WHEAT GROWTH (MILLION TON) | ||
2019 | 2020 | |
APRIL | 32 | 14 |
MAY | 21 | 11 |
JUNE | 6 | 5 |
JULY | 1 | 1 |
The procedure to insert a doughnut chart are as follows:
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.
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.
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) | ||
2019 | 2020 | |
APRIL | 32 | 14 |
MAY | 21 | 11 |
JUNE | 6 | 5 |
JULY | 1 | 1 |
The procedure to insert a 2D AREA CHART chart are as follows:
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.
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.
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) | ||
2019 | 2020 | |
APRIL | 32 | 14 |
MAY | 21 | 11 |
JUNE | 6 | 5 |
JULY | 1 | 1 |
The procedure to insert a 2D 100% AREA CHART chart are as follows:
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.
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
YOU MAY LIKE