Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
for a High School science project my daughter created a survey with 39
possible responses (3 groups of 13 responses in each group) the people taking the survey are supposed to pick the top 4 responses in each group (numbered 1-4, 1 being the highest). Other information is Age, grade and gender of the person taking the survey. What would be the best way to create the table and eventually charts to diplay the results of the survey? I was thinking of a flat table with a number in the cells correspondig to their answers but I have no idea how to create the charts or compare the answers with others to find patterns. So far she has 400 surveys to compare. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Columns for Pivot Table | Excel Worksheet Functions | |||
Can you transpose 1 column into multiple rows creating a table | Excel Discussion (Misc queries) | |||
Multiple columns in a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |