• Home
  • Tools dropdown img
    • Spreadsheet Charts

      • ChartExpo for Google Sheets
      • ChartExpo for Microsoft Excel
    • Power BI Charts

      • Power BI Custom Visuals by ChartExpo
    • Word Cloud

  • Charts dropdown img
    • Chart Category

      • Bar Charts
      • Circle Graphs
      • Column Charts
      • Combo Charts
      • Comparison Charts
      • Line Graphs
      • PPC Charts
      • Sentiment Analysis Charts
      • Survey Charts
    • Chart Type

      • Box and Whisker Plot
      • Clustered Bar Chart
      • Clustered Column Chart
      • Comparison Bar Chart
      • Control Chart
      • CSAT Survey Bar Chart
      • CSAT Survey Chart
      • Dot Plot Chart
      • Double Bar Graph
      • Funnel Chart
      • Gauge Chart
      • Likert Scale Chart
      • Matrix Chart
      • Multi Axis Line Chart
      • Overlapping Bar Chart
      • Pareto Chart
      • Radar Chart
      • Radial Bar Chart
      • Sankey Diagram
      • Scatter Plot Chart
      • Slope Chart
      • Sunburst Chart
      • Tornado Chart
      • Waterfall Chart
      • Word Cloud
    • Google Sheets
      Microsoft Excel
  • Services
  • Pricing
  • Contact us
  • Blog
  • Support dropdown img
      • Gallery
      • Videos
      • Contact us
      • FAQs
      • Resources
    • Please feel free to contact us

      atsupport@chartexpo.com

Categories
All Data Visualizations Data Analytics Surveys
Add-ons/
  • Google Sheets
  • Microsoft Excel
  • Power BI
All Data Visualizations Data Analytics Surveys
Add-ons
  • Google Sheets
  • Microsoft Excel
  • Power BI

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok

ChartExpo Survey



Home > Blog > Google Sheets

How to Present Likert Scale Data in Excel and Google Sheets?

In statistics, you primarily deal with data collection, analysis, and presentation.

how to present Likert scale data

These three tasks are essential to help you achieve your objective of obtaining facts from your field. When you carry out research or a survey task, the result is to present the same information to your target audience.

Our primary focus is on how you present your findings. This is where data visualization comes in to save your day.

When you collect survey data about how the general public feels about your business, a chart called the Likert Scale can significantly help you.

This blog will help you understand how to present Likert Scale data to your target audience. Buckle up as we get to know more about a Likert Scale.

Table of Content:

  1. What is a Likert Scale?
  2. Best Way to Present Likert Scale Data
  3. How to Prepare Data for the Likert Scale?
  4. How to Visualize & Present Likert Scale Data?
  5. Wrap Up

What is a Likert Scale?

Definition: A Likert Scale is a visualization scale with two opposing poles. This scale visualizes how respondents choose agreement and disagreement levels.

Let us delve more profound into this scale.

You can use the Likert Scale to identify other people’s opinions, attitudes, and feelings about a specific product and service you provide.

You will visualize such information to obtain meaningful insights in such a case. This will also help you understand how to present Likert Scale data to your target audience.

As a business owner, knowing how your customers feel about your business services is essential. You want to understand if your customers are pleased or unhappy with your particular service. And for that, you will need to know how to visualize survey results.

Others, such as entertainment shows, can also benefit from such visualizations because they are interested in knowing how their audience feels. Therefore, collecting survey responses from some of your audiences is crucial.

If you have a marketer, psychologist, or sociologist profession, presenting Likert scale data is meant for you. This is because your career involves interacting with others to obtain their feedback and views about particular topics of interest.

Through such interaction, you can collect views from different people. By the end of it all, it is essential to understand how to report Likert scale data.

Let’s reveal one interesting fact about the Likert Scale.

The chart assumes that opinions, attitudes, and feelings are always in linear form.

Essentially, the path from an agreement to a disagreement is usually one that follows a straight line. Preparing your survey data and then presenting it on a Likert Scale is usually tedious work.

With that in mind, let us understand how to present Likert Scale data.

Best Way to Present Likert Scale Data

When presenting Likert Scale data, your goal is to make it presentable. You want to present a Likert Scale with meaningful insights your target audience can easily identify.

The Likert Scale is the best way to present survey results because it has unique features that make it easy to read and interpret.

Let’s discuss these unique features that should be present in a Likert Scale Chart.

A question section has a phrase you used in your question.

There is a bar that is divided into various segments. Still, every section has its inner labels.

There are Stats, which is the overall scale for your question. Stats are always auto-calculated.

Below is an example of how a Likert Scale should look like.

Best Way to Present Likert Scale Data

From the image, the example used is a 5-scale Likert Chart. The bar has five different colors you can use. The colors help your target audience to differentiate the responses easily. If you look into the image, you will notice the following:

  • Scale 1 (Strongly Dissatisfied) is mapped on the red bar.
  • Scale 2 (Dissatisfied) is mapped on the light-red
  • Scale 3 (Neutral) is mapped on the gray
  • Scale 4 (Satisfy) is mapped on the light green
  • Scale 5 (Strongly Satisfy) is mapped on the green bar.

