| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I create a survey using excel?
I have a checklist of questions for a chair. All questions have a yes or no
answer. I would like to record this information in Excel as a chart/graph. How do I do this? I'm using Excel 2003 version. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I create a survey using excel?
Hi,
Do you want something as simple as a bar chart displaying the total number of "yes" and "no"? Assuming your responsex are in B1:B20, use =COUNTIF(B1:B20,"Yes") and =COUNTIF(B1:B20, "No") to give you each total. Plot these as a bar chart. Dave url:http://www.ureader.com/msg/10356312.aspx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a simple Sales survey with radio buttons ? | Excel Discussion (Misc queries) | |||
| How do I create survey results into an Excel spreadsheet? | Setting up and Configuration of Excel | |||
| Can one set up a survey form on excel? | New Users to Excel | |||
| How do i create option Boxes for a survey on excel?? | Excel Discussion (Misc queries) | |||
Linear Mode
