# How to Make a Pie Chart in Excel without Numbers (2 Effective Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this tutorial, you will learn how to make a Pie Chart in Excel without numbers. This type of situation is very common where you need peopleâ€™s opinions on any issue. After collecting the opinions, you can generate a Pie Chart to visualize the data properly.

Watch Video â€“ Make a Pie Chart without Number

## How to Make a Pie Chart in Excel without Numbers: 2 Effective Ways

### 1. Using Excel COUNTIF Function to Make Pie Chart without Numbers

The COUNTIF function in Excel counts the number of cells that meet a specified condition. This feature of the COUNTIF function is very helpful to make Pie Charts in Excel from data without numbers.

For this method, we have a dataset that contains the answers people gave on whether they were infected with Covidâ€“19. Obviously, all the answers are only either Yes or No. Let us see how we can use this data to create a Pie Chart.

Steps:

• First of all, select cell F5 and type in the following formula:
=COUNTIF(C5:C10,E5)
• Then, press Enter.

• As a result, the formula will count the number of times the option Yes is found in the data table.
• Now, click and drag the Fill handle tool to copy the formula to the cell below.

• After that, select the table from cell E4 to F6 and navigate to the InsertÂ tab.
• Below the Insert tab, click the Insert Pie Chart drop-down.
• From there, click on the 2-D PieÂ option.

• Thus, you will get a nice and clear Pie Chart representing your data.

In this method, we have the dataset of studentsâ€™ answers on their favorite subject. Unlike the first method, here we have multiple answers to the question. This type of dataset is very common in real-life situations. So, follow the steps below to get a Pie Chart from this data.

Steps:

• To begin with, select cell F5 and enter the following formula:
=COUNTIF(C5:C10,E5)
• Note that, you can also type the formula directly into the formula bar.

• Now, press Enter and copy the formula to the cells below using the Fill Handle.
• Then, select the table from cell E4 to F7 and go to the Insert tab above.
• There, click on the Insert Pie Chart drop-down and select 2-D Pie.

• As a result, Excel will generate a Pie Chart showing the proportions of the answers.

### 2. Make Pie Chart in Excel Using Pivot Chart

We can easily create a Pie Chart for data without numbers using Pivot Charts. We are using the same data set from the first method to keep things simple. Let us jump right into this final method.

Steps:

• First, select the dataset from cells B4 to C10.
• Second, go to the Insert tab and select the PivotChart dropdown.
• Below this, click on the PivotChartÂ option.

• Now, in the new Create PivotChart window, select the option Existing Worksheet.
• After that, click on an empty cell in column E and press OK.

• Then, on the right, a new PivotChart Fields window opens.
• Here, check the Answer option and drag the Answer option to the ValuesÂ section.

• Now, you will see a pivot chart on the worksheet.

• Next, right-click on any of the bars on the pivot chart.
• Then, from the options menu select Change Series Chart Type.

• After that, in the Change Chart Type window select Pie and press OK.

• Finally, the last operation will convert the pivot chart into a Pie Chart.

## Conclusion

I hope that you thoroughly understood the methods I showed in this tutorial to make a Pie Chart in Excel without numbers. You should keep in mind that, you can only create Pie Charts for a single column or row of data. Also, Pie Charts are not very suitable for many data cells. With that said, I would encourage you to try some formatting on your Pie Chart and make it more readable. And lastly, to learn more Excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF