• Home
  • Tools
    • PPC Signal
    • PPCexpo Keyword Planner
    • PPC Audit
    • ChartExpoTM PPC Charts
    • PPCexpo PPC Reports
    • Combinations Calculator
  • Pricing
  • Contact us
  • Resources
    • PPC Signal Dashboard
    • PPC Reports Templates
    • PPC Guide
    • Join Our Facebook Group
    • Charts
      • CSAT Score Survey Chart
      • Likert Scale Chart
      • Pareto Chart
      • Sankey Diagram
  • Blog
Categories
All Digital Marketing PPC SEO SMM Data Visualization
All Digital Marketing PPC SEO SMM Data Visualization

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
Home > Blog > Digital Marketing > Data Visualization >

How to Present Likert Scale Data? An Ultimate Guide for Google Sheets Users

A Likert Scale Chart is an evenly scale from which respondents choose the level of agreement or disagreement. It can be used to measure the product or service analysis whether consumer is pleased or having issues with a particular product or service.  Having a survey data and then properly mapping on Likert Scale Graph is a tedious work. But in this step by step guide we will show you how to present Likert Scale data by using ChartExpo Library in Google Sheets.

How to Present Likert Scale Data

Types of Likert Scale Chart supported by ChartExpo

Likert Scale Chart in ChartExpo offers numerous types of scales. You can choose scales from 2 to 10.  Let’s see blow how can you create this by using ChartExpo library in Google Sheets.

Table Of Content

  • How to do data formation for Likert Scale Chart?
  • How to create 3-Scales Likert Scale Chart?
  • How to create 5- Scales Likert Scale Chart?
  • How to create 7- Scales Likert Scale Chart?
  • How to create 10- Scales Likert Scale Chart?
  • How to understand and change properties of Likert Scale Chart?
  • How Reset all button works?
  • How to change color of each section of bars?

How to do data formation for Likert Chart?

First of all you need to make your survey data as filled in below table.

Tabular data for Likert Scale Chart should include questions, scale and responses.

Questions are those phrases which you asked in survey.

Scale is ranges from one extreme positive attitude to negative attitude.

Responses is the number of people who answered the survey for individual range.

For example you asked “How do you rate our product?” this is your questions and you used 2 Likert Scale. 1 for (Dissatisfy) and 2 (Satisfy). These 1 and 2 are your Scales. Suppose 34 people answered for 1 (Dissatisfy) and 45 people answered for 2 (Satisfy). So you got 34 responses for 1 and 45 responses for 2.

This is how you will create your data.

Questions Scale Responses
How do you rate our product? 1 34
How do you rate our product? 2 45

Case Study

You have the survey data of cleaning services. You need the information to better optimize the services to suit your clients’ needs. The questions included in survey were:

  • How do you rate our cleaning staff behavior?
  • How do you rate our cleaning services?
  • Do you recommend our cleaning services?

In this guide, we will discuss 3, 5, 7, 10 scales to create chart. Let’s begin.

If you have not installed ChartExpo Google Sheets Add-on, you can install it from here.

How to Present Likert Scale Data

Let’s Draw 3-Scales “Likert Scale Chart” in Google Sheets

Here are few details you need to know while creating Likert Scale Chart in Google Sheets.

Scale Understanding

For every response specific scale is provided. Which will be required to draw the visualization. Let’s understand the scale in “3 scales Likert Scale Chart”.

1 = Disagree

2 = Neutral

3 = Agree

Prepare data for 3-scales Likert Scale Chart

Your data should be prepared as shown below.

Questions Scale Responses
How do you rate our cleaning staff behavior? 1 324
How do you rate our cleaning staff behavior? 2 176
How do you rate our cleaning staff behavior? 3 230
How do you rate our cleaning services? 1 138
How do you rate our cleaning services? 2 186
How do you rate our cleaning services? 3 176
Will you recommend our services in your circle? 1 0
Will you recommend our services in your circle? 2 138
Will you recommend our services in your circle? 3 186

Once you are done with ChartExpo Google Sheets Add-on installation. Simply, copy data from above table and paste in Google Sheets then go to Add-ons or Extensions menu, find “ChartExpo – Best Data Visualization Tool, and click on Open.

How to Present Likert Scale Data

Now click on Create New Chart button.

How to Present Likert Scale Data

You will find Likert Scale Chart under the category of “Specialized Survey Charts”.

How to Present Likert Scale Data

