Excel won't properly generate the graph

Occasional Visitor

Hi, 

 

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

 

Aundrae

1 Reply

@draelee20 

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