How do I create a survey using excel?

[RG]

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.

 

[Dave Curtis]

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