After click on the Likert Scale Chart you will find some attributes which should be filled to draw this chart.

Create Likert Scale Chart in 5 simple steps

Step 1: Select relevant sheet name.

Step 2: Select the column of Questions.

Step 3: Select the column of Scale.

Step 4: Select the column of Responses.

How to Present Likert Scale Data

Step5: Once you filled these attributes you can click on “Create Chart” button.

How to Present Likert Scale Data
How to Present Likert Scale Data

Note: When you click on Create Chart button by default chart will be drawn on 5 scales. You have to change few chart properties to get 3 scales Likert Scale Chart.

The default visualization shown in the window is not based on 3 Scales to make it according to 3 scales you need to go to Chart Settings as highlighted below.

How to Present Likert Scale Data

Look for Scale Type.

How to Present Likert Scale Data

In Scale Type, you can choose Scale.

How to Present Likert Scale Data

In our case, we will choose 3 scale option.

How to Present Likert Scale Data

After selecting scale of 3. Click on Apply.

How to Present Likert Scale Data

Your 3 Scale Chart is ready to present!

Let’s discuss few things about Likert Scale Chart.

Question Section will have a phrase whichever you used in your question.

Bar is divided into different sections and each section have its own inner labels.

Stats is the overall scale or rating for your question and it is auto calculated.

How to Present Likert Scale Data

In the bar you can see there are three different colors used, so the viewer can easily differentiate the responses. If you look into this mapping you will notice that

Scale 1 (Dissatisfy) is mapped on red bar

Scale 2 (Neutral) is mapped on grey

Scale 3 (Satisfy) is mapped on green.

Width of each bar is calculated based on the response values.

There are few properties which you need to know which can help you to change the aesthetic of this chart. These properties are explained in detail later in this guide. Click here to go directly to properties section.

Let’s Draw 5-Scale Likert Scale Chart in Google Sheets

Scale Understanding

For every response specific scale is provided. Which will be required to draw the visualization. Let’s understand the scaling in 5 scale Likert Scale Chart.

1 = Strongly Disagree

2 = Disagree

3 = Neutral

4 = Agree

5 = Strongly Agree

Prepare data for 5-scale Likert Scale Chart

Suppose you have data of 5-scale survey data for same questions.

Questions Scale Responses
How do you rate our cleaning staff behavior? 1 35
How do you rate our cleaning staff behavior? 2 219
How do you rate our cleaning staff behavior? 3 146
How do you rate our cleaning staff behavior? 4 45
How do you rate our cleaning staff behavior? 5 193
How do you rate our cleaning services? 1 180
How do you rate our cleaning services? 2 204
How do you rate our cleaning services? 3 129
How do you rate our cleaning services? 4 193
How do you rate our cleaning services? 5 134
Will you recommend our services in your circle? 1 274
Will you recommend our services in your circle? 2 5
Will you recommend our services in your circle? 3 105
Will you recommend our services in your circle? 4 3
Will you recommend our services in your circle? 5 253

You can choose Likert Scale Chart under category of Specialized Survey Charts.

How to Present Likert Scale Data

Create Likert Scale Chart in 5 simple steps

Step 1: Select relevant sheet name.

Step 2: Select the column of Questions.

Step 3: Select the column of Scale.

Step 4: Select the column of Responses.

Step5: Once everything is selected. Click on Create Chart.

How to Present Likert Scale Data
How to Present Likert Scale Data
This time you don’t need to change any property to convert this chart to 5-scales. Because by default ChartExpo show Likert Scale Chart with 5-Scales.
How to Present Likert Scale Data

Click here to go directly to properties section.

Let’s Draw 7-Scale Likert Scale Chart in Google Sheets

Scale Understanding

For every response specific scale is provided. Which will be required to draw the visualization. Let’s understand the scaling in 7 scales Likert Scale Chart.

1 = Strongly Disagree

2 = Disagree

3 = Partially Disagree

4 = Neutral

5 = Partially Agree

6 = Agree

7 = Strongly Agree

Prepare data for 7-scales Likert Scale Chart

Let’s make Likert Scale Chart for 7-scales. For this we will use old example but will add more scales in it.

