Voting Chart

  • Thread starter Thread starter Slim
  • Start date Start date
S

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

Brenda

.
Click to expand...
 
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
 
Back
Top