Charting

[lsreleford]

So I have this spreadsheet that polled people as to what activities they would like to do. How do I make a pie chart about that shows the percentages of those who said "yes" to each individual thing?

[TABLE="width: 1156"]
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col span="2"></colgroup><tbody>[TR]
[TD]LAST NAME[/TD]
[TD]FIRST NAME[/TD]
[TD]GENDER[/TD]
[TD]HELP ON PLANNING COMMITTEE[/TD]
[TD]AGE[/TD]
[TD]ACTIVITIES[/TD]
[TD]PREFERRENCE FOR ACTIVITES[/TD]
[TD]MOVIES[/TD]
[TD]SKATING[/TD]
[TD]BOWLING[/TD]
[TD]CONCERTS/MUSICALS/PLAYS[/TD]
[TD]WOF[/TD]
[TD]OOF[/TD]
[/TR]
[TR]
[TD]Anderson[/TD]
[TD]Brytani[/TD]
[TD]Female[/TD]
[TD]YES[/TD]
[TD]18-24[/TD]
[TD]Monthly[/TD]
[TD]Friday[/TD]
[TD][/TD]
[TD]YES[/TD]
[TD][/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]Barnes[/TD]
[TD]Garry[/TD]
[TD]Male[/TD]
[TD]Yes[/TD]
[TD]18-24[/TD]
[TD]Monthly[/TD]
[TD]Friday, Saturday[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]Caldwell[/TD]
[TD]Tiffany[/TD]
[TD]Female[/TD]
[TD]YES[/TD]
[TD]35-39[/TD]
[TD]Every Other Month[/TD]
[TD]Friday, Saturday[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Carlisle[/TD]
[TD]Wendy[/TD]
[TD]Female[/TD]
[TD]Yes[/TD]
[TD]50-54[/TD]
[TD]Monthly[/TD]
[TD]Saturday[/TD]
[TD]YES[/TD]
[TD][/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Goodloe[/TD]
[TD]Kylin[/TD]
[TD][/TD]
[TD]YES[/TD]
[TD]18-24[/TD]
[TD]Monthly[/TD]
[TD]Friday, Sunday[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD][/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]Jackson[/TD]
[TD]Nancy[/TD]
[TD]Female[/TD]
[TD]Yes[/TD]
[TD]45-49[/TD]
[TD]Monthly[/TD]
[TD]Saturday, Sunday[/TD]
[TD][/TD]
[TD][/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

You will need to great a data series to use for your chart.

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	LAST NAME	FIRST NAME	GENDER	HELP ON PLANNING COMMITTEE	AGE	ACTIVITIES	PREFERRENCE FOR ACTIVITES	MOVIES	SKATING	BOWLING	CONCERTS/MUSICALS/PLAYS	WOF	OOF
2	Anderson	Brytani	Female	YES	18-24	Monthly	Friday		YES		YES	YES	YES
3	Barnes	Garry	Male	Yes	18-24	Monthly	Friday, Saturday	YES	YES	YES	YES	YES	YES
4	Caldwell	Tiffany	Female	YES	35-39	Every Other Month	Friday, Saturday	YES	YES	YES	YES
5	Carlisle	Wendy	Female	Yes	50-54	Monthly	Saturday	YES		YES	YES
6	Goodloe	Kylin		YES	18-24	Monthly	Friday, Sunday	YES	YES		YES	YES	YES
7	Jackson	Nancy	Female	Yes	45-49	Monthly	Saturday, Sunday			YES	YES
8
9
10
11								MOVIES	SKATING	BOWLING	CONCERTS/MUSICALS/PLAYS
12								4	4	4	6
Sheet4

Cell Formulas
Range	Formula
H12	=COUNTIF(H2:H7,"yes")
I12	=COUNTIF(I2:I7,"yes")
J12	=COUNTIF(J2:J7,"yes")
K12	=COUNTIF(K2:K7,"yes")

You can then select the data and insert a pie chart. If you want you can then add the data labels to so the present for each slice.