Great to see that you picked up the idea, and made this challenge around it! Being able to do more than the old pie and bar charts in Excel makes these techniques accessible to a lot more people, and hopefully shows them how much more can be done with visualization than the simple things Excel offers directly.

I agree with some of the comments in the other posting, there are some issues with perception here. Especially when only showing one number, filling the cells from the bottom (like a bar chart) is probably a better idea. However, when comparing several numbers, having areas as square as possible is preferable (squarified treemaps have shown this quite clearly). But this shows that even for simple graphics like this, there is still quite a bit of work to be done to understand how to use them most effectively.

Anyway, great blog, and you have really active readers/contributors!

[...] Nice ways of getting square pie charts. We’ll have to start using them. [...]

[...] Nice ways of getting square pie charts. We’ll have to start using them. [...]

Fantastic. And LOVE the video.

The challenge now is for someone to build in the functionality for showing two different ranges in the same chart.

I answered my own question and emailed in a solution (building on the previous work) that allows multiple values in the same chart. It is also here: http://beglen.googlepages.com/square_pie_DBB.xls

Looks nice, I think this is a terrible chart, for reason as made before, but it does look nice. I could not view the video sadly, in FF or IE :-( - could you put in on youtube?

This excercise flashed my memory back ages ago when someone showed me how to make a squared circle. But that's maths, not Excel.

Surely to show 2 values in the same chart you'll have the 1 colour which is the lower number, then the 2nd colour which is the higher number, the 2nd colour only needs to be stacked ontop of the 1st colour to show the comparitive difference?

[...] Toch lijkt deze uitwerking niet echt een goed alternatief: Optisch lijkt de eerste “taart” (of kunnen we deze grafiek beter “cake” noemen?) voor meer dan 56% gevuld. Een andere invulling (bijvoorbeeld hele regels van onderaf naar boven) vangt dit wellicht op. Ook het invullen van meerdere segmenten kan onduidelijk worden. Mocht je toch een vierkante taart willen maken in Excel, op Juice Analytics staan enkele in Excel uitgewerkte voorbeelden. [...]