A true pyramid might be difficult, although maybe with custom shapes something can happen.
About the best you can do easily would be a Funnel like chart:
I have taken a stacked bar chart, and sized and colored it to create this funnel-like view:
The secret it to take your Pyramid Level and sort it manually. A better way would be to make the names more sortable like this:
"1 Special 1"
"2 Special 2"
"8 Leadership 3"
so it becomes properly sortable. That way your manual sorting won't get lost. Tweaking the sizes and row width can produce a more Pyramid like structure:
Thanks, Kris. The real challenge, I think, is going to be to represent the goals (count and amount sum) for each pyramid level. At least while still making it comprehensible at all....
Actually we can totally do a pyramid shape. All rungs would use a polygon, with the top rung being a triangle polygon.
This link provides much more detail on aggregating on custom polygons:
So yeah it can be done. It's a little outside my normal usage, but I will attempt this over the weekend and see if I can get it.
Mark, Cristian's solution is probably the easiest but the length between the categories is not going to vary. I think there might be some way to encode 2 variables in a funnel chart. Length of the chart could say one thing while width could say another. Take this manual mock up below I did below ("Please excuse the crudity of this model. I didn't have time to build it to scale...") We could say width of each segment is the number of dollars given by the people in that segment, while length of the segment is the number of givers. Then we could clearly see there is a fundamental difference between this two funds:
I'm going to mull on this some more. Fundamentally we are talking about a Gini Coefficient so I'm going to see if maybe there's a better solution to represent this graphically.