Creating a table from non-decimal data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top