Questions Scale Responses
How do you rate our cleaning staff behavior? 1 247
How do you rate our cleaning staff behavior? 2 216
How do you rate our cleaning staff behavior? 3 23
How do you rate our cleaning staff behavior? 4 149
How do you rate our cleaning staff behavior? 5 196
How do you rate our cleaning staff behavior? 6 124
How do you rate our cleaning staff behavior? 7 80
How do you rate our cleaning services? 1 291
How do you rate our cleaning services? 2 252
How do you rate our cleaning services? 3 203
How do you rate our cleaning services? 4 179
How do you rate our cleaning services? 5 97
How do you rate our cleaning services? 6 292
How do you rate our cleaning services? 7 142
Will you recommend our services in your circle? 1 205
Will you recommend our services in your circle? 2 100
Will you recommend our services in your circle? 3 200
Will you recommend our services in your circle? 4 238
Will you recommend our services in your circle? 5 258
Will you recommend our services in your circle? 6 75
Will you recommend our services in your circle? 7 130

Choose Likert Scale Chart under category of Specialized Survey Charts.

How to Present Likert Scale Data

Create Likert Scale Chart in 5 simple steps

Step 1: Select relevant sheet name.

Step 2: Select the column of Questions.

Step 3: Select the column of Scale.

Step 4: Select the column of Responses.

Step5: Click on Create Chart after selecting all columns.

How to Present Likert Scale Data
How to Present Likert Scale Data
By default chart will be drawn on 5 scales. You can change to 7 scales by clicking on Chart Settings. From Scale Type property set scale on 7. Click on Apply.
How to Present Likert Scale Data
Once you apply the settings, chart will be converted to 7-scales Likert Scale Chart.
How to Present Likert Scale Data

Click here to go directly to properties section.

Let’s Draw 10-Scales Likert Scale Chart in Google Sheets

Scale Understanding

For every response specific scale is provided. Which will be required by chart to draw the visualization. Let’s understand the scaling in 10 scale Likert Scale Chart.

1 = Strongly Disagree

2 = Moderately Disagree

3 = Little More Disagree

4 = Mildly Disagree

5 = Partially Disagree

6 = Partially Agree

7 = Mildly Agree

8 = Little More Agree

9 = Moderately Agree

10 = Strongly Agree

Prepare data for 10-scale Likert Scale Chart

Below table is to prepare data for 10-scale Likert Scale Chart to be drawn by ChartExpo.

Questions Scale Responses
How do you rate our cleaning staff behavior? 1 229
How do you rate our cleaning staff behavior? 2 76
How do you rate our cleaning staff behavior? 3 110
How do you rate our cleaning staff behavior? 4 50
How do you rate our cleaning staff behavior? 5 150
How do you rate our cleaning staff behavior? 6 167
How do you rate our cleaning staff behavior? 7 224
How do you rate our cleaning staff behavior? 8 170
How do you rate our cleaning staff behavior? 9 10
How do you rate our cleaning staff behavior? 10 147
How do you rate our cleaning services? 1 71
How do you rate our cleaning services? 2 73
How do you rate our cleaning services? 3 85
How do you rate our cleaning services? 4 238
How do you rate our cleaning services? 5 91
How do you rate our cleaning services? 6 152
How do you rate our cleaning services? 7 51
How do you rate our cleaning services? 8 18
How do you rate our cleaning services? 9 20
How do you rate our cleaning services? 10 148
Will you recommend our services in your circle? 1 233
Will you recommend our services in your circle? 2 46
Will you recommend our services in your circle? 3 144
Will you recommend our services in your circle? 4 246
Will you recommend our services in your circle? 5 129
Will you recommend our services in your circle? 6 126
Will you recommend our services in your circle? 7 234
Will you recommend our services in your circle? 8 228
Will you recommend our services in your circle? 9 182
Will you recommend our services in your circle? 10 190

Select Specialized Survey Charts under this category you will find Likert Scale Chart.

How to Present Likert Scale Data

Create Likert Scale Chart in 5 simple steps

Step 1: Select relevant sheet name.

Step 2: Select the column of Questions.

Step 3: Select the column of Scale.

Step 4: Select the column of Responses.

Step5: After doing prerequisites click on Create Chart.

How to Present Likert Scale Data
How to Present Likert Scale Data
This visualization is on 5 scale Likert Scale Chart. Change this visualization on 10 scale From Chart Setting. Go to Scale Type property and selecting 10 from Scale.
How to Present Likert Scale Data
Here is your visualization.
How to Present Likert Scale Data

 

Understand Different Properties for Likert Scale Chart

1-How to add heading, footer, and left label on Chart?

Click on Edit Chart.

How to Present Likert Scale Data
Click on Chart Header pencil icon.
How to Present Likert Scale Data

Click on Text.

How to Present Likert Scale Data

Here you can add text as per you requirement. You can show header text in 2 lines.

How to Present Likert Scale Data

Then comes “Show” button, it can enable and disable to show the header on chart.

How to Present Likert Scale Data

You can change font style of header from Font Style. Here you can apply font styles on your header as per your requirement.

How to Present Likert Scale Data

Here we will just change the size of font to 20. If you are done with your changes of font style, click on Apply.

How to Present Likert Scale Data

Our header is added, you can find it on the top center of the chart.

How to Present Likert Scale Data

You can add footer by going to pencil icon in the bottom.

How to Present Likert Scale Data

Through this new property window you can add footer.

How to Present Likert Scale Data

Here we are just add random footer Likert Scale Chart.

How to Present Likert Scale Data

You can also add left label by clicking on highlighted pencil icon.

How to Present Likert Scale Data

Here you can add left label as per your requirement.

How to Present Likert Scale Data

Again let’s add random left label.

How to Present Likert Scale Data

2-How to change properties of the chart?

Click on pencil icon on the left on Overall bars.

How to Present Likert Scale Data
First property in this new window is Bar.
How to Present Likert Scale Data

From “Bar” section you can select minimum, maximum height, gaps b/w bars, and Gap b/w axis.

How to Present Likert Scale Data

Then comes “Bar Color” section, from here you can individually change bar colors. Later this section is explained in detail. Click here to go to bar color properties section.

With “Inner Label” property you can show or hide Inner Labels.

How to Present Likert Scale Data

Let explore the font of Inner Label. In this section, you can change the font style. Let’s bold Inner Labels and change its color.

How to Present Likert Scale Data

Next, let’s see “Question” section:

  • You can show or hide questions (bar labels).
  • You can add numbering to questions by Show questions no.
  • Total Responses can show or hide by Show total property.
  • Box can be show or hide by Show box property.
  • You can adjust Background color of questions labels.
How to Present Likert Scale Data

Below that you will find “Question Font Style” section. In this property section, you can change the font style of questions. For this case let adjust questions font size to 18.

How to Present Likert Scale Data

When you click on Stats. You can show or hide Stats with enable disable button . You can also select the background color of Stats.

How to Present Likert Scale Data

Now, let’s look into Stats Font Style property. In this we will make Stats italic.

How to Present Likert Scale Data

Once done with all changes click on Apply All.

How to Present Likert Scale Data

You will see all changes after they are applied.  Colors of labels, font size etc. all you changed have been updated in this chart below.

How to Present Likert Scale Data

3-How to change base colors of bars?

Click on Chart Settings.

How to Present Likert Scale Data

Go to Scale Type. You will find property for changing base colors of bars.

How to Present Likert Scale Data

If you scroll down a bit. You will see Negative Base Color, Neutral Default Color, and Positive Base Color options.

Let’s change the color of Negative Base Color to blue, Neutral Default Color to black, and Positive Base Color to yellow.

How to Present Likert Scale Data

After choosing required colors click on Apply.

How to Present Likert Scale Data

 

How to Present Likert Scale Data
How to Present Likert Scale Data

If you want to individually change the bar colors, click here to that section.

4-How to change scale colors?

As discussed earlier the colors of axis didn’t it was looking like this. Here we will explain how you change them.

How to Present Likert Scale Data

You can change colors of Scale by clicking on pencil icon on the Scale.

How to Present Likert Scale Data

Click on Axis Label Font Style.

How to Present Likert Scale Data

Let’s first change the color of Detractor Color to blue, Neutral Color to black, and Promoter Color to yellow. After selecting all the colors click on Apply button to save changes.

How to Present Likert Scale Data

Our visualization should look like this.

How to Present Likert Scale Data

Don’t forget to save chart with applied properties, Click on “Save Button” for saving the chart settings.

How to Present Likert Scale Data

Here is our final visualization with changed properties.

How to Present Likert Scale Data

How does Add chart to sheet and Export works?

If click on “Add chart to sheet button” this visualization will appear on your google sheet main page where your data was available.

How to Present Likert Scale Data

The other button is “Export”, If you click on Export button it will ask you either you want visualization in jpg or png format.

How to Present Likert Scale Data

Once you choose any option it will automatically download on your computer.

How to change Width and Height of chart?

You can change Width of chart sliding highlighted dot.

How to Present Likert Scale Data

 

