Create a Pareto Chart with Excel 365 Formulas

#Excel

Sorted Unique List:
=LET(r,A2:A500,u,UNIQUE(r),c,COUNTIF(r,u),SORTBY(u,c,-1))

Sorted Counts:
=LET(r,A2:A500,u,UNIQUE(r),c,COUNTIF(r,u),SORTBY(c,c,-1))

Running Count:
=SCAN(0,E2#,LAMBDA(i,n,i+n))

Cumulative Percentage:
=F2#/SUM(E2#)