There has to be a better way...

[Mchllwoods]

For weeks I've been trying to find a better way to make a Wind Rose Chart or a Spiral Bar Chart to keep track of my Achievements in Steam. I tried to ask AI-aided Formula Editor but it's either not working or I'm not asking the right questions.
I'm trying to find a better way to write the formula in cell D4 that does require such a long IFS argument, an additional Degree column in G4 and more dynamic. Also doesn't need additional Increment column in cell I4. If you have a better solution I'm all ears.

Link to excel file below:

SteamL.xlsx

Microsoft Excel Workbook

1drv.ms

I made dynamic arrays and data based on these videos below:

 

[Fluff]

How about

=LAMBDA(target,LET(counts,ROWS(target),ranks,SEQUENCE(counts),start,360/counts,inc,IFERROR(VSTACK(start,start*DROP(ranks,1)),start),degree,SEQUENCE(360),IF(ISNUMBER(MATCH(degree,inc,0)),"",XLOOKUP(INT((degree-1)/start)+1,ranks,INDEX(target,,2)))))(A4#)

 

[Mchllwoods]

How about

=LAMBDA(target,LET(counts,ROWS(target),ranks,SEQUENCE(counts),start,360/counts,inc,IFERROR(VSTACK(start,start*DROP(ranks,1)),start),degree,SEQUENCE(360),IF(ISNUMBER(MATCH(degree,inc,0)),"",XLOOKUP(INT((degree-1)/start)+1,ranks,INDEX(target,,2)))))(A4#)

That actually worked, thank u so very much!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Mchllwoods]

Hey everyone! Hru? Just wanted to share a revised formula I made without extra LET arguments. Hopefully this will help others that might have the same issues I did.

=LAMBDA(target,LET(
numbers,SEQUENCE(360),
current,ROWS(target),
ranks,SEQUENCE(current),
increments,360/current*ranks,
degree,XLOOKUP(INT(numbers/(360/current)+1),ranks,INDEX(target,,2)),
IF(ISNUMBER(XMATCH(numbers,increments)),"",degree)))(Dashboard!A23#)