If you are working as a researcher or a marketing analyst, sometimes you have to collect datas which consists of “yes” and “no” answers and use it to analyze people behavior in certain areas.
Since you only provide “yes” and “no” option as people answer, you should provides clear and specific questions in your questionnaire sheets so you can have objective answers. This method is effective to narrow survey results and get conclusion on survey topics quickly without having respondents give their own opinions. After gathering all required datas from respondents, you should summarize and present those datas with informative display to ease people understanding on reading your report.
One way to make it easy to understand is to display it in a chart or plot it in a graph. And this simple yes/no chart template will ease your job. You should fill each respondent datas in corresponding columns. I create 20 rows for questions item and 150 columns for yes/no answer which you can expand if you have more respondents. Once you finished filling all columns, you will see a yes/no graph with a nice tornado style chart to help your customer, your marketing department or your superior make decisions based on it.
Yes No Chart V1.0 - Excel 2007/2010 (26.5 KiB, 4,395 hits)
Yes No Chart V1.0 - Excel 97-2003 (52.5 KiB, 1,710 hits)