Graph Help

[Fegal]

Hello clever people.

I have pile of data.
I would like a graph that shows how many achieved's are achieved in each year.

Is there a simple way?
I hav

National Training record 1.xlsx
	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT
24	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved	Competent	Achieved	N/A	Achieved	Achieved		Achieved	Achieved		Competent	Achieved
25	1/03/2015	1/05/2015	1/07/2018	1/02/2019	1/04/2015				1/07/2015	1/06/2015		1/09/2015		1/04/2016	1/11/2016		28/11/2015	1/05/2016			1/02/2020
26	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent		Achieved	Competent	Achieved	N/A	Achieved	Achieved			Achieved	Achieved	Competent	Achieved	Achieved										Achieved	Achieved		Achieved
27	7/07/2012		10/09/2018	16/01/2018	10/09/2018									17/10/2017	3/12/2019				10/01/2010		16/07/2020												25/05/2016		28/09/2016
28	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved	Competent	Achieved	N/A	Achieved	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Achieved												Achieved	Achieved
29	7/07/2012	19/9/2010	7/08/2018	10/01/2017	21/05/2015				1/08/2021	3/02/2013		10/12/2014		29/3/2014	6/12/2014	18/6/2015	28/11/2015	3/01/2014	10/01/2010		16/9/2015												25/05/2016	23/08/2018
30	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved	Competent	Achieved		Achieved				Achieved	Achieved	Competent	Achieved	Achieved	Achieved	Achieved					Achieved
31	21/07/2016	22/09/2016	10/09/2018	6/12/2019	23/11/2016				8/08/2017	1/09/2016		23/11/2016		27/05/2019				########			13/08/2019		9/02/2019
32	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved	Competent	Achieved	N/A	Achieved	Achieved			Achieved	N/A	Competent	Achieved		Achieved							Achieved
33	1/05/2016	1/04/2017	1/07/2018	1/02/2019	1/09/2017				1/07/2016	1/04/2017		1/10/2017		1/03/2018	1/09/2018			1/11/2018			1/10/2017		1/06/2019							1/11/2020
34	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent		Achieved	Competent	Achieved	Achieved	Achieved	Achieved				Achieved	Competent
35	18/08/2020	17/12/2019	11/08/2020	5/11/2020						1/12/2021		1/09/2022	14-10-23						24/07/2021
36	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved	Competent	Achieved	N/A	Achieved	Achieved				Achieved	Competent		Achieved
37	1/09/2021	23/01/2019	10/10/2022	1/03/2020	########				1/10/2019	1/12/2020		1/09/2022		########	########				########			7/10/2023
38	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent			Achieved	Competent	Achieved	Achieved						Achieved
39	1/08/2020	1/11/2020	10/10/2022	5/11/2020	13/06/2022					1/12/2020		1/09/2022	14-10-23						19/06/2022
40	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent		Achieved	Achieved		Achieved		Achieved				Achieved			Achieved	Achieved										Achieved
41	1/03/2015	1/04/2013	1/07/2018	1/10/2017	1/04/2015				1/07/2013	1/05/2014		1/07/2014		1/05/2015				1/02/2014			1/01/2020	1/11/2020										1/05/2016
42	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved	Competent	Achieved							Achieved		Achieved		Achieved
43	12/03/2019	17/12/2019	11/08/2020	5/11/2020	16/10/2021				12/11/2019	1/12/2021		1/09/2022							19/06/2022				12/06/2019
44	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved	Competent	Achieved							Achieved				Achieved
45	1/08/2019	23/11/2019	1/11/2020	1/03/2020	16/10/2021				1/10/2019	1/12/2020		1/09/2022							19/06/2022				1/11/2019
46	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved	Competent	Achieved	N/A	Achieved	Achieved			Achieved	Achieved			Achieved
47	15/09/2015	10/12/2015	10/09/2018	6/12/2019	28/01/2016				21/07/2016	23/09/2016		21/07/2016		17/10/2017	9/08/2019			########				7/10/2023
48	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved
49	1/04/2021	1/02/2019	########	15/04/2023	16/10/2021				21/08/2022
50	Achieved	Achieved	Achieved		Achieved	Competent	Competent			Achieved				Achieved							Achieved		Achieved
51	12/04/2018	6/03/2019	25/11/2019		16/10/2021					7/03/2019				25/11/2019							16/07/2020		12/06/2019
52	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent			Achieved	Competent	Achieved	Achieved						Achieved
53	1/08/2020	1/11/2020	10/10/2022	5/11/2020	13/06/2022					1/12/2020		1/09/2022	14-10-23						19/06/2022
54	Achieved	Achieved	Achieved	Achieved					Achieved	Achieved		Achieved		Achieved									Achieved
55	15/04/2019	6/03/2019	25/11/2019	5/05/2019					12/11/2019	7/03/2019		1/09/2022		25/11/2019									12/06/2019
56	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved
57	1/04/2020	1/06/2021	26-9-23	14/04/2022	16/10/2021				1/08/2021
58	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent			Achieved	Competent	Achieved		Achieved	Achieved
59	8/07/2018	13/05/2018	2/03/2019	4/11/2018	13-6-23					13/05/2018		3/08/2019			########
60	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved		Achieved		Achieved				Achieved	Achieved		Achieved
61	1/09/2014	1/09/2014	1/01/2013	1/04/2016	16/10/2021					1/01/2013		1/01/2013		29/03/2014				1/02/2014	19/06/2022		1/09/2015
62	Achieved	Achieved	Achieved	Achieved	Achieved
63	1/04/2022	1/03/2022	2/01/2022	14/04/2023	13/06/2023
64	Achieved	Achieved	Achieved	Achieved	Achieved	Competent				Achieved		Achieved	Achieved
65	12/01/2020	7/05/2020	19/02/2022	30/01/2022	16/10/2021					1/12/2021		1/09/2022	14-10-23
66	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved
67	16/09/2023	28/10/2023	########	14/04/2023	13/06/2023				1/04/2023
68	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved		Achieved
69	1/11/2015	24-9-23	1/04/2016	17/02/2019	1/04/2016				1/06/2016	1/09/2016		1/10/2016
70	Achieved	Achieved	Achieved	Achieved	Achieved	Competent	Competent	Competent	Achieved	Achieved	Competent	Achieved		Achieved							Achieved	Achieved								Achieved		Achieved
71	1/05/2016	1/02/2016	1/07/2018	1/03/2020	1/04/2016				1/06/2016	1/09/2016		1/10/2016		1/03/2017							1/10/2017	1/11/2020								1/03/2019		1/12/2017
72	Achieved	Achieved	Achieved			Competent
73	16/09/2023	19/08/2023	########
74	Achieved	Achieved	Achieved			Competent
75	16/09/2023	19/08/2023	########
76	Achieved	Achieved	Achieved	Achieved	Achieved				Achieved	Achieved									Achieved		Achieved		Achieved
77	1/02/2018	1/04/2018	1/06/2019	1/03/2019	1/08/2019				1/07/2019	1/06/2018									24/07/2021		1/01/2020		1/11/2019
National Training

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J102:J113,J66:J77,J24:K25,J27:K27,J29:K29,J31:K31,J33:K33,J35:K35,J37:K37,J41:K41,J43:K43,J45:K45,J47:K47,J49:K49,J51:K51,J53:K53,J55:K55,J57:K57,J59:K59,J61:K61,J63:K63,J65:K65,I26:K26,I28:K28,I30:K30,I32:K32,I34:K34,I36:K36,I40:K40,I42:K42,I44:K44,I46:K46	Cell Value	=$D$5	text	NO

Cells with Data Validation
Cell	Allow	Criteria
L24:AT77	List	=$D$1:$D$8

e more data to add to graph but its too large for xl2bb

 

[Fegal]

even if achieved wasnt even considered, i just need a bar graph of the number of time a year shows up

 

[Fegal]

Bump... please... anybody?