Forum Discussion

hoyonglee's avatar
hoyonglee
Copper Contributor
Jun 15, 2021

more than 10 options in likert.

Using NPS in survey, I want to use an 11-point options in likert.

 

Is there any possibility of an update?

6 Replies

  • Aamir's avatar
    Aamir
    Copper Contributor

    There is still a limit of 20 statements on Likert questions. This is very disappointing.

  • Shozab's avatar
    Shozab
    Brass Contributor

    Hello hoyonglee

     

    Yes, you can create Likert scale chart with more than 11 points using external add-in, I would recommend you https://chartexpo.com/utmAction/MTErTVRDK3hsK1NCK01TT0ZUQ01UKwo=.

     

    It supports more than 11 points in Likert scale chart.


    You don't need any coding skills.

    It works on both Microsoft Excel and Excel 365.

     

    Sharing https://bit.ly/3vMMfaZ.

     

    I would be happy to know if I could help.

    Thanks.

    • Irina320's avatar
      Irina320
      Copper Contributor
      Hello,
      Is there any possibility to create a Likert scale with 10 options directly in Microsoft Forms, not in Excel 365?
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    If you mean the number of statements in a likert scale question, you can now have up to 20.
    • hoyonglee's avatar
      hoyonglee
      Copper Contributor
      thank you for reply

      i meant Columns (options that can have up to 7)
      • RobElliott's avatar
        RobElliott
        Silver Contributor

        hoyonglee Oh sorry, I misunderstood. As far as I am aware there's no movement on this yet despite the high number of https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggestions/32966779-more-than-7-options-in-likert-scale for it.

         

        Rob
        Los Gallardos
        Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources