Post your top 5 yDNA and mtDNA haplogroups in your 23andme DNA Relatives list

There should be a way to automatize pretty haplogroup diagrams out of the csv file. Excel vet requested at reception.

how do you do that?

bump - how do you see the ydna and mtdna of relatives?

Oh I see now

UPDATE: (I counted it wrong :D)

Y-DNA:
1. I2a2b
2. E-V13
3. R1a1a
4. R1b-U106
5. R1b-L21, I1

mt-DNA:
1. H
2. J1
3. U5
4. HV
5. K1

UK	420	38.7%
K	362	33.4%
K1a	301	27.7%
K1a1b	222	20.5%
K1a1b1	220	27.7%
K1a1b1a	219	20.2%
K1a1b1	1	0.1%
K1a1b	1	0.1%
K1a9	53	4.9%
K1a*	18	1.7%
K1a4	7	0.6%
K1a4a	6	0.6%
K1a4a*	5	0.5%
K1a4a1	1	0.1%
K1a4*	1	0.1%
K1a7'8	1	0.1%
K2	61	5.6%
K2a	60	5.5%
K2a2a	55	5.2%
K2a*	5	0.5%
K2b	1	0.1%
H	321	29.6%
H1	80	7.4%
H1*	41	3.8%
H1e	26	2.4%
H1b	5	0.5%
H1o	4	0.4%
H1f	2	0.2%
H1a	1	0.1%
H1c1	1	0.1%
H*	61	5.6%
HV	55	5.1%
HV1	39	3.6%
HV1b2	37	3.4%
HV1*	2	0.2%
HV5	15	1.4%
HV*	1	0.1%
H7	38	3.5%
H7*	37	3.4%
H7a	1	0.1%
H5	24	2.2%
H5a	15	1.4%
H5a*	13	1.2%
H5a1	2	0.2%
H5'36	6	0.6%
H5*	3	0.3%
H6a1	20	1.8%
H6a1*	13	1.2%
H6a1a1a	4	0.4%
H6a1b	3	0.3%
H6a1b*	2	0.2%
H6a1b2	1	0.1%
H3	15	1.4%
H3*	14	1.3%
H3g	1	0.1%
H11	9	0.8%
H11*	5	0.5%
H11a	4	0.4%
H10	5	0.5%
H10a1	4	0.4%
H10*	1	0.1%
H2a	4	0.4%
H2a1	2	0.2%
H2a2b1	2	0.2%
H4a1	4	0.4%
H4a1*	3	0.3%
H4a1b	1	0.1%
H15	2	0.2%
H15*	1	0.1%
H15b	1	0.1%
H13a1a1a	1	0.1%
H24	1	0.1%
H26	1	0.1%
H39	1	0.1%
N	87	8.0%
N1b	80	7.4%
N1b2	76	7.0%
N1b1	4	0.4%
N1b1b	3	0.3%
N1b1*	1	0.1%
N9a3	7	0.6%
J	79	7.3%
J1	76	7.0%
J1c	63	5.8%
J1c*	24	2.2%
J1c7	20	1.8%
J1c7a	19	1.7%
J1c7*	1	0.1%
J1c1	15	1.4%
J1c3	3	0.3%
J1c5	1	0.1%
J1b1a	13	1.2%
J2	3	0.3%
J2b1	2	0.2%
J2a1a	1	0.1%
U	58	5.4%
U5	27	2.5%
U5a	20	1.8%
U5a2	13	1.2%
U5a2b	12	1.1%
U5a2c	1	0.1%
U5a1	7	0.6%
U5a1a	4	0.4%
U5a1b1	3	0.3%
U7	11	1.0%
U2e1a	6	0.6%
U2a1	5	0.5%
U1b	4	0.4%
U6	4	0.4%
U6a7	3	0.3%
U6b1	1	0.1%
U4b1b	1	0.1%
T	50	4.6%
T2	28	2.6%
T2b	18	1.6%
T2b*	16	1.5%
T2b3	1	0.1%
T2b4	1	0.1%
T2g	4	0.4%
T2e	3	0.3%
T2a	2	0.2%
T2c1	1	0.1%
T1	22	2.0%
T1a	16	1.5%
T1a1	13	1.2%
T1a*	2	0.2%
T1a3	1	0.1%
T1*	6	0.6%
W	30	2.8%
W3	21	1.9%
W3a	11	1.0%
W3*	10	0.9%
W1	8	0.7%
W*	1	0.1%
V	25	2.3%
V7	23	2.1%
V7a	18	1.6%
V7*	5	0.5%
V1	4	0.4%
V1a	3	0.3%
V1*	1	0.1%
R	22	2.0%
R0a	21	1.9%
R0a*	12	1.1%
R0a2	9	0.8%
R	1	0.1%
L	12	1.1%
L2a1	12	1.1%
L2a1*	8	0.7%
L2a1I	4	0.4%
L2a1I*	3	0.3%
L2a1I2	1	0.1%
M	12	1.1%
M33c	7	0.6%
M1a	5	0.5%
M1a1b	4	0.4%
M1a*	1	0.1%
I	11	1.0%
I1	10	0.9%
I1*	9	0.9%
I1a1	1	0.1%
I*	1	0.1%
X	9	0.8%
X2b	7	0.6%
X2c1	1	0.1%
X2e	1	0.1%
B	2	0.2%
B2	2	0.2%
B2d	1	0.1%
A	2	0.2%
A2	1	0.1%
A4	1	0.1%
C	1	0.1%
C1	1	0.1%
D	1	0.1%
D1	1	0.1%

