Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

Likert Scale Excel Template

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi Everyone

I'm about to start my educational action research project and I would really appreciate some advice! My research questionnaires have eight Likert scaled questions. Is there an Excel template available that will allow me to enter the sum for each of the Questions, which in turn will produce a bar chart?

My Likert Scale is: Disagree / Somewhat Disagree / Neutral / Somewhat Agree / Agree

Your advice and guidance would be really appreciated as I am very new to this.


View Answers     

Similar Excel Tutorials

Scale Data for Printing in Excel - Fit more onto a Printed Page
This tip shows you how to fit more Excel data onto a page for printing. This does not change the size, shape, or lo ...
Changing Any Element in a Chart in Excel
In this tutorial I am going to go through the Layout tab in more detail and show you how to build up chart layouts ...

Helpful Excel Macros

Create a Bar Chart With a Macro in Excel
- Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data
Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Create a Column Chart with a Macro in Excel
- This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the

Similar Topics

I have data from a questionnaire that incorporated a Likert scale which I would like to chart but am having difficulties incorporating everything I want in one chart, i.e. i would like the number of responses indicated along with these response figures as a percentage that ive already calculated using formula in excel under the likert scale of strongly disagree, disagree, undecided, agree and strongly agree which would all be indicated in different coloured bars. How can i get all the three pieces of data i have on my spreadsheet into a graph. I can either get the responses and likert scale as the legend or the percentages corresponding to the likert scale as the legend.

Also what graph would be best to display my data.

Furthermore i would it be possible to separate this data once all displayed in a graph according to the respondents age to the number of responses for each scale along with the percentage.

I would appreciate any help.


I have attached my raw data so i hope someone can help me with a solution.

I'm analyzing the results of a survey with Likert's scale.
that if i'm analyzing 12 questionnaires. and the scale is strongly disagree 1, disagree 2, neither agree nor disagree 3, agree 4, strongly agree 5.
and the results for question 1 is
1 2
2 3
3 2
4 4
5 5
6 1
7 3
8 4
9 4
10 5
11 2
12 1

and i want a bar chart/pie chart which shows 5 bars/ 5 pie slices of strongly disagree to strongly agree. showing the stats of these above results.
please help.
i have ms excel and spss, i have option to use any one of them.

Hello everyone,

I have a problem that I couldnt figure out.

For example, the values (5- Likert scale) I have in the first column:

strongly agree
strongly disagree

And each value has a rep. number.

strongly agree=1
strongly disagree=5

What I want to do is, for example

if the first cell is "agree", in the next colum it should be seen as "2";

in the second cell, if the value is "strongly disagree", it should be "5".

Is there a formula to do this? I really appreciate any help.


Hi all,

I am analysing the responses from a questionnaire that I sent out to two different groups ie contractors and developers to find out their opinions on the research subject matter. It was based on the likert scale. I used the t-test to compare whether they is much of a difference in their responses. The responses to the questionnaire were as follows: Strongly Agree Agree Neither Agree nor Disagree Disagree Strongly Disagree I have given the following numbers to each response
Stongly Agree = 5 Agree = 4 Neither Agree nor Disagree = 3 Disagree =2 Strongly Disagree =1 The responses from the following 11 questionnaires from the following two groups are as follows


I worked out the mean of this group to be 3.81 and the standard deviation to be 1.19.


I worked out the mean to be 3.72 and the standard deviation to be 0.61 for this group.

I tried to use the t-test and came up with an answer of 0.22. I am not sure if this is right however.

I do not know if I used the t-test properly or how to explain whether the answer is significant or not. In addition I am not sure that I used the correct test.. should I have used the chi-square test?

Would someone please please explain this to me.

Hoping that someone can help,


Can someone help me by giving step by step instructions on how to do 5 points Likert scale on excel? and if possible, how to merge results to come out as 3 points scale-agree,disagree,no view- if i felt the need to?


I'm new to the forum - though I have browsed and found the resources helpful for a long time. Thank you to all who contribute here.

I have an issue with some data that I can't see covered elsewhere. I have conducted a study on whether 3 different groups of students found our mobile website useful towards learning. The survey covers a range of areas, from content of the site, to whether mobile learning has improved their ability to study.

In total I have 16 Likert type questions - all with a scale of Strongly Disagree, Disagree, Neutral, Agree and Strongly Agree.

Immediately, I can observe from the whole sample (all 3 groups - n=601) that the results will be skewed to the right (Agree/Strongly Agree) for nearly all 16 Likert questions.

I'm unsure what type of tests I can use to illustrate whether there was a significant difference between the 3 groups of participants (biology/geography/maths students). Kruskal-Wallis seems like an option, but I don't know how to apply this to Likert type data using Excel.

Of the 601 sample, the group sizes are not equal. 281 are biology students, 267 are geography students and 53 are maths students. Does this affect what test I can use?

