Voting Chart

[Slim]

I have copied the voting information from Outlook and I
want to graph the responses in Excel. I know it can be
done with a pivot chart, but that is beyond my users
abilities. The data looks like this
A B
Bob Yes
John No
Bill Yes
Moe Maybe

Is there a quick and easy way to graph this in a pie?

Thanks!

 

[Brenda]

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 C13, click on Chart, and create
your pie chart from there.

Brenda

 

[Guest]

Thanks Brenda!

-----Original Message-----
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 C13, click on Chart, and create
your pie chart from there.

Brenda

.

 

[Tushar Mehta]

I'm sure Brenda meant her example to be =COUNTIF(B:B,"Yes")

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions