how to create pie chart in excel from survey

If you check Form view, clicking a record also shows answers to all the questions for that record, including attachments, to the right of the table. The Layer List icon in the upper-right of the map view allows you to show or hide any tables in the feature layer, while the drop-down menu in the upper right of the table view allows you to check whether or not selecting a record will also select related records. If your survey uses repeats, the answers to questions within those repeats will be available in another tab of the table view. The data table lists the answers to all questions using one column for each question. On the Data page of the Survey123 website, you can also use the data table to view all collected records in your survey. You can also change the appearance of individual questions, including hiding the results table and categories with no responses in them, which also carries through to the printout. This allows you to narrow down your display for the Print current view button, which prints only visible questions as they currently appear. Show All and Hide All options are also available. Uncheck any question to remove it from the display of questions on the Analyze page. Print current viewĬlick the Navigation button to open a checklist of questions, sorted by group. You can modify these scores on the Analyze page, including associating a value of 0 to answers that you don't want factored into results.

For example, in a ranking question with five choices, the choice selected first in a response gets a score of 5, the choice after that a 4, and so on.

By default, the first answer in a response is given the highest score, with each answer afterward scored successively less. You can drag the dividers between the classes to set your own class breaks, which sets the method to Manual interval if not already selected.įor ranking questions, there are settings to show and hide specific answers, as well as altering the score allocated to each possible answer. This option is only available in English.įor numeric questions, you can choose one of five classification methods: Equal interval, Natural breaks (Jenks), Quantile, Standard deviation, and Manual interval, with the default method being Equal interval. When using the word cloud view for text questions, there is a setting to exclude stop words such as the and is. Some question types have additional settings to further control the way responses are presented. Column, bar, and pie charts and the map viewĬolumn, bar and pie charts and the map view

How to create pie chart in excel from survey