Excel won't properly generate the graph

%3CLINGO-SUB%20id%3D%22lingo-sub-2392994%22%20slang%3D%22en-US%22%3EExcel%20won't%20properly%20generate%20the%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2392994%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20get%20excel%20to%20generate%20graph%20of%20how%20people%20responded%20to%20a%20survey-%20pie%20chart%20by%20percentage.%20The%20graph%20isn't%20generating-%20just%20listing%20the%20responses%20in%20order.%20I%20have%20attached%20a%20picture%20as%20well%20as%20the%20spreadsheet.%20Any%20help%20would%20be%20greatly%20appreciated.%20Thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAundrae%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2392994%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2393170%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20won't%20properly%20generate%20the%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2393170%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1065024%22%20target%3D%22_blank%22%3E%40draelee20%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20create%20a%20pivot%20table%20and%20pivot%20chart.%20See%20the%20attached%20version%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
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,