Creating a pie chart in Excel

K

Kelly Wagner

Hi,

I have an excel sheet with 1 column.

Fields in this column can have either a "Yes" value or a "No" value.

I would like to make a pie chart where all the "Yes" would be in 1
color and the "No" in another color.

Is this possible with Excel?

Thanks,
Jeremy Pullicino
 
N

Nick Hodge

Kelly

If your column is A, then in B2 enter

=COUNTIF(A:A,"Yes")

and in B3 enter

=COUNTIF(A:A,"No")

and chart that

HTH

Nick Hodge
 
Top