Forum Discussion

MarinJ1200's avatar
MarinJ1200
Copper Contributor
Sep 12, 2022

Likert scale order of statements

I have created forms with Likert scale that has 19 statements. Each time I open the form the statements are in random order. I have numbered the statements and need these to be the order I set but it is not the case. First I thought this happens when I make a copy of the form but today I realized that the order had shuffled even without me editing the form. 

 

microsoft forms

5 Replies

  • Lauren1's avatar
    Lauren1
    Copper Contributor
    Mar 18, 2025

    I am having the opposite problem- I want the Likert options to shuffle but I can't find a way to shuffle them. Is there a way to make them shuffle within the Likert question (I don't want to use sections). Thank you!

  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    Jun 14, 2024

    Hi MarinJ1200 

     

    The Likert Scale Chart is considered the most suitable visualization for the given data format. The platform described below supports three distinct data formats, enabling the creation of a Likert Scale Chart in just a few steps. Additionally, it offers a rich set of customization properties, enhancing the flexibility and utility of the chart.

     

    I regularly create these charts with the following tool. Hope you will like it.

     

    You can check here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr.

     

    And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr.

     

    Thanks

     

    Likert Scale Chart for survey data

     

     

    Few more charts

     

     

     

     

    • Rob_Elliott's avatar
      Rob_Elliott
      Silver Contributor
      Jun 14, 2024

      Qaiser_j your answer doesn't make any reference to the Microsoft Forms likert question type so doesn't answer the OP's question.

       

      Rob
      Los Gallardos
      Microsoft Power Automate Community Super User.
      Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

  • Simon390's avatar
    Simon390
    Copper Contributor
    Jun 13, 2023

    MarinJ1200 It's bad practice to keep rating questions in any order because order can impact responses. Instead, by randomising them you ensure any impact is distributed equally across all statements.

     

    Looking at the questions in the screenshot, there don't appear to be any that require them to be answered in any specific order, but if they do, then add as separate Likert question blocks in the form. Sometimes you may want to group similar questions together so that the respondent can see the scope of questions on this topic at once. A good example is in customer satisfaction questions where you want to probe on several dimensions of staff performance:

    1) helpfulness of staff

    2) availability of staff

    3) knowledge of staff

    However, you would still want these questions randomised to avoid any order bias creeping in. Look up 'order effects bias' if you want more info.

Resources