The width of each bar is calculated based on the response values. Understanding your visualization will help you understand how to present Likert Scale Data.

How to Prepare Data for the Likert Scale?

Before you understand how to present Likert Scale data in a table, it is essential you understand how to prepare the survey results.

For visualization to bear fruit, you need to fill a table on the responses you collected. Some of the information you need to fill in your table includes:

Questions: These are the phrases you asked your respondents in your survey.

Scale: These range from one extreme positive attitude to a negative attitude. A Likert scale can be a 3-range, 5-range, or up to 10-range. Some of the most famous Likert scales used in surveys are:

  • 4-point Likert scale
  • 5-point Likert scale
  • 6-point Likert scale
  • 7-point Likert Scale

Responses: These are the number of people who answered the survey for individual ranges. They give their feedback or opinions to the questions you provide.

For example, you can ask, ” Were you satisfied with the product arrival timing?” this is your question.

Such a question will require that you use a 5-Likert Scale. 1 for Strongly Dissatisfied, 2 for Dissatisfy, 3 for Neutral, 4 for Satisfy, and 5 for Strongly Satisfy. These 1, 2, 3, 4, and 5 are your Scales.

Let’s assume 292 people answered 1 (Strongly Dissatisfied), 242 answered 2 (dissatisfied), 491 answered 3 (Neutral), 787 answered 4 (Strongly Satisfy), and 834 answered 5 (Satisfy). So you got 292 responses for 1, 242 responses for 2, 491 responses for 3, 787 responses for 4, and 834 responses for 5.

Your table will appear as shown below.

Questions Scale Responses
Were you satisfied with product arriving timing? 1 292
Were you satisfied with product arriving timing? 2 242
Were you satisfied with product arriving timing? 3 491
Were you satisfied with product arriving timing? 4 787
Were you satisfied with product arriving timing? 5 834

Whether you’re using a 2-point Likert Scale or a 10-point scale, the structure of this survey response method is exceptionally easy to use.

You can arrange each response precisely and logically on a linear scale. This makes it easy to distinguish the sentiments behind each answer. It becomes easier to use appropriate Likert Scale labels for each entry.

The structure of the Likert Scale will become easy from your perspective. Still, the respondents of your questionnaire also find your statements, questions, and scoring system exceptionally straightforward.

How to Visualize & Present Likert Scale Data?

On how we report Likert scale data, we have to use Microsoft Excel or Google Sheets. These spreadsheet tools will help you grasp how to present Likert Scale data.

We are sure that you have it installed on your personal computer.

However, your Excel or Google Sheets application does not have a Likert scale chart in its charts library.

Here comes the good news.

You can supercharge your Google Sheets and Excel with a third-party application called ChartExpo.

It comes with the benefit of numerous charts and graphs. When you use this third-party application, it is a sure bet that you will find a Likert Scale Chart.

Example 1: Present the Likert Scale Data in Excel

Let’s use a practical example of an individual who owns a software business.

Suppose you own an online store. Your survey to collect responses from customers. You want to understand customers’ attitudes toward your products and services.

Your objective was to obtain meaningful insights into the general attitude of his customers. He wanted to present the same information to his potential investors.

Before visualizing his survey results, he drafted some questions he would ask his customers. They include:

  • How satisfied were you with the way our operator handled your problem?
  • Were you satisfied with the product’s arriving timing?
  • Are you satisfied with product performance?

The questions were crucial because they would help him understand how to represent Likert Scale data.

His customers answered the survey questions, and he tabulated that data in an Excel table, as shown.

Questions Scales Responses
How satisfied were you with the way our operator handled your problem? 1 241
How satisfied were you with the way our operator handled your problem? 2 281
How satisfied were you with the way our operator handled your problem? 3 481
How satisfied were you with the way our operator handled your problem? 4 567
How satisfied were you with the way our operator handled your problem? 5 600
Were you satisfied with product arriving timing? 1 292
Were you satisfied with product arriving timing? 2 242
Were you satisfied with product arriving timing? 3 491
Were you satisfied with product arriving timing? 4 787
Were you satisfied with product arriving timing? 5 834
Are you satisfied with product performance? 1 287
Are you satisfied with product performance? 2 190
Are you satisfied with product performance? 3 354
Are you satisfied with product performance? 4 860
Are you satisfied with product performance? 5 978

To get started with ChartExpo in Excel, follow the steps below:

  • Open your Excel desktop application.
  • Open the worksheet and click the Insert button to access the My Apps option.
insert chartexpo in excel
  • Click the Insert button to initiate the ChartExpo engine.
open chartexpo in excel
  • Open the ChartExpo add-in. You will see a list of charts.
list of charts in excel
  • Click the Likert Scale Chart on your list of visualizations as shown.
search likert scale chart in excel
  • Select your worksheet data, and then Click on Create Chart From Selection.
create likert scale chart in excel
  • The final chart will appear as shown below.
presenting likert scale data

Example 2: Present the Likert Scale Data in Google Sheets

