Often you may want to create a pie chart in Excel by using a count of values in a particular column.
For example, suppose you have the following dataset that contains information about various basketball players:
Suppose you would like to create a pie chart that shows the count of occurrences for each team name.
The following step-by-step example shows how to do so.
Step 1: Enter the Data
First, we’ll enter the following dataset into Excel:
Step 2: Create a List of Unique Values
Next, we’ll use the following formula to create a list of unique team names:
=UNIQUE(A2:A12)
We’ll type this formula into cell D2:
The formula creates a list of unique team names from column A.
Step 3: Count the Occurrences of Each Value
Next, we’ll type the following formula into cell E2 to calculate the occurrence of each unique team name:
=COUNTIF($A$2:$A$12, D2)
We’ll then drag this formula down to each remaining cell in column E:
Step 4: Create the Pie Chart
Lastly, we can highlight the range D2:E5 and then click the Insert tab along the top ribbon, then click the Pie icon within the Charts group:
The following pie chart will automatically be created:
The pie chart shows the count of each unique team name in the dataset.
Feel free to customize the pie chart by adding a title and adding data labels:
The numbers within each pie slice show the count of each team name.
Additional Resources
The following tutorials explain how to create other common visualizations in Excel:
How to Create a Bar of Pie Chart in Excel
How to Rotate Slices of a Pie Chart in Excel
How to Create a Double Doughnut Chart in Excel