Forum Discussion

Andre304's avatar
Andre304
Copper Contributor
Dec 24, 2022

Binomial Lattice Graph

Hi everyone, Are there any way I can make a binomial lattice graphic like the one i put below? https://1drv.ms/x/s!AhCCFUe0gk2Hm320raqU6G9in0MH?e=UeRXmA  Thank you
Charting
excel
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Dec 24, 2022

Andre304 

This was possible but involved some pretty awkward 365 formulas.

 

= LET(
      level, SEQUENCE(levels),
         nodes, REDUCE({"x","y"}, level,
            LAMBDA(acc,n,
               VSTACK(acc,
                  LET(
                     x, SEQUENCE(n,1,n-1,0),
                     y, SEQUENCE(n,1,n-1,-2),
                     b, IF(SEQUENCE(n),NA()),
                     HSTACK(x, y, x+1, y+1,b, b, x, y, x+1, y-1,b,b)
                  )
               )
            )
         ),
   WRAPROWS(TOCOL(DROP(nodes,1)), 2))

 

Resources