Solving the Pie

Last week I challenged the you to reproduce this alternative to pie charts in Excel. I promised a screencast to show how it’s done.

Square Pie

Eighteen people answered the call with nearly three dozen different solutions. Click here to watch the screencast showing how to accomplish the two most popular solutions; filling cells with conditional formatting and pushing the column chart to extremes.

If you want to look at the source,Clint Ivy produced an excellent version of the cell filling approach.

square_pie_clint_ivy.xls

Dermot Balson submitted an terrific version of the column chart approach.

square_pie_dermot_balson.xls

Thank you to everyone who submitted a solution.