Forum Discussion

shanbethh's avatar
shanbethh
Copper Contributor
Mar 12, 2019

Creating Likert Scale graph

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 Replies

  • Shozab's avatar
    Shozab
    Brass Contributor

    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.

Resources