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.
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.
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 |
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:
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.
Here are few details you need to know while creating Likert Scale Chart in Google Sheets.
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
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.
Now click on Create New Chart button.
You will find Likert Scale Chart under the category of “Specialized Survey Charts”.
After click on the Likert Scale Chart you will find some attributes which should be filled to draw this chart.
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 you filled these attributes you can click on “Create Chart” button.
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.
Look for Scale Type.
In Scale Type, you can choose Scale.
In our case, we will choose 3 scale option.
After selecting scale of 3. Click on Apply.
Your 3 Scale Chart is ready to present!
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.
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.
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
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.
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.
Click here to go directly to properties section.
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
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.
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.
Click here to go directly to properties section.
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
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.
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.
Click on Edit Chart.
Click on Text.
Here you can add text as per you requirement. You can show header text in 2 lines.
Then comes “Show” button, it can enable and disable to show the header on chart.
You can change font style of header from Font Style. Here you can apply font styles on your header as per your requirement.
Here we will just change the size of font to 20. If you are done with your changes of font style, click on Apply.
Our header is added, you can find it on the top center of the chart.
You can add footer by going to pencil icon in the bottom.
Through this new property window you can add footer.
Here we are just add random footer Likert Scale Chart.
You can also add left label by clicking on highlighted pencil icon.
Here you can add left label as per your requirement.
Again let’s add random left label.
Click on pencil icon on the left on Overall bars.
From “Bar” section you can select minimum, maximum height, gaps b/w bars, and Gap b/w axis.
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.
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.
Next, let’s see “Question” section:
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.
When you click on Stats. You can show or hide Stats with enable disable button . You can also select the background color of Stats.
Now, let’s look into Stats Font Style property. In this we will make Stats italic.
Once done with all changes click on Apply All.
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.
Click on Chart Settings.
Go to Scale Type. You will find property for changing base colors of bars.
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.
After choosing required colors click on Apply.
If you want to individually change the bar colors, click here to that section.
As discussed earlier the colors of axis didn’t it was looking like this. Here we will explain how you change them.
You can change colors of Scale by clicking on pencil icon on the Scale.
Click on Axis Label Font Style.
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.
Our visualization should look like this.
Don’t forget to save chart with applied properties, Click on “Save Button” for saving the chart settings.
Here is our final visualization with changed properties.
If click on “Add chart to sheet button” this visualization will appear on your google sheet main page where your data was available.
The other button is “Export”, If you click on Export button it will ask you either you want visualization in jpg or png format.
Once you choose any option it will automatically download on your computer.
You can change Width of chart sliding highlighted dot.
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.
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.
A new window will appear click on Yes.
Click on Edit Chart.
Click on pencil icon on the left on Overall bars.
Go to Bars Color.
When you explore it you will find color property for each Rating.
After changing colors click on Apply All. You will find a quick change in the aesthetics of your charts.
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.
We will help your ad reach the right person, at the right time
Related articles