Creating Likert Scale graph

[shanbethh]

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!

[#2]

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.

[#3]

@Shozab Are you affiliated with this company? It seems you are pushing that product into many old threads recently.