You need to coun the number of "no", "yes", and "maybe"

Like this in D1,
=countif(B:B="Yes")
and so on in D2 for "No" and in D3 for "Maybe"

Then in C1 type "Yes", C2 type "No", and C3 type "Maybe"

So it will look like this:

A     B     C     D
Bob   Yes   Yes   2
John  No    No    1
Bill  Yes   Maybe 1
Moe   Maybe

Of course, as you add more names and responses, the
calculation will continue to add to the COUNTIF
calculation.

Then you can highlight C1:D3, click on Chart, and create
your pie chart from there.

Brenda