Forum Discussion
Google Form Visualization
Anonymous It might be nice to keep one table that has one row per respondent? See if this webinar on survey data gives you any inspiration: https://www.excelwithallison.com/MCT/news#h.p_NkgcNxVFFYaS
I didn't get too complex in this one, but I do often do what you have done by creating a column for 'question' and column for 'response'. I just think you're missing the Dim and Fact table concept to be able to create exactly the chart you want. https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power.html
Community ChampionAnonymous It might be nice to keep one table that has one row per respondent? See if this webinar on survey data gives you any inspiration: https://www.excelwithallison.com/MCT/news#h.p_NkgcNxVFFYaS
I didn't get too complex in this one, but I do often do what you have done by creating a column for 'question' and column for 'response'. I just think you're missing the Dim and Fact table concept to be able to create exactly the chart you want. https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power.html
Thank you for the response!!