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.
Data is everywhere. There is no work, where we don’t deal with the data. Sales data in business, employee data, patient data in hospitals, students data in school etc. Maximum data is presented in the tables but we all know that visual representation is easier to interpret. That is the reason that as the Excel developed, so the charts options in Excel.
Excel gives us a variety of charts which are beautiful, colorful, more customizable and more powerful.
In this article we are going to discuss one particular type of the charts which are known as PIE CHART.
In PIE CHARTS, the area shown by a portion shows the percentage or value of particular category.
We’ll discuss in detail, the different processes to create PIE CHARTS.
The button for column chart is found under the INSERT TAB under the CHARTS SECTION.
TOTAL STUDENTS | 100 |
GRADES | STUDENTS |
A | 10 |
B | 40 |
C | 30 |
D | 20 |
The procedure to insert a pie chart are as follows:
So , we have successfully inserted a pie chart. We have inserted a 2D pie chart this time.
The chart shows four sectors in a circle each representing the portion of the class getting the respective grades.
Now we can infer from the above problem , how difficult it would be find out the percentages of the students getting a particular grade manually in a table and how easy it becomes when we use a pie chart.
Now, let us check a few more variants of the pie chart available with us.
TOTAL STUDENTS | 100 |
GRADES | STUDENTS |
A | 10 |
B | 40 |
C | 30 |
D | 20 |
We’ll check how to create and use these charts for the above table.
A pie chart is simply the visual arrangement of different categories on a circle.
A PIE OF PIE Chart is a type of PIE CHART where a portion of the PIE CHART is created in another smaller PIE CHART. Something like this.
The procedure to insert a PIE OF PIE chart are as follows:
In the above chart we can see that category C and D are shown in another pie chart.
We use PIE OF PIE CHART where we have many categories and a single pie chart becomes too messy to show the details. Another smaller pie chart helps to handle few of the categories and make our task easier.
A pie chart is simply the visual arrangement of different categories on a circle.
A BAR OF PIE Chart is a type of PIE CHART where a portion of the PIE CHART is created in another smaller BAR CHART. Something like this.
The procedure to insert a BAR OF PIE chart are as follows:
In the above chart we can see that category C and D are shown in another BAR chart.
We use BAR OF PIE CHART in the cases where we have too many categories to be accommodated in a single pie chart. Few of the categories are shifted to the BAR CHART to make the data visible.
This is another choice of the charts which is a 3D PIE CHART.
This is simply like a PIE CHART . The difference is in the looks only.
The procedure to insert a 3D PIE chart are as follows:
The chart is in the 3d look. It is exactly same as the simple PIE CHART but in 3d look. We can use this in place of normal PIE CHARTS for the representation of data where we have to show the participation of sub categories in their respective performance in the form of a complete circle.
Rotating a pie chart is a common problem. Rotating a pie chart means to set the initial angle of the pie chart.
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