J	213	32.2%
J2	109	16.5%
J2a	50	7.6%
J2a1b	48	7.3%
J2a1b*	28	4.2%
J2a1b1	20	3.0%
J2a1	1	0.2%
J2a1h3	1	0.2%
J2	35	5.3%
J2b	24	3.6%
J2b2	15	2.3%
J2b*	9	1.4%
J1	104	15.7%
J1e	96	14.5%
J1*	8	1.2%
R	158	23.9%
R1	149	22.5%
R1b	76	11.5%
R1b1b	75	11.3%
R1b1b2a1a1d1	26	3.9%
R1b1b2	20	3.0%
R1b1b2a1a1d	15	2.3%
R1b1b2a	13	2.0%
R1b1b2a1a	10	1.5%
R1b1b2a1a1f	4	0.6%
R1b1b2a1a1	2	0.3%
R1b1b2a1a1d	2	0.3%
R1b1b2a1a2	2	0.3%
R1b1b2a1a1f2	1	0.2%
R1b1*	1	0.2%
R1a1a	70	10.6%
R1*	3	0.5%
R2	9	1.4%
E	146	22.0%
E1	145	21.9%
E1b1	140	21.1%
E1b1b	138	20.8%
E1b1b1	137	20.7%
E1b1b1c	76	11.5%
E1b1b1c1	64	9.7%
E1b1b1c1*	43	6.5%
E1b1b1c1a	21	3.2%
E1b1b1c*	12	1.8%
E1b1b1a	73	11.0%
E1b1b1a*	54	8.1%
E1b1b1a2	16	2.4%
E1b1b1a4	3	0.5%
E1b1b1*	33	5.0%
E1b1a	2	0.3%
E1b1a8a	1	0.2
E1b1a8a1	1
E1a1	5	0.8%
E2	1	0.2%
G	67	10.1%
G2	55	8.3%
G2c	37	5.6%
G2a	15	2.3%
G2a*	9	1.4%
G2a4	4	0.6%
G2a2	1	0.2%
G2a5	1	0.2%
G2*	3	0.5%
G1	12	1.8%
Q	30	4.5%
Q1b	30	4.5%
T	9	4.1%
T*	9	4.1%
I	19	2.9%
I2	18	2.7%
I2a	10	1.5%
I2a2	5	0.8%
I2a2b	4	0.6%
I2a2	1	0.2%
I2a1	4	0.6%
I2a*	1	0.2%
I2b1	7	1.1%
I2*	1	0.2%
I1	1	0.2%
N	2	0.3%
N1c1	2	0.3%

New update

YDNA:
R1a1a 76
E1b1b1a2 51
I1 33
J2 24
I2a2b 22

MtDNA:
H 80
H1 30
T2b 26
H1c 21
J1c 20