I have already created charts for each question, comparing the 3 groups % response to the question.

However, I'd like to take this further, and not quite sure how. I'd like to treat my data as ordinal rather than assuming it is interval.

From the extensive reading I have done, this would have been easier with only 2 groups of students, but I have what I have.

Any ideas would be greatly appreciated!

Dear All,

I am new to this and hope you can help me out.

I have an excel document which has multiple columns. One of the columns have the value(words) agree, disagree and neutral.

My question is what can I do that these words automatically referers to a number for eg: agree=1, disagree=2, neutral=3 and so on.

Thank You so much for your help.

Hi all

I am new to this site and what a great forum. I found the following link very useful to create a chart from the likert scales.

But, I would like to change the legend as per the graph from Strongly disagree to strongly agree in that order. I tried just moving them around in the data table, but it seems to move the whole graph and so, the original graph gets distorted. Any ideas how this might be done or is it not possible. Thanks.



My knowloedge using Excel is pretty basic and I would like any advice on how to accomplish the following task:

- An excel file contains two sheets.
- On sheet one, we have an option to select (from a list box) an answer out of five choices:

Strongly agree
Neither agree or disagree
Strongly disagree

Once an answer is selected I would like to populate cells in sheet 2 with the number equivalent:

1 - Strongly agree
2 - Agree
3 - Neither agree or disagree
4 - Disagree
5 - Strongly disagree

I think a lookup table could possible do this??


First I would like to say thank you for the great help I received from this forum, especially from Andy Pope. I dont know why my thread from July 7 is not here any more, but anyway - the answer I received was of great help.

The last time I had problems with presenting the results of a Likert-Scale in a graph, showing values for such things as Very important, Important, Neutral etc. Now I know how to "cut" the "neutral" by half - but if I want to show the results of two different likert-scales side-by-side in a graph (please see the attached sheet), I get a different picture.

Could anyone help me with this problem?

Hi all.

My survey has 15 questionnaires and 50 respondents. The questions are all multiple choice and some contained open ended answers.

For example:
***Q1 Q2 Q3 Q4 Q5 Q6
***Yes -Yes - No - Agree - Neutral - No
***No - Yes - Yes - Disagree - Neutral - Yes
***No - Yes - No - Agree - Disagree - Yes

Is there any way to count if:

The total number of people in who either answer 'yes' or 'no' in Q1, also answer either 'agree' or 'disagree' in Q2' and so on.

I have tried countifs function, like =countifs("B2:B51,"Yes","C2:C51,"No",D2:D51,"F2:F51,"Agree",G2:G51,"Yes") and so on....

but it is time consuming. There are so many options because the respondents answers are varies.

Any suggestions?

(p.s. sorry about my level of English)

for example, i have a column
strongly agree
strongly disagree
strongly agree

i need a present in a chart, how many "strongly agree", how many
"disagree", etc, based on how many occurance of them in the column, and
use the "strongly agree", "Disagree" the label.

what is the most suitable chart type, and how to set the labels?
and most important, how to get the counts?

as i am not very experienced in Excel, hope someone can save me!

I was wondering if someone could help to figure out how to consolidate different worksheets to analyze likert scale surveys using pivot tables

Thank you,



I am working on a survey where I have 5 results and 4 respondents. I am trying to simplify creating a formula for each of the sets of data. Here is the formula under each response.

2 is for the respondent and 3 is for the question number, 1 is for Strongly Agree, 2 - agree, to 5 where it is strongly disagree.

Here is the layout.
Strongly Agree Agree Neutral Disagree Strongly Disagree Traditionalist 0 1 0 0 0 Baby Boomer 2 0 2 0 0 Gen X 1 1 0 0 0 Gen Y 1 0 0 0 1 Strongly Agree Agree Neutral Disagree Strongly Disagree Traditionalist 0 1 0 0 0 Baby Boomer 1 1 2 0 0 Gen X 2 0 0 0 0 Gen Y 0 0 0 0 2

Now, the part I need to change all the time is the 2 for the respondent to change from traditionalist to baby boomer, etc. then the #3 to the next question #4 and the 1 across from strongly agree to Disagree.

Any way to simplify. Or do I need to do the teadious way.

Hello. I apologize if this has been answered before, but I cannot find it on the forum. I have a data set similar to the following (though much bigger), and I cannot get the data to display in a useful form. It was a survey.

Quest 1 Quest 2 Quest 3
Cust 1 Agree Disagree Agree
Cust 2 Neutral Agree Agree
Cust 3 Agree Neutral Neutral
Cust 4 Agree Agree Neutral

I'd like to end up with a pivot table such as:

Agree Neutral Disagree
Quest 1 3 1 0
Quest 2 2 1 1
Quest 3 2 2 0

When I change the fields, the Agrees, Neutrals, and Disagrees nest inside each other and things get very confusing. Do I need to rearrange my data (which could take hours) or is there a way to "count" the answers without creating an individual pivot table for each question (which is what I'm currently doing.)


i have collected feedback regarding the usage of timesheet as a part of my MBA project.
the feedback is in MS EXCEL.
I would like to do some data analysis and put the data in form of charts.
pie charts are too elementary.
my professor insists in statistical tools which i dnt have.
the questions are given and the employees were asked to give the opinion on based of 5 point scale.
Strongly Disagree 1
Disagree 2
Undecided 3
Agree 4
Strongly Agree 5
what can i do in excel? I have no clue about it...
pls help me out...

Dear All,

I am new to this and hope you can help me out.

I have an excel document which has multiple columns. One of the columns have the value(words) agree, disagree and neutral.

My question is what can I do that these words automatically referers to a number for eg: agree=1, disagree=2, neutral=3 and so on.

Thank You so much for your help.



I was hoping someone could shed some light on my following problem i'm having in excell 2003.

I'm trying to have a horizontal bar chart with 6 text descriptions on the y axis and a 5-point scale on the x axis (strongly disagree to strongly agree).

My data for the description are just 1 to 5 (corresponding with the 5-point scale). what I wanted was to display the mean score for each descriptor on the y axis, but when I do this I cant change the x axis to the 5-point scale.

I tried using custom text on the x axis (e.g [=1]"strongly disagree"; [=2] etc...,) but it wont go further than 2 customer text labels for some reason.

If anyone would be able to lend some advice on how i can do this it would be appriciated.



Hello everyone!

I'm after some help please.

I have 500 product evaluation forms each of which contain people's answers to 14 questions about a new product they have just trialled. I need to find the quickest way to get this data onto excel so it can do the rest of the work for me. I've got all my charts etc set up but the obvious missing link is the info. I'll give you an example of how the form is set up:

Was the device comfotable to use?

The user then ticks one of 5 boxes

Strongly Disagree, Mostly Disagree, Neutral, Mostly Agree, Mostly Disagree

In an ideal world, I would like to have a user form on screen in which i can run through and enter the data using option buttons. This bit I can do no problem. The problem I have is what code I use to collate the data from the form onto 1 worksheet that keeps a score of (for example) total number of answers to this question that scored a 'strongly agree' etc etc etc.

What I would like to end up with is a worksheet has the 14 questions listed down the left, then across the top the 5 possible answers with a final column that totals the number of recipients....obviously the hope is that if this works, that final column reads '500' for all 14 questions.

If there is anyone out there who can help me, I can't tell you how gratefull I'd be!

Any questions, just let me know!



I'm getting a compile error when i try to assign a macro to a button to begin a survey. attached is my sample. I still have work to do but i was trying to get the basic function working. any advise? Thanks!

(im not good with vba and i was following these instructions:

HTML Code:


I have a large amount of data to put into a pivot table that relates to questionnaire responses. The responses are agree, agree strongly, neither agree nor disagree, disagree and disagree strongly. The columns relate to individuals to whom the responses refer. Putting one question and its answers into a table is no problem. I end up with the count of the answers at individual level, e.g. 3 agree strongly, etc. I run into problems when I try to create a table with multiple answers they end up next to each other rather than underneath each other, the result is that the table becomes wider and wider (there are 21 questions).

Is there a way of doing this?

I want to turn this:
Agree strongly Agree slightly Neither agree nor disagree Disagree slightly Disagree stongly Staff are helpful and courteous 64 17 2 0 1

into this:
Agree strongly Agree slightly Neither agree nor disagree Disagree slightly Disagree stongly Staff are helpful and courteous 76.19% 20.23% 2.38% 0.00% 1.19%

What would be the formula?



I have a bunch of qualitative data to analyse across different geographical regions and most questions asked require an either agree, strongly agree, disagree, strongly disagree and undecided answers. Can someone please advise how best to count each of the responses for each region and each question...I am doing it manually by filtering each response and this is taking forever. Any help much appreciated. Thanks, Ivana

Hi there,

I need to analyse a survey with 10 different questions. The users answered by clicking: Agree, Disagree, neither nor etc... Furthermore their working location (5 different) is part of the survey. The raw data is as the following: Coloumns -> different Questions with scores (agree, disagree etc) above, Rows -> Location of every user.

I wanted to create a pivot with the different questions in the rows and the scores (filtered by the location) as percentages above. Hopefully you can help me.


Hi please can someone help me?

Please view the attachment example. I am doing some Survey Analysis and have had to convert the text answers to those surveys questions into numbers.

1= Agree
2= Tend to agree
3= Neutral
4= Tend to disagree
5= Disagree

I now want to do an average of columns D to L in row 847 but as I used an IF formula to convert the text to numbers is won't let me average the cells as there is a formula in it.

I also want to do a ranking in row 849 based on the average in row 847. The lower the average the higher the ranking. This way I can analyse where we need to implement an improvement process.

Can anyone help me please?