Do you mean you want to a pie chart with count of No's and count of Yes's
If yes/No in A1:A100
Count of Yes: =COUNTIF(A1:A100,"yes")
Count of No: =COUNTIF(A1:A100,"no")
Put these in tow cells (B1:B2)
Select B1:B2 and use Chart Wizard to make pie chart.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Geraint" wrote in message
...
I have a column on the worksheet that has yes or no as the data entered in
each cell. How can I create a pie chart of both answers? It must be very
easy
but I'm stuck!