I distributed a survey online and received the answers in an Excel spreadsheet. I would like to make a pie chart out of some of the closed option answers. For example, one of the questions was gender. Is there a way I can create a pie chart that shows the percentage of male vs. female?
Given 30 male and 20 female responses, the pie chart would be cut 60/40, with each part appropriately labeled.
male male female male female female male male male female
I would like that to create a pie chart cut 60/40.