How to Make a Pie Chart in Excel Without Numbers

Creating a pie chart in Excel usually means you have a table of categories and their corresponding numbers ready to go. But what if your raw data doesn't have any numbers? This article will walk you through exactly how to build a clear, insightful pie chart when all you have is a list of text-based entries, like survey responses or status updates.

Why Make a Pie Chart Without Numbers?

It sounds a little strange, but it’s a very common scenario. You’re not trying to visualize pre-calculated numbers, you’re trying to visualize the frequency or distribution of different text-based categories. Excel can do the counting for you and turn that into a pie chart.

Here are a few relatable examples where your source data has no numbers:

• Survey Results: A column full of responses like "Yes," "No," and "Maybe."

• Project Management: A list of tasks with statuses like "Completed," "In Progress," and "Not Started."

• Customer Feedback: A spreadsheet of satisfaction ratings such as "Excellent," "Good," "Fair," and "Poor."

• Inventory Categorization: A list of products categorized by "Apparel," "Electronics," or "Home Goods."

In each case, your goal is the same: to show what proportion of the whole each category represents. You need a pie chart to visualize the percentage of "Completed" tasks or the share of "Excellent" customer ratings. Let's walk through how to create one using a customer feedback example.

Step 1: Get Your Data Ready

First, make sure your data is organized in a single column in your Excel sheet. This clean, simple format makes it easy for Excel's tools to process the information. It’s okay if there are duplicates, in fact, that's expected. The whole point is to count those repeated entries.

For our example, imagine you have a list of customer satisfaction ratings from a recent survey. Your data in Column A might look something like this:

AExcellentGoodGoodFairExcellentPoorGoodFair...

This single column is all you need to get started. While you can clean it up by fixing typos and ensuring consistent capitalization (e.g., "good" is the same as "Good"), Excel is generally smart enough to group similar items. Having a clean list is just good practice.

Step 2: Summarize Your Categorical Data with a PivotTable

The secret to turning your list of text into a chart is to first summarize it. You need a simple table that lists each unique category and counts how many times it appears. The fastest and most dynamic way to do this in Excel is by using a PivotTable.

If you've never used a PivotTable, don’t worry. This is a perfect, simple introduction. It does all the heavy lifting of counting and organizing for you in just a few clicks.

How to Create the PivotTable

1. Select Your Data: Click any single cell within your data column (e.g., A1). You don't need to highlight the entire column, Excel will automatically detect the range.

2. Insert PivotTable: Navigate to the Insert tab on the Excel ribbon and click on PivotTable.

3. Confirm Your Selections: A dialog box will appear. Excel will have already selected your data range (e.g., 'Sheet1'!$A$1:$A$100). It will also default to creating the PivotTable in a New Worksheet, which is the best option to keep things tidy. Just click OK.

4. Configure the PivotTable Fields: You will now see a blank PivotTable on the left and a "PivotTable Fields" pane on the right. This pane contains the name of your data column (it will likely be named "Column A" or whatever header you gave it, like "Rating").

   • Drag your field ("Rating") from the upper section down into the Rows area. This will create a unique, alphabetized list of all your categories ("Excellent," "Fair," "Good," "Poor").

   • Next, drag that same field ("Rating") down into the Values area.

When you drag a text-based field into the "Values" box, Excel automatically knows you want to count it. It will display it as "Count of Rating." And just like that, you've created a summary table that looks like this:

This table is now the perfect source for your pie chart. It has the categories and the corresponding numbers you need.

Step 3: Create the Pie Chart from the PivotTable

With your PivotTable ready, creating the actual pie chart is simple. Because the chart will be linked to the PivotTable, it will even update automatically if you add new raw data and refresh the PivotTable — a huge time-saver.

1. Select Your PivotTable: Click anywhere inside your new summary table.

2. Insert the Pie Chart: Go to the Insert tab on the ribbon. In the Charts section, click the Pie Chart icon (it looks like a small pie).

3. Choose Your Chart Type: You'll see a dropdown menu with different styles, like a standard 2D Pie, a 3D Pie, or a Doughnut chart. Pick the one that works best for you. A simple 2D pie chart is usually the clearest for most use cases.

As soon as you make your selection, Excel will instantly generate a pie chart based on your PivotTable data. It will automatically assign a different color to each slice and add a legend.

Alternative Method: Using the COUNTIF Formula

If you prefer not to use a PivotTable or need a more self-contained solution within the same worksheet, you can achieve the same result using an Excel formula. This method is a bit more manual but gives you complete control.

Step 1: Create a List of Unique Categories

First, you need a list of the unique items from your raw data column.

• For Modern Excel (Microsoft 365): You can use the UNIQUE function. Find an empty cell, type =UNIQUE(A2:A101) (adjusting the range to match your data), and press Enter. Excel will spill the unique categories into the cells below.

• For Older Excel Versions: Copy your entire raw data column and paste it into a new column. With that new column selected, go to the Data tab and click Remove Duplicates. Click OK, and you'll be left with a clean list of your unique categories.

Step 2: Count Each Category Using COUNTIF

Now, next to your new list of unique categories, you'll use the COUNTIF formula to count how many times each one appears in your original data set.

Let's say your unique list ("Excellent," "Fair," etc.) is in column C, starting at C2. Your original raw data is still in column A. In cell D2 (right next to "Excellent"), type the following formula:

=COUNTIF($A$2:$A$101, C2)

Here's a breakdown:

• $A$2:$A$101 is the absolute range of your raw data. The dollar signs fix the range when dragging.

• C2 is the category to count.

Press Enter, then click on D2 and drag the fill handle down to fill the formula for other categories. You now have a manually-created summary table.

Step 3: Insert the Pie Chart

Highlight your new summary table (categories and counts), go to the Insert tab, and select your preferred Pie Chart. You’ve built your chart without a PivotTable.

Step 4: Customize Your Pie Chart for Maximum Impact

A default Excel chart is a good start, but a few quick customizations can make it much easier for your audience to read and understand.

• Add Data Labels: Right-click on the pie chart and select Add Data Labels. This adds the counts. For clarity, right-click again, choose Format Data Labels, and check Category Name and Percentage. Uncheck Value if you only want percentages.

• Give It a Clear Title: Click on "Chart Title" and name it, e.g., "Customer Satisfaction Ratings."

• Change Colors: Under Chart Design > Change Colors, pick a palette that fits your style.

• Explode a Slice: Click on the pie once to select it, then click again on a specific slice. Drag it outward to highlight it.

Final Thoughts

Creating a pie chart in Excel from a list of text categories boils down to one key idea: count the items first. Whether you use a quick PivotTable or a manual COUNTIF formula, the process of summarizing your non-numeric data is essential for meaningful visualization.

Manually refreshing these reports can sometimes feel draining, especially when pulling from multiple sources. We designed Graphed to automate that process. Connect your data sources (Google Sheets, HubSpot, Google Analytics) and ask in plain English, "Show me a pie chart of my Shopify sales by product category." Our AI creates a real-time, interactive dashboard in seconds, letting you focus on insights rather than data gathering.