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 SUNBURST CHARTS which are specifically designed to present the HIERARCHY of the processes or values.
The SUNBURST chart is a kind of layered doughnuts and represent the subcategories with a new layer outside of the inner layer. A sample SUNBURST CHART picture is given above for the reference.
Sunburst chart is a hierarchy showing chart which shows the processes and subprocesses connected to each other by presenting the pieces of the circle.
The button for column chart is found under the INSERT TAB >CHARTS SECTION under the button INSERT HIERARCHY CHARTS >SUNBURST. The location is shown in the picture below.
|DETAILS OF SCHOOL STRENGTH|
|SCHOOL||STANDARD||SECTION||NUMBER OF STUDENTS|
The procedure to insert a doughnut chart are as follows:
So , we have successfully created a sunburst chart.
The concept of SUNBURST CHART, DOUGHNUT CHART and a PIE CHART are almost same. All three have the same basic traits.
All three represent the data in a filled circle by representing the portions of the circles proportionate to the values. But even then there are differences in all three.
The PIE CHART represent a single series, whereas DOUGHNUT CHARTS can represent the multiseries and SUNBURST CHARTS can represent the multiple series including the sub series of the main series.
If we make the hole size of doughnut chart with a single series zero, it’ll be another pie chart only.
If we don’t have any sub series, the sunburst chart is simply a doughnut chart.
If we don’t want to compare, we can create the same chart in all the three chart types.
In the PIE CHART and DOUGHNUT CHART, the chart will be created by putting up all the sections on the same axis, but we won’t be able to make any type of comparison between the categories and it won’t be telling us about the hierarchy which will take away our main purpose.
The following picture shows the chart made by all three techniques.
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