PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
Contents
CREATE PIE 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.
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.
WHEN TO USE PIE CHARTS
BUTTON LOCATION FOR PIE CHARTS
The button for column chart is found under the INSERT TAB under the CHARTS SECTION.
STEPS TO INSERT A PIE CHART IN EXCEL
EXAMPLE DETAILS
| TOTAL STUDENTS | 100 |
| GRADES | STUDENTS |
| A | 10 |
| B | 40 |
| C | 30 |
| D | 20 |
The procedure to insert a pie chart are as follows:
STEPS TO INSERT A PIE 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 grades of 100 students.
- Select the complete table including the HEADER NAMES.
- Go to INSERT TAB> CHARTS> and click the PIE button under 2D PIE 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.
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.
TYPES OF PIE CHARTS IN EXCEL
- PIE – ALREADY DISCUSSED
- PIE OF PIE- A PIE CHART in which a portion is again segregated and shown as a pie chart. It is useful when we have few low percentages and many categories. We can understand this problem as , when many categories are there the sector angle becomes so small, that it won’t be visible.
- BAR OF PIE- A PIE CHART in which a portion is again shown as a stacked bar. It is useful to be used when we have small percentages for a few categories. If we show these in the same pie, the sector size will be too small to identify.
| 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.
PIE OF PIE CHART
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.
STEPS TO CREATE PIE OF PIE CHART IN EXCEL
The procedure to insert a PIE OF PIE chart are as follows:
STEPS TO INSERT A PIE OF PIE 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 grades of 100 students.
- Select the complete table including the HEADER NAMES.
- Go to INSERT TAB> CHARTS> and click the PIE OF PIE CHART button under 2D PIE 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.
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.
BAR OF PIE CHART
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.
STEPS TO CREATE BAR OF PIE CHART IN EXCEL
The procedure to insert a BAR OF PIE chart are as follows:
STEPS TO INSERT A BAR OF PIE 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 grades of 100 students.
- Select the complete table including the HEADER NAMES.
- Go to INSERT TAB> CHARTS> and click the BAROF PIE CHART button under 2D PIE 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.
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.
CREATE 3D PIE CHART IN EXCEL
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.
STEPS TO CREATE A 3D PIE CHART IN EXCEL
The procedure to insert a 3D PIE chart are as follows:
STEPS TO INSERT A 3D PIE 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 grades of 100 students.
- Select the complete table including the HEADER NAMES.
- Go to INSERT TAB> CHARTS> and click the 3D PIE CHART button under 3-D PIE 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 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.
FQA ABOUT PIE CHARTS
QUESTION 1: HOW TO ROTATE A PIE CHART?
Rotating a pie chart is a common problem. Rotating a pie chart means to set the initial angle of the pie chart.
- Right Click the chart and choose FORMAT DATA SERIES
- It’ll open the dialog box in the right side of the window.
- Choose SERIES OPTIONS from the drop down if not selected.[Shown in the picture below]
- Go to ANGLE OF FIRST SLICE and change the angle by moving the slider as per requirement.
- The PIE CHART will rotate as per the requirement.
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
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.