How to analyze categories of my forms responses separately

%3CLINGO-SUB%20id%3D%22lingo-sub-215600%22%20slang%3D%22en-US%22%3EHow%20to%20analyze%20categories%20of%20my%20forms%20responses%20separately%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215600%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20collected%20data%20from%26nbsp%3Bnine%20schools%20as%20part%20of%20a%20survey%20on%20teacher%20retention.%20When%20I%20look%20at%20the%20responses%2C%20I%20get%20an%20overall%20average%20with%20pie%20charts.%20I%20would%20like%20to%26nbsp%3Bsee%20the%20pie%20charts%20for%20each%20school%2C%20too%2C%20and%20be%20able%20to%20compare%20them%20to%20the%20overall%20average.%20Any%20advice%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-215600%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eforms%20survey%20excel%20analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218643%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20analyze%20categories%20of%20my%20forms%20responses%20separately%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218643%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Carrie%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20consider%20downloading%20the%20results%20into%20Excel%20and%20then%20adding%20the%20charts%20in%20a%20meaningful%20way%20to%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EForms%20is%20limited%20and%20isn't%20designed%20for%20what%20you%20want%2C%20but%20Excel%20can%20get%20the%20job%20done!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

I have collected data from nine schools as part of a survey on teacher retention. When I look at the responses, I get an overall average with pie charts. I would like to see the pie charts for each school, too, and be able to compare them to the overall average. Any advice? 

1 Reply

Hi Carrie

 

You should consider downloading the results into Excel and then adding the charts in a meaningful way to you.

 

Forms is limited and isn't designed for what you want, but Excel can get the job done!

 

Hope that helps.

 

Cheers

Damien