Excel won't properly generate the graph

Occasional Visitor



Trying to get excel to generate graph of how people responded to a survey- pie chart by percentage. The graph isn't generating- just listing the responses in order. I have attached a picture as well as the spreadsheet. Any help would be greatly appreciated. Thanks



1 Reply


I'd create a pivot table and pivot chart. See the attached version,