visualisation ribbon chart

[DJFANDANGO]

Hi Guys,

I'm trying to put together a ribbon chart showing the minimum requirements versus the actual requirements, I have only given a sample of the datasheet as there are 100's of lines:

Any help will be greatly appreciated.

Cold Work 10% minimum Required of total 'cold'
Hot Works 20% minimum Required of total 'hot'
Confined Space Entry 100% Required of total 'confined'

PTW-audit.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Date Permit Authorized	Permit Type	Permit Closed	Permit Audited		Permit Type	Permits Completed	Permits Audited	Min % Required	Actual % Done
2	27/07/2023	Cold Work	27/07/2023 17:00	TRUE		Cold Work	16	13	10%	81%
3	26/07/2023	Cold Work	26/07/2023 16:40	TRUE		Hot Works	6	5	20%	83%
4	25/07/2023	Cold Work	25/07/2023 13:10	TRUE		Confined space Entry	2	1	100%	50%
5	24/07/2023	Confined Space Entry	24/07/2023 16:40	TRUE		This is illustration only, not on the dataset
6	23/07/2023	Cold Work	23/07/2023 11:30	TRUE
7	23/07/2023	Hot Works	23/07/2023 16:45	TRUE
8	21/07/2023	Cold Work	21/07/2023 15:15	TRUE
9	20/07/2023	Hot Works	20/07/2023 23:00	TRUE
10	20/07/2023	Cold Work	20/07/2023 17:00	TRUE
11	20/07/2023	Cold Work	20/07/2023 17:00	TRUE
12	19/07/2023	Cold Work	19/07/2023 17:00	TRUE
13	19/07/2023	Cold Work	19/07/2023 17:00	TRUE
14	19/07/2023	Hot Works	19/07/2023 23:00	TRUE
15	17/07/2023	Cold Work	17/07/2023 10:00	FALSE
16	17/07/2023	Hot Works	17/07/2023 23:30	TRUE
17	16/07/2023	Cold Work	16/07/2023 12:30	TRUE
18	16/07/2023	Hot Works	16/07/2023 23:00	TRUE
19	16/07/2023	Cold Work	16/07/2023 23:30	FALSE
20	15/07/2023	Cold Work	15/07/2023 10:45	TRUE
21	13/07/2023	Cold Work	13/07/2023 12:00	TRUE
22	14/07/2023	Cold Work	14/07/2023 18:00	TRUE
23	14/07/2023	Cold Work	14/07/2023 23:30	FALSE
24	24/07/2023	Confined Space Entry	24/07/2023 16:40	FALSE
25	17/07/2023	Hot Works	17/07/2023 23:30	FALSE
GAionPermitToWork63826232481513

Cell Formulas
Range	Formula
G2	G2	=COUNTIF(GAionPermitToWork63826232481513!B:B,"Cold Work")
H2	H2	=COUNTIFS(GAionPermitToWork63826232481513!B:B,"Cold Work",GAionPermitToWork63826232481513!D:D, "True")
G3	G3	=COUNTIF(GAionPermitToWork63826232481513!B:B,"Hot Works")
H3	H3	=COUNTIFS(GAionPermitToWork63826232481513!B:B,"Hot Works",GAionPermitToWork63826232481513!D:D, "True")
G4	G4	=COUNTIF(GAionPermitToWork63826232481513!B:B,"Confined Space Entry")
H4	H4	=COUNTIFS(GAionPermitToWork63826232481513!B:B,"Confined Space Entry",GAionPermitToWork63826232481513!D:D, "True")
J2:J4	J2	=H2/G2

Named Ranges
Name	Refers To	Cells
_FilterDatabase	=GAionPermitToWork63826232481513!$B$1:$B$23	G2:H4