Forum Discussion

ngiam's avatar
ngiam
Icon for Helper I rankHelper I
5 years ago
Solved

Visualizing Multiple Choice Data

Hi there,   How do I visualize the following multiple choice data: Respondent Name What are the ages of your children? (Tick all that applies)           <2 2-5 6-12 13-18 above 18 ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    I would suggest that you open the data in Power Query, then select the choices for the question and Unpivot data. I've recently done a webinar on handling survey data. See if it might help you with some best practice tips for yours. 

     

    Just click the 'Watch Now!' button under the Survey Says heading: https://www.excelwithallison.com/MCT/news#h.p_NkgcNxVFFYaS

     

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

I would suggest that you open the data in Power Query, then select the choices for the question and Unpivot data. I've recently done a webinar on handling survey data. See if it might help you with some best practice tips for yours. 

 

Just click the 'Watch Now!' button under the Survey Says heading: https://www.excelwithallison.com/MCT/news#h.p_NkgcNxVFFYaS