AFLIP

[Xlambda]

AFLIP flips an array horizontally and/or vertically. Does not call any other lambda.

=LAMBDA(a,[f],
    LET(r,ROWS(a),c,COLUMNS(a),sr,SEQUENCE(r),sc,SEQUENCE(,c),
      x,IF(f,ABS(sr-r-1),sr),y,IF(f=1,sc,ABS(sc-c-1)),
      INDEX(IF(a="","",a),x,y)
    )
)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	sample						f,omitted
2	1	2	3	4	5		=AFLIP(A2:E5)						if f <>(0,1,2) array flips both directions
3	6	7	8		10		5	4	3	2	1		f,3
4	11		13	14	15		10		8	7	6		=AFLIP(A2:E5,3)
5	16	17	18	19	20		15	14	13		11		20	19	18	17	16
6							20	19	18	17	16		15	14	13		11
7													10		8	7	6
8							f,1						5	4	3	2	1
9							=AFLIP(A2:E5,1)
10							16	17	18	19	20
11							11		13	14	15
12							6	7	8		10
13							1	2	3	4	5
14
15							f,2
16							=AFLIP(A2:E5,2)
17							20	19	18	17	16
18							15	14	13		11
19							10		8	7	6
20							5	4	3	2	1
21
Sheet1

Cell Formulas
Range	Formula
G2,G16,G9,M4	G2	=FORMULATEXT(G3)
G3:K6	G3	=AFLIP(A2:E5)
M5:Q8	M5	=AFLIP(A2:E5,3)
G10:K13	G10	=AFLIP(A2:E5,1)
G17:K20	G17	=AFLIP(A2:E5,2)
Dynamic array formulas.

 

[GraH]

Amazing!

 

[Xlambda]

Amazing!

Thanks a lot!! Highly appreciated!!

 

[Xlambda]

If we need the charts stacked horizontally or vertically.
NWAW(m,v,r,c,[txt],[o])
m: max value
v: value or array of values
r: rows of each waffle chart
c: clms of each waffle chart
[txt]: labels text
[o]: orientation argument, if omitted or 0 displayed horizontally, if 1 or <>0 vertically

=LAMBDA(m,v,r,c,[txt],[o],
    LET(
        n, COUNT(v),
        REDUCE(n & " charts",SEQUENCE(n),
            LAMBDA(k,i,
                LET(
                    x, INDEX(v, i),
                    y, DROP(WAF(m, x, r, c, txt), , -1),
                    IFNA(IF(o,VSTACK(k, HSTACK("Waf." & i, y), ""),HSTACK(k, "Waf." & i, y, "")),"")
                )
            )
        )
    )
)

Waffle Chart.xlsx
	A	B	C	D	E	F	G	H	I	J	K	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
1		o,omitted=>charts displayed horizontally
2		=NWAF(200,{53,147,105},20,10,"lbs")
3		↓↓↓
4		3 charts	Waf.1											53 lbs		Waf.2											147 lbs		Waf.3											105 lbs
5
6
7
8
9																	1	1	1	1	1	1	1
10																	1	1	1	1	1	1	1	1	1	1
11																	1	1	1	1	1	1	1	1	1	1
12																	1	1	1	1	1	1	1	1	1	1
13																	1	1	1	1	1	1	1	1	1	1				1	1	1	1	1
14																	1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1
15																	1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1
16																	1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1
17																	1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1
18				1	1	1											1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1
19				1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1
20				1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1
21				1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1
22				1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1
23				1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1				1	1	1	1	1	1	1	1	1	1
24
Waffle 3

Cell Formulas
Range	Formula
B2	B2	=FORMULATEXT(B4)
B4:AO23	B4	=NWAF(200,{53,147,105},20,10,"lbs")
Dynamic array formulas.

 

[Xlambda]

Waffle Chart.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1		o,1=> charts displayed vertically
2		=NWAF(200,{53,147,105},20,10,"lbs",1)													all in one
3		3 charts													=WAF(200,{53,147,105},20,10,"lbs")
4		Waf.1											53 lbs												53 lbs	1
5																									105 lbs	2
6																									147 lbs	3
7
8
9															3	3	3	3	3	3	3
10															3	3	3	3	3	3	3	3	3	3
11															3	3	3	3	3	3	3	3	3	3
12															3	3	3	3	3	3	3	3	3	3
13															2	2	2	2	2	3	3	3	3	3
14															2	2	2	2	2	2	2	2	2	2
15															2	2	2	2	2	2	2	2	2	2
16															2	2	2	2	2	2	2	2	2	2
17															2	2	2	2	2	2	2	2	2	2
18			1	1	1										1	1	1	2	2	2	2	2	2	2
19			1	1	1	1	1	1	1	1	1	1			1	1	1	1	1	1	1	1	1	1
20			1	1	1	1	1	1	1	1	1	1			1	1	1	1	1	1	1	1	1	1
21			1	1	1	1	1	1	1	1	1	1			1	1	1	1	1	1	1	1	1	1
22			1	1	1	1	1	1	1	1	1	1			1	1	1	1	1	1	1	1	1	1
23			1	1	1	1	1	1	1	1	1	1			1	1	1	1	1	1	1	1	1	1
24
25		Waf.2											147 lbs
26
27
28
29
30			1	1	1	1	1	1	1
31			1	1	1	1	1	1	1	1	1	1
32			1	1	1	1	1	1	1	1	1	1
33			1	1	1	1	1	1	1	1	1	1
34			1	1	1	1	1	1	1	1	1	1
35			1	1	1	1	1	1	1	1	1	1
36			1	1	1	1	1	1	1	1	1	1
37			1	1	1	1	1	1	1	1	1	1
38			1	1	1	1	1	1	1	1	1	1
39			1	1	1	1	1	1	1	1	1	1
40			1	1	1	1	1	1	1	1	1	1
41			1	1	1	1	1	1	1	1	1	1
42			1	1	1	1	1	1	1	1	1	1
43			1	1	1	1	1	1	1	1	1	1
44			1	1	1	1	1	1	1	1	1	1
45
46		Waf.3											105 lbs
47
48
49
50
51
52
53
54
55			1	1	1	1	1
56			1	1	1	1	1	1	1	1	1	1
57			1	1	1	1	1	1	1	1	1	1
58			1	1	1	1	1	1	1	1	1	1
59			1	1	1	1	1	1	1	1	1	1
60			1	1	1	1	1	1	1	1	1	1
61			1	1	1	1	1	1	1	1	1	1
62			1	1	1	1	1	1	1	1	1	1
63			1	1	1	1	1	1	1	1	1	1
64			1	1	1	1	1	1	1	1	1	1
65			1	1	1	1	1	1	1	1	1	1
66
Waffle 4

Cell Formulas
Range	Formula
B2,O3	B2	=FORMULATEXT(B3)
B3:M66	B3	=NWAF(200,{53,147,105},20,10,"lbs",1)
O4:Z23	O4	=WAF(200,{53,147,105},20,10,"lbs")
Dynamic array formulas.

 

[Xlambda]

Screen capture insert (to many cells for minisheet)
Same display like in Chandoo's example, single cell formula plus some text boxes