Forum Discussion

Stazz2385's avatar
Stazz2385
Copper Contributor
Mar 09, 2022

Help with graphs

Hello i have this particualr problem to solve.

I am not that good at excel but keen to improve.

 

I have to make a graph out of an answer from a survey; one of the questions can be answered through 5 posible answers, only one can be chosen.

I wanted to know how i can make a graph out of it ? Like a graph that shows that quantity of the answers chosen.

 

Thank you in advance 

Formulas and Functions
Macros and VBA
  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    May 26, 2022

    Hi Stazz2385 

    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

     

    Another chart for survey data

     

    Another chart for survey data.

     

    One more chart for survey data

     

     

     

     

     

     

Resources