Email:      Pass:    Pass?

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.


Similar Excel Video Tutorials

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?

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.


Hello all,

I found this site using google and hoping that someone here can help me.

I am analysing 24 answers to questions (across 20 worksheets), where people rated each question from "strongly disagree, disagree, agree, strongly agree" in that sort order. Its a massive sorting task (480 sorts to do) and wondered if I could automate the function using a macro.

its set out like this for each question

The person is friendly and respectful
Strongly agree 4 10%
Disagree 3 8%
Strongly Disagree 10 25%
Agree 20 50%

The data is in columns A,B,C and I want to sort according to strongly disagree, disagree, agree, strongly agree. I know how to do this manually, but I have to sort 480 questions like these.

Can anyone help?

After doing this I have to produce a bar chart for each question, so basically 480 bar charts. So hoping similar help.

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?


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??


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 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?

Apologies, I'm sure this is easily answered.
I have a list of values that need converting to a numeric value -

Strongly Agree (SA),
Agree (A),
Slightly Agree (SLA),
Slightly Disagree (SLD),
Disagree (D),
Strongly Disagree (SD)


Can anyone advise how to do this?

Many Thanks

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

I am looking for a source of Excel code that produces the type of stacked
bar chart at

The data is based on a 6-point Likert scale and I want to stack the bars to
the left and right of the centre of the scale.


i am new to excel with basic skills.
i have one task to do in excel
i have to create a question paper(QP) for 60 students? my goal is to create a QP which is unique to every student (means questions should be in jumbled order such that no two students get same order of questions).
the format is look like this with 10 questions in each section.
help will be appreciated.
looking for your suggestions

format is like this:-

Management Organisation & Behaviour

First Internal Assessment- Nov-2009


Roll no./ Section:

II.Choose the Correct Option 1X5=5


[ ]
( a )
( b )
( c )

( d )


[ ]
( a )
( b )
( c )

( d )


[ ]
( a )
( b )
( c )

( d )


[ ]
( a )
( b )
( c )

( d )


[ ]
( a )
( b )
( c )

( d )

II.Fill in the Blanks: 1X5=5

1 A ____________________ is a framework or blueprint for conducting marketing research. 2 A scale in which the numbers are used to rate objects is _________________________
3 A _____________________ is the representation of the elements of the target population.
4 ________________________________ is a two step process in which the population is partitioned into 5 _______________________ means assigning numbers or other symbols to characteristics of objects

III.Write in the space provided (not more than two lines) 1X5=5

1 Likert's Scale:

2 Secondary Data:

3 McNemar's Test:

4 Markovian Chains:

5 Survey:

Hi all,

I'm stuck with one.

I need to find a formula/s that will assist with the following in Excel 2003.

Column A: Question No
Column B: Question
Column C: Region
Column D: Answer

1 I am very satisfied with my job. Eastern Cape Agree
3 The staff feel important. Northern Cape Agree
5 Staff are encouraged to develop. Gauteng Disagree
8 Staff are paid fairly for the work. Western Cape Strongly Disagree
7 Management make a real effort. KZN Agree
1 I am very satisfied with my job. Eastern Cape Agree

I need to find out how many staff in Eastern Cape answered Q1 with Agree, Disagree, etc, and so forth without using a Pivot.

See attached

Please help.