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