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.


1.1 For Yes/No Answer

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

Using Excel COUNTIF Function to Make Pie Chart without Numbers

Steps:

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

Using Excel COUNTIF Function to Make Pie Chart without Numbers

  • 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.

Using Excel COUNTIF Function to Make Pie Chart without Numbers

  • 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.


1.2 For Multiple Answers

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.

Using Excel COUNTIF Function to Make Pie Chart without Numbers

  • 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.

Using Excel COUNTIF Function to Make Pie Chart without Numbers

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

Read More: How to Make a Pie Chart with Multiple Data in Excel


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.

Make Pie Chart in Excel Using Pivot Chart

  • 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.

Make Pie Chart in Excel Using Pivot Chart

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

Make Pie Chart in Excel Using Pivot Chart

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

Make Pie Chart in Excel Using Pivot Chart

  • 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.

Read More: How to Create a Pie Chart in Excel from Pivot Table


Download Practice Workbook


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.


Related Articles

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
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo