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.
This is a standard excerpt for the charts.
Now, in this article , we will discuss about the TREEMAP CHARTS which are specifically designed to present the HIERARCHY of the processes or values.
The TREEMAP CHARTS represent the categories with the rectangle and subcategories with the smaller rectangles of the same color.
Not much of the information is given by the TREEMAP.
It just gives the hierarchy of the categories. Not much of the information can be extracted from the same.
Let us learn how to create a TREEMAP CHART in EXCEL.
The button for column chart is found under the INSERT TAB >CHARTS SECTION under the button INSERT HIERARCHY CHARTS >TREEMAP CHART. The location is shown in the picture below.
DETAILS OF SCHOOL STRENGTH | |||
SCHOOL | STANDARD | SECTION | NUMBER OF STUDENTS |
A | I | A | 12 |
B | 13 | ||
II | A | 13 | |
B | 14 | ||
B | V | A | 32 |
B | 34 | ||
VI | A | 23 | |
B | 32 |
The procedure to insert a treemap chart are as follows:
So , we have successfully created a treemap chart.
If we notice the chart, we can see that it took into consideration only the TOP CATEGORY and the last category with the values. It omitted the rest whereas in our SUNBURST CHART, it shows all the categories and the exact hierarchy.
THE HIERARCHY IS SET FROM TOP TO BOTTOM AND LEFT TO RIGHT.
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