Hello,
I'm hoping this is a relatively simple issue, and I just haven't been able to figure out the right description to find any useful solutions online.
I have a spreadsheet of responses to a short survey, which includes data like the age of the respondent and their hometown. I'd like to create a pie chart that shows the distribution of ages and hometowns, among other data (there are only about 8 unique values; it's a small survey sample).
However, I can't figure out where to begin. Do I have to manually create countif functions for each unique value, as I did for gender and answers to a 'yes/no' question, or is there a more automated process for charting these values?
Thanks,
Doc