In our Google Sheets, we will use the same practical example discussed in Excel. These are the easy-to-follow steps you need to take in presenting your Likert Scale data in Google Sheets:

  • First, open Google Sheets in your browser, and click on Extensions > Charts, Graphs & Visualizations by ChartExpo > Open.
open chartexpo in google sheets
  • Click the Add New Chart button to access your fully stocked library of charts.
add new chart in google sheets
  • Once ChartExpo is loaded, you will see a list of charts. Look for the “Likert Scale Chart.”
search likert scale cahrt in google sheets
  • Select the sheet holding your data and select the Metrics Fill in the numerical numbers (in our case, we’ll use the Responses).
  • Select the Dimensions button and fill in the dimensional data (in our example, we’ll use Questions and Scales), as shown below.
  • Finish the simple process by clicking the Create Chart button.
create likert scale chart in google sheets

Your final chart will appear as shown below.

visualize Likert scale data

Insights

From this Likert Scale Chart, you can identify how customers view your products and services.

  • Overall view, most of your customers were happy with products and services 62%.
  • Most of your customers indicated that they are satisfied with the operator’s way of handling matters easily, 54%.
  • Most customers indicated that they are satisfied with product delivery timing, 62%.
  • Most of his customers indicated that the product meets their needs by 69%.

That is how to report Likert scale survey results.

FAQ:

What is the purpose of the Likert Scale?

Respondents select the option on a Likert scale that most closely matches their opinion. Asking respondents how much they agree or disagree with a given issue or statement, is frequently used to gauge the sentiments of respondents.

When can a Likert scale be used?

Likert scales cannot be used to evaluate characteristics like a person’s age or gender, for instance. However, it is the most effective tool for determining people’s sentiments and obtaining more detailed information about a particular topic.

Wrap Up

Let’s recap what we have covered.

We understand that survey data requires you to collect survey responses from your audience and present the same information. Your target audience needs to obtain meaningful insights from your survey results.

The objective of this blog was to help you, as a reader, understand how to present Likert Scale data. Your audience can be potential customers or future investors who want to be part of your business.

That’s not all.

In our discussions, we have come across one interesting third-party application that has made this all possible. We have used this third-party application in our Excel and Google Sheets spreadsheets. This third-party application is called ChartExpo.

How much did you enjoy this article?

GSAd2
Start Free Trial!
122537

Related articles

next previous
Google Sheets10 min read

Google Sheets Amortization Schedule with Clear Visuals

A Google Sheets Amortization Schedule tracks loan payments, interest, and balances. Learn how to create your schedule for better loan management.

Google Sheets11 min read

Google Sheet Profit and Loss Template for Financial Success

Google Sheet profit and loss template simplifies tracking income and expenses. Learn tips and steps for using this template for better financial management.

Google Sheets11 min read

Sales Tracking Spreadsheet for Better Insights

A Spreadsheet for Sales Tracking organizes data, tracks performance, and analyzes trends. This guide covers its benefits, templates, and visualization tips.

Google Sheets11 min read

How to Create a Chart in Google Sheets in Few Steps?

Learn step-by-step how to create a chart in Google Sheets to visualize your data clearly and effectively, even if you're a beginner.

Google Sheets14 min read

How to Use Google Spreadsheet for Insightful Results

Learn how to use Google Sheets for data management. You’ll discover tips on adding data, using formulas, creating charts, and more to streamline your work.

ChartExpo logo

Turn Data into Visual
Stories

CHARTEXPO

  • Home
  • Gallery
  • Videos
  • Services
  • Pricing
  • Contact us
  • FAQs
  • Privacy policy
  • Terms of Service
  • Sitemap

TOOLS

  • ChartExpo for Google Sheets
  • ChartExpo for Microsoft Excel
  • Power BI Custom Visuals by ChartExpo
  • Word Cloud

CATEGORIES

  • Bar Charts
  • Circle Graphs
  • Column Charts
  • Combo Charts
  • Comparison Charts
  • Line Graphs
  • PPC Charts
  • Sentiment Analysis Charts
  • Survey Charts

TOP CHARTS

  • Sankey Diagram
  • Likert Scale Chart
  • Comparison Bar Chart
  • Pareto Chart
  • Funnel Chart
  • Gauge Chart
  • Radar Chart
  • Radial Bar Chart
  • Sunburst Chart
  • see more
  • Scatter Plot Chart
  • CSAT Survey Bar Chart
  • CSAT Survey Chart
  • Dot Plot Chart
  • Double Bar Graph
  • Matrix Chart
  • Multi Axis Line Chart
  • Overlapping Bar Chart
  • Control Chart
  • Slope Chart
  • Clustered Bar Chart
  • Clustered Column Chart
  • Box and Whisker Plot
  • Tornado Chart
  • Waterfall Chart
  • Word Cloud
  • see less

RESOURCES

  • Blog
  • Resources
  • YouTube
SIGN UP FOR UPDATES

We wouldn't dream of spamming you or selling your info.

© 2025 ChartExpo, all rights reserved.