Creating Likert Scale graph

%3CLINGO-SUB%20id%3D%22lingo-sub-365017%22%20slang%3D%22en-US%22%3ECreating%20Likert%20Scale%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365017%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20to%20create%20a%20SINGLE%20BAR%20Likert%20scale%20chart%20with%20a%20range%20from%201%20to%206%20(low%20scores%20in%20the%20color%20gray%20progressing%20to%20black%20for%20high%20scores)%20and%20then%20plot%20four%20groups'%20average%20scores%20along%20that%20scale%20(i.e.%2C%20so%20Excel%20will%20place%20a%20tickmark%20and%20the%20group's%20score%20on%20the%20correct%20place%20on%20the%20scale%20-%20e.g.%2C%202.84%20for%20group%201%20will%20fall%20somewhere%20between%202%20and%203%20on%20the%20Likert%20bar%20chart).%20I%20am%20imagining%20a%20one%20bar%20horizontal%20chart%20with%20graduated%20colors%20from%20gray%20to%20black%20and%20individual%20scores%20plotted%20along%20it.%20I%20need%20Excel%20to%20recognize%20the%20scale%20range%20and%20the%20placement%20of%20the%20groups'%20scores%20on%20the%20correct%20place%20on%20the%20one%20bar%20scale.%20Help!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-365017%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2479396%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Likert%20Scale%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2479396%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F299546%22%20target%3D%22_blank%22%3E%40shanbethh%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20are%20doing%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20many%20ways%20and%20tools%20to%20create%20Likert%20chart%20in%20excel%20but%20I%20am%20sharing%20the%20most%20simple%20way%20which%20I%20am%20using%20for%20almost%203%20years.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChartExpo%20for%20Excel%20add-in%2C%20It%20has%20very%20simple%20UX%20which%20makes%20it%20easy%20to%20create%20charts%20plus%20and%20no%20coding%20skills%20required.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChartExpo%20for%20Excel%20add-in%3A%20%3CA%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FMTErTVRDK3hsK1NCK01TT0ZUQ01UKwo%3D%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fchartexpo.com%2FutmAction%2FMTErTVRDK3hsK1NCK01TT0ZUQ01UKwo%3D%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChartExpo%20for%20Google%20Sheets%20Add-on%3A%20%3CA%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FMTErTVRDK2dzK1NCK01TT0ZUQ01UKw%3D%3D%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fchartexpo.com%2FutmAction%2FMTErTVRDK2dzK1NCK01TT0ZUQ01UKw%3D%3D%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESharing%20a%20video%20tutorial%20on%20How%20to%20create%20Likert%20chart%3A%20%3CA%20href%3D%22https%3A%2F%2Fbit.ly%2F3vMMfaZ%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fbit.ly%2F3vMMfaZ%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20sure%20it%20would%20be%20helpful%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need to create a SINGLE BAR Likert scale chart with a range from 1 to 6 (low scores in the color gray progressing to black for high scores) and then plot four groups' average scores along that scale (i.e., so Excel will place a tickmark and the group's score on the correct place on the scale - e.g., 2.84 for group 1 will fall somewhere between 2 and 3 on the Likert bar chart). I am imagining a one bar horizontal chart with graduated colors from gray to black and individual scores plotted along it. I need Excel to recognize the scale range and the placement of the groups' scores on the correct place on the one bar scale. Help!

1 Reply

Hello @shanbethh,

 

I hope you are doing well.

 

There are many ways and tools to create Likert chart in excel but I am sharing the most simple way which I am using for almost 3 years.

 

ChartExpo for Excel add-in, It has very simple UX which makes it easy to create charts plus and no coding skills required.

 

ChartExpo for Excel add-in: https://chartexpo.com/utmAction/MTErTVRDK3hsK1NCK01TT0ZUQ01UKwo=

 

ChartExpo for Google Sheets Add-on: https://chartexpo.com/utmAction/MTErTVRDK2dzK1NCK01TT0ZUQ01UKw==

 

Sharing a video tutorial on How to create Likert chart: https://bit.ly/3vMMfaZ

 

I am sure it would be helpful for you.

 

Regards.