WEB DuBois Challenge 2025 Plate 25 Assessed Value of Furniture

Advocate I
554 Views
kinsailgal
Advocate I
Advocate I

WEB DuBois Challenge 2025 Plate 25 Assessed Value of Furniture

@Archimedean Spiral

x = (a+b * radian angle) * cos(radian angle), y = (a + b * radian angle) * sin(radian angle).  

Fussing with values for a & b made a big difference in the appearance of the chart.

thefarside
Advocate V
Advocate V

Oh wow that's a creative solution, well done! I just learned about the challenge (I should read emails I get from them more often), so I'm going to at least try to do challenge 9 and 10 in Power BI.

thefarside
Advocate V
Advocate V

Great job! What visual did you use to create the spiral?

@thefarside thank you! I used a scatter plot with big circle marks. I shaped the data in excel first, then created 6 separate charts and overlaid one on the other. As I think about it I believe I could have done it with one chart with a little more shaping in query .... unpivoting and text splitting until I ended up with a single x and y (instead of 5 x's and 5 y's) and a column for the year/color. There are 3 more Dubois Challenge charts to go so I cut bait but still want to play a little more with it. 

avatar user