Forum Discussion

jfune1's avatar
jfune1
Copper Contributor
Jun 11, 2024

Likert question on excel

I made a survey for school using forms. I like the graphs provided after the surveys are done and I'm trying to use those graphs in excel, to be exact the likert graph but I cant seem to find out how to do it on excel. When ever I try to do the stacked bar graph it doesn't add up how it has it on forms. The title of the question is the only variable that comes on on everything like my x-axis, y-axis and key variables. Any way I can copy and paste the graphs already provided in forms onto excel? Or does anyone know the trick to use that specific formula in excel to do it?

excel
Feedback
Forms
Survey
  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    Jun 14, 2024

    Hi jfune1 

     

    I attached sample charts created on survey data. Data refresh in the chart automatically as you change your data selection.

     

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

     

    You can check here for Microsoft Excel & Office 365.

     

    And if you are comfortable with Google Sheets, you can find it here.

     

    Thanks

     

    Likert Scale Chart for survey data

     

     

    Few more survey charts.

     

     

     

     

Resources