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?

  • 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 uservoice votes for it.

         

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

  • 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 ChartExpo for Excel.

     

    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 video tutorial.

     

    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?
  • Aamir's avatar
    Aamir
    Copper Contributor

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

Resources