How to Graph Qualitative Data in Excel
Turning a spreadsheet full of survey responses or customer feedback into an insightful graph can feel like magic. Plain text doesn't always want to cooperate with charting tools, but a few simple steps in Excel can transform those words into a clear, professional visual. This article will show you exactly how to quantify and graph your qualitative data, making it easy to spot trends and present your findings effectively.
What Qualifies as Qualitative Data?
Before diving into graphs, let’s be clear about what we’re working with. Qualitative data, also known as categorical data, is information that describes qualities or characteristics. It isn't inherently numerical, instead, it consists of words, labels, or observations that can be grouped together.
In a business context, you're surrounded by qualitative data, such as:
- Customer feedback themes (e.g., "Fast Support," "Confusing Interface," "Affordable Price")
- Responses from multiple-choice survey questions ("Yes/No/Maybe," "Satisfied/Neutral/Dissatisfied")
- Product categories ("Apparel," "Electronics," "Home Goods")
- Marketing channels ("Organic Search," "Paid Social," "Email")
- Customer support ticket tags ("Billing Issue," "Technical Bug," "Feature Request")
The challenge is that you can't just highlight a column of text and tell Excel to create a chart. It needs numbers to work with. The goal isn't just to make a pretty picture, it’s about making your data understandable at a glance. A bar chart showing "Confusing Interface" as the most common feedback point is far more impactful than a raw list of customer quotes.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Step 1: Summarize and Count Your Qualitative Data
The foundation of graphing qualitative data is converting it into an easy-to-digest summary. This means counting how many times each category or theme appears in your dataset. This might sound tedious, but Excel has a powerful formula to make it fast and painless: COUNTIF.
Imagine you've just collected feedback on your new mobile app. Your raw data in Column A might look something like this:
Easy to navigate Crashes sometimes Love the dark mode Easy to navigate Crashes sometimes Missing key features Love the dark mode Easy to navigate
You can see the repeating themes. Your task is to count them.
How to Create a Summary Table with COUNTIF
First, create a separate, clean list of the unique categories you want to count.
- List Your Unique Categories: In a new area of your sheet (let’s use column D), type out each unique feedback theme once.
- Use the COUNTIF Formula: In the cell next to your first category (E2), you'll type the formula. The formula syntax is
=COUNTIF(range, criteria).
So, the formula for cell E2 would be:
=COUNTIF(A:A, D2)
Press Enter, and Excel will count every instance of "Easy to navigate." Now, just click on the small square at the bottom-right corner of cell E2 and drag it down. Excel will automatically adjust the formula for each category in your list.
You’ll end up with a neat summary table that looks like this, which is now perfectly chartable:
- Easy to navigate | 3
- Crashes sometimes | 2
- Love the dark mode | 2
- Missing key features | 1
With this crucial step done, you're ready to visualize the results.
Step 2: Choose the Right Chart for a Clear Story
The type of chart you choose will determine how well your story is told. For qualitative data, your main goal is to compare the counts of different categories. Here are the best charts for the job and when to use them:
- Bar/Column Chart: The most reliable and versatile option. It makes comparing the size of different categories incredibly easy. Your audience can quickly see what the most and least common responses are. Use a column chart (vertical bars) if you have fewer categories, and a bar chart (horizontal bars) if you have longer category names.
- Pie Chart: Use a pie chart when you want to show parts of a whole - specifically, how each category contributes to the total. It’s effective for simple breakdowns like "Yes/No" answers, but it becomes hard to read with more than five or six categories, especially when the slices are similar in size.
- Donut Chart: Functionally the same as a pie chart, but some find its modern aesthetic more appealing. The same limitations apply - keep the number of categories small.
- Stacked Bar Chart: A more advanced option, perfect for when you have another layer of qualitative data to compare. For example, you could break down your feedback themes by customer type (e.g., "Free Users" vs. "Paid Subscribers") to see if their concerns differ.
For most scenarios, the simple Bar Chart is your best friend. It’s straightforward, hard to misinterpret, and great for direct comparisons.
Step 3: Creating Your Graphs in Excel
With your summary table prepared, creating the actual graph only takes a few clicks.
How to Make a Bar or Column Chart
Let’s stick with our user feedback example.
- Select Your Data: Highlight both columns of your summary table - the category names and their counts.
- Find the Charts: Go to the Insert tab on Excel's ribbon.
- Choose Your Chart: In the 'Charts' section, click the icon that looks like vertical bars ("Insert Column or Bar Chart"). A dropdown will appear.
- Pick a Style: Select either a "2-D Column" or a "2-D Bar" chart. 2-D is almost always clearer and more professional than 3-D.
And just like that, Excel generates a chart that visually represents your qualitative feedback.
How to Make a Pie Chart
If you decide the "part of a whole" perspective is what you need, making a pie chart is just as easy.
- Select Your Data: Highlight your summary table (categories and counts).
- Go to Insert: Navigate to the Insert tab.
- Choose Pie Chart: Find the icon that looks like a pie ("Insert Pie or Doughnut Chart") and select a "2-D Pie."
- Excel will create a pie chart. To make it more useful, right-click anywhere on the pie itself and select "Add Data Labels." You can then format these labels to show percentages, giving your audience immediate context on the distribution of feedback.
Leveling Up With a Stacked Bar Chart
Imagine you have another dimension to your data: the user’s subscription plan ("Free" vs. "Premium"). You want to see if feedback differs between these two groups.
First, you'd need a more complex summary table, likely created with the COUNTIFS formula, which lets you count based on multiple criteria. For example, =COUNTIFS(A:A, "Crashes sometimes", B:B, "Premium") would count how many premium users reported crashes.
Your summary table would now look like this:
To graph this:
- Select the Whole Table: Highlight all the data, including headers.
- Go to Insert > Bar Chart: Just as before, navigate to the chart creator panel on the Insert panel.
- Choose Stacked Bar: Select one of the "Stacked Bar" or "Stacked Column" options.
Excel will generate a chart where each bar represents a feedback theme, and the segments within that bar show the breakdown between Free and Premium users. This is a highly effective way to add depth to your analysis without cluttering the view.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Pro Tips for Polishing Your Charts
Creating a chart is easy. Creating a good chart takes a little refinement. Follow these tips to make sure your visualizations are clear, professional, and impactful.
- Write a Descriptive Title: Change the default "Chart Title" to something that explains what the watcher is seeing. "Analysis of User Feedback - May 2024" is much better than the generic title.
- Sort Your Data: Before making your chart, sort your summary table by count from largest to smallest. A bar chart that's ordered this way is much easier to read and immediately shows what's most important.
- Keep It Clean: Think minimalism. A clean chart is easier to understand. Remove unnecessary elements like distracting background gridlines or fancy 3-D effects.
- Use Color Deliberately: Don't rely on the default Excel color palette. Stick to a simple set of colors, maybe pulling from your brand's palette. You can also use a neutral color for all bars except one you want to highlight in a bolder, contrasting color to draw attention to it.
- Label Clearly: Axis labels should be legible and easy to read. A bit more context with labels makes your charts a lot easier to scan and understand without needing any prior info.
Final Thoughts
Getting your qualitative insights into a visual format is all about one central process: first, you quantify your categories, then you chart those numbers. By turning text-based data like feedback or survey answers into a simple summary table, powerful tools like Bar and Pie charts become instantly accessible in Excel, giving you deep insights in minutes.
Manually counting, categorizing, and designing reports in Excel is a great skill, but the process can become repetitive and time-consuming, especially as your data sources grow. We built Graphed to handle all of this for you. By connecting data sources directly, you can skip the spreadsheets. Instead, just use simple text prompts, and Graphed creates live dashboards automatically. This saves hours of manual work, helping you get from raw data to actionable insights in record time.
Related Articles
Facebook Ads For Dental Practices: The Complete 2026 Strategy Guide
Learn how to effectively use facebook ads for dental practices to attract new patients to your dental practice. This comprehensive 2026 guide covers targeting, budgeting, creative strategies, and ROI expectations.
Test: Facebook Ads For Dentists 2026
Test excerpt
Facebook Ads for Landscapers: The Complete 2026 Strategy Guide
Learn how to run profitable Facebook ads for landscapers in 2026. This complete guide covers audience targeting, ad formats, budgeting, and optimization strategies to generate leads at $30-50 per lead.