If you slide highlighted dots of width or height to right will increase width or height of chart. The maximum width goes up to 1200px and minimum width goes up to 100. The maximum height goes up to 750px and minimum height goes up to 333.

How to Present Likert Scale Data

How does “Reset all” button work?

If you click on Reset all button all setting wipe out and visualization will go to 5-Scale Likert Scale Chart with default properties settings.

How to Present Likert Scale Data

A new window will appear click on Yes.

How to Present Likert Scale Data

Note: After Reset all, your chart will default go to 5 Scale Likert Scale Chart with default properties settings. You should use this feature carefully.

How to Present Likert Scale Data

How to change color each section of bar?

Click on Edit Chart.

How to Present Likert Scale Data

Click on pencil icon on the left on Overall bars.

How to Present Likert Scale Data

Go to Bars Color.

How to Present Likert Scale Data

When you explore it you will find color property for each Rating.

How to Present Likert Scale Data

After changing colors click on Apply All. You will find a quick change in the aesthetics of your charts.

How to Present Likert Scale Data

Click on “Save button” so that all changes you have made should be preserved accordingly.

You can use Likert Scale Chart anywhere after saving it. You can create your own Likert Scale Chart for your data as well.

If you still have any question you can contact us at support@chartexpo.com at any time for better assistance.

How much did you enjoy this article?

We will help your ad reach the right person, at the right time

PPC Signal

Your Data. Your Insights.

Actionable insights discovered for you. Now you can do more in less time.

PPCexpo Keyword Planner

Find the Perfect Keyword. Surprise Yourself.

PPCexpo Keyword Planner will help you align your keywords with the customers’ intent.

PPC Audit

Free Google Ads Audit Report.

Frequent audits will help you optimize your PPC campaign for success.

ChartExpo PPC Charts

Picture a Thousand Numbers. See the Big Picture.

Visualizations give you the ability to instantly grasp the insights hidden in your numbers.

PPCexpo PPC Reports

Simple and Easy PPC Reporting. For Everyone.

Experience the new revolution in reporting … click your way to insights, don’t scroll.

Combinations Calculator

Do the Math.

Calculate the number of combinations in your PPC campaign. It may surprise you.

Insightful pay-per-click tips and tricks, delivered to your inbox weekly.

CTR Survey

ppc signal ad
chartexpo ad
ppc audit ad
keyword planner ad
119650

Related articles

next previous
Data Visualization7 min read

How to Visualize Data Using Pandemic Comparison Chart?

Click to learn how to get started with a pandemic comparison chart also to know about what is the trend of Covid-19 based on a graph?

Data Visualization7 min read

How to Create a Stacked Area Chart in Excel?

Click to learn how to plot a Stacked Area Chart in Excel. You’ll also learn how to read a Stacked Area Chart.

Data Visualization10 min read

Top 5 Google Sheets Charts for Your Data Stories

Click to learn the top 5 Google Sheets Charts for your data stories. Also, we’ll address the following question: what are Google Sheets Charts.

Data Visualization12 min read

Business Intelligence vs. Data Analytics: What's the Difference?

Click to learn about business intelligence vs. data analytics differences. We’ll also address the following question: what is business intelligence?

Data Visualization11 min read

Top 5 Types of Business Charts You Must Try

Click to discover the top 5 types of business charts you must try to present your data well.

PPCexpo

  • Home
  • Tools
  • Pricing
  • Contact us
  • PPC Guide
  • Blog
  • Sitemap
  • © 2022 PPCexpo, all rights reserved.

Company

  • Contact us
  • Privacy policy
  • Security
  • Patent

Tools

  • PPC Signal
  • PPCexpo Keyword Planner
  • PPC Audit
  • ChartExpo™ PPC Charts
  • PPCexpo PPC Reports
  • Combinations Calculator

Quick Links

  • PPC Guide
  • PPC Signal Dashboard
  • PPC Reports Templates
  • ChartExpo™ for Google Sheets
  • ChartExpo™ for Microsoft Excel
  • PPCexpo Keyword Planner Google Chrome Extension

Charts

  • CSAT Score Survey Chart
  • Likert Scale Chart
  • Pareto Chart
  • Sankey Diagram

Category

  • PPC
  • SEM
  • SEO
  • SMM
  • Data Visualization
  • Others
Join our group

Benefits

  • Q&A on PPC advertising
  • Get expert advice
  • Great PPC discussions
  • Stay updated with PPC news
  • Quick support on tools
  • Discounts and special offers