Excel Templates | Excel Spreadsheets | Yes No Chart



Yes No Chart

Posted on July 17, 2011
Filed Under Report | 1 Comment


Yes No Chart 300x133 Yes No Chart

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.

xlsx Yes No Chart  Yes No Chart V1.0 - Excel 2007/2010 (26.5 KiB, 4,008 hits)

xls Yes No Chart  Yes No Chart V1.0 - Excel 97-2003 (52.5 KiB, 1,593 hits)



Comments

One Response to “Yes No Chart”

  1. Kirk Williams on August 10th, 2011 5:04 pm

    Nicely done, clear concise, and efficient.

Leave a Reply