How to Visualize Customer Satisfaction (CSAT) Scores in Google Slides Using a Stacked Bar Chart

Have you ever sat through a quarterly review where the presenter just throws up a massive table of Customer Satisfaction (CSAT) survey results?

I have. It’s painful.

You’re squinting at rows of raw percentages—"Very Satisfied: 42%", "Somewhat Dissatisfied: 12%"—trying to figure out if the overall trend is actually good or bad.

CSAT is arguably the most important metric for your business. It shouldn't be hidden in a spreadsheet grid. It needs to be instantly understood by everyone in the room.

That’s exactly why you need to be using a stacked bar chart.

Why Stacked Bar Charts Win for Sentiment Data

When you're dealing with survey responses (like a Likert scale ranging from "Very Dissatisfied" to "Very Satisfied"), you want to show the total distribution at a glance.

A stacked bar chart lines up all those responses into a single, cohesive bar that adds up to 100%.

Instead of forcing your audience to do mental math, the visual does the heavy lifting. You can instantly see the massive chunk of green (the happy customers) compared to the sliver of red (the unhappy ones) across different quarters or product lines.

The Clunky Reality of Native Google Slides

If you've tried building one of these charts using the default tools in Google Slides, you already know the headache.

You insert a chart, which immediately forces you out of your presentation and into an entirely separate Google Sheet. You mess around with the data tabs over there. Then you realize the default colors look terrible, the bar spacing is off, and the legend is eating up half your slide space.

By the time you get it looking somewhat decent and hit "Update" back in your slide deck, you've wasted 20 minutes on a single visual.

A Better Way: Building Natively with ExtraChart

I prefer building my charts without ever breaking my workflow. ExtraChart is a Google Slides add-on that essentially drops a pro-level chart editor right inside your presentation.

Let's walk through how to build a gorgeous, presentation-ready CSAT chart in about two minutes.

1. Launch ExtraChart and Select Your Chart

Open up your slide and navigate to Extensions -> ExtraChart -> Create & Edit Charts. The sidebar will pop up displaying a library of specialized chart types.

Click on the Stacked Bar Chart icon to get started.

2. Drop In Your CSAT Data

ExtraChart opens a clean popup editor right over your active slide. There is no jumping back and forth to a separate spreadsheet tab.

In the Data tab, set up your rows for your categories (like Q1, Q2, Q3) and your columns for the survey responses (Very Satisfied, Satisfied, Neutral, Dissatisfied, Very Dissatisfied).

If you already have this data sitting in Excel or Sheets, just copy and paste it directly into the ExtraChart editor cells. The real-time preview on the left will update instantly.

3. Dial In the Colors (The Most Crucial Step)

With CSAT data, color is everything. You want an intuitive traffic-light system so people instantly know what they are looking at.

Switch over to the Settings tab. Use a dark green for "Very Satisfied," a lighter green for "Satisfied," gray for "Neutral," orange for "Dissatisfied," and a stark red for "Very Dissatisfied."

ExtraChart's Color Palette Manager lets you input specific hex codes. If your company has strict brand guidelines for reporting, you can plug your exact corporate colors right in and save them as a custom palette for next time.

4. Clean Up the Layout

Native charts usually suffer from too much clutter.

In the settings menu, you have granular control. Turn off the background gridlines to give the chart a cleaner look. Adjust the bar padding so the individual bars are thick and easily readable from the back of a conference room.

I also recommend moving your legend to the top or bottom of the chart so it doesn't squash your bars horizontally.

5. Insert and Update on the Fly

Once it looks perfect in the preview, click "Create." The add-on drops a crisp, high-resolution image of your stacked bar chart directly onto your slide.

Here is my favorite part: if your customer success team slacks you updated survey numbers ten minutes before the big meeting, you don't have to start over.

Just select the chart image on your slide, open the ExtraChart add-on, and it pulls up your exact configuration. Edit the numbers, hit update, and you are ready to present.

Your customer satisfaction scores tell the story of your company's health. Make sure that story is loud, clear, and impossible to ignore. Grab ExtraChart from the Google Workspace Marketplace and start presenting data the right way.