Mchllwoods
New Member
- Joined
- Feb 15, 2019
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
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:
I made dynamic arrays and data based on these videos below:
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:

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