Below is a table containing voter data by district. make a pivot table and pivot chart that shows the % of Democrats and Republicans in each district. How many districts did each party win?

Voter	District	Party
1	4	Rep
2	6	Dem
3	6	Rep
4	4	Dem
5	2	Rep
6	9	Rep
7	4	Rep
8	8	Dem
9	4	Rep
10	8	Rep
11	6	Rep
12	8	Dem
13	5	Rep
14	7	Dem
15	5	Rep
16	8	Rep
17	2	Dem
18	7	Dem
19	6	Dem
20	3	Rep
21	1	Dem
22	4	Dem
23	1	Dem
24	5	Rep
25	2	Dem
26	5	Dem
27	1	Rep
28	7	Dem
29	8	Rep
30	5	Rep
31	2	Dem
32	9	Dem
33	9	Dem
34	3	Rep
35	3	Dem
36	2	Dem