Excel won't properly generate the graph

[draelee20]

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

[#2]

@draelee20 

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