Creating a Pie Chart in Excel
Now, let’s see the steps involved to create a pie chart in Excel:
- Step 1: Open MS Excel in your system.
- Step 2: In the toolbar, go to the Insert option.
- Step 3: Then check the pie chart icon for different pie chart segments.
- Step 4: Choose the type of pie chart you need.
There are really amazing pie charts according to different needs and properties. Before checking them, let’s create data for the pie charts.
Data is information, which has to be displayed pictorially in the form of a pie chart.
Let’s take a small data table that is related to a student’s marks obtained (out of 100 marks) in six subjects. Data is as follows:
So, here we can see, there are two types of data present: Subject name and Marks obtained. Following that, the values are filled. To create the pie chart of this data, select the data from the table. (Click on the upper-leftmost cell & drag the cursor to the bottom-rightmost cell and leave).
How to Make a Pie Chart in Excel
A pie chart in Excel is a pictorial representation of data. It is generally used to show the composition of an individual item. Categorical data is best represented using a pie chart, as it makes each slice represent a different category. The main purpose of the pie chart is to show part-whole relationships.
Here, we discussed step-by-step how to create clear and impactful pie charts. We’ll walk you through Excel’s features, helping you design impressive pie charts that grab attention, learn how to handle data, tweak chart styles, and polish visuals for pro-level results.