Analyzing the Results
1) Holding the CTRL key, select the titles Tot1 through Tot3 (A31:C31) and their percent data (A33:C33)
2) Click on the Chart Wizard icon, select Pie, Exploded 3D (second row in the middle), click next
3) On the Data range tab, select Rows in the Series In: box, then click next
4) Click on the Titles tab and write Percentage of the Vote or any other appropriate title, click on the Legend tab, deselect the show legend box, click on the Data Labels tab, select Show label and percent, then click next
5) In the Chart Location box, select the option that says As new sheet and name it Candidates Percent Graph
6) Click finish
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
1 |
Cand.1 |
Cand.2 |
Cand.3* |
M |
F |
Age11 |
Age12 |
Age13 |
Age14 |
TotStu |
TotGen |
TotAge |
2 |
|
|
|
|
|
|
|
|
|
=SUM(A32:C32) |
=D32+E32 |
=SUM(F32:I32) |
3 |
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
|
|
|
|
|
|
|
|
|
|
|
5 |
|
|
|
|
|
|
|
|
|
|
|
|
6 |
|
|
|
|
|
|
|
|
|
|
|
|
7 |
|
|
|
|
|
|
|
|
|
|
|
|
8 |
|
|
|
|
|
|
|
|
|
|
|
|
9 |
|
|
|
|
|
|
|
|
|
|
|
|
.. |
|
|
|
|
|
|
|
|
|
|
|
|
.. |
|
|
|
|
|
|
|
|
|
|
|
|
31 |
Tot1 |
Tot2 |
Tot3 |
TotM |
TotF |
Tot11 |
Tot12 |
Tot13 |
Tot14 |
|
|
|
32 |
=SUM(A1:A30) |
=SUM(B1:B30) |
=SUM(C1:C30) |
=SUM(D1:D30) |
=SUM(E1:E30) |
=SUM(F1:F30) |
=SUM(G1:G30) |
=SUM(H1:H30) |
=SUM(I1:I30) |
|
|
|
33 |
=A32/J2 |
=B32/J2 |
=C32/J2 |
=D32/J2 |
=E32/J2 |
=F32/J2 |
=G32/J2 |
=H32/J2 |
=I32/J2 |
|
|
|
*Cand.3 is optional or may be omitted if the independent candidate is the same as one of the two major party candidates. Tot1 = total votes for candidate1, Tot2 = total votes for candidate2, Tot3 = total votes for candidate3, TotM = total male votes, TotF = total female votes, Tot11 = total 11 year old student votes, Tot12 = total 12 year old student votes, Tot13 = total 13 year old student votes, Tot14 = total 14 year old student votes. You may modify this chart according to the number of students and the different ages you have in the class. TotStu= total amount of students in the class, TotGen=total amount of males and females in the class and TotAge=total amount of different aged students in the class. Row 33 contains the formulas for each percentage. (Right-click and Save file ElectionSheet to look at an example.) TotStu,TotGen and TotAge must all be equal. If there is a difference, you must recount the votes.