Multilevel pie chart

[Bahareh]

Hello

I wanted to draw a pie chart of project progress. Ex:. we had 120 Nodes and
48 nodes are not completed yet. I easily can have a pie chart for it. but I
want the another level around it to show the breakdown of remaind ones to
type of the nodes sth lie: Node Type A=12, Node Type B=4,....

I don't want "pie of pie" as it doesn't show the breakdown of remaind nodes
from total nodes.

I searched the web, and seems I want sth. similar to this:
http://www.neoformix.com/2006/MultiLevelPieChart.html

How did he do that?
I use Excel 2007.

Thanks
BHR

 

[Andy Pope]

Hi,

With 120 nodes I would guess the pie will become unreadable, or should that
be even more unreadable
Still the technique is described here. I have not tested in xl2007 but I
think it should work.
http://www.andypope.info/charts/pies.htm

Cheers
Andy

 

[John Mansfield]

Hello,

Jon Peltier shows how to create a Donut-Pie combination chart at his Peltier
Technical Services Blog. Please see the link below . . .

http://peltiertech.com/WordPress/2008/11/26/donut-pie-combination/

 

[Jon Peltier]

Yeah, but that article was written tongue-in-cheek, and the point is, a pie
chart is generally not a good way to display information, and these multi
level pie charts are even worse.

I don't have a great idea for how to display this information, but I think a
Waterfall Chart may do it justice.

http://peltiertech.com/Excel/Charts/Waterfall.html

Start with data like this:

Complete - 72
Type A - 12
Type B - 4
Type C - 16
etc.

following the technique in the article cited above, build the waterfall
chart so that the "Complete" column in the first category position goes from
0 to 72, then Type A in the next category position goes from 72 to 84, Type
B in the next position goes from 84 to 88, etc. The final column, "Total"
goes from 0 to 120.

- Jon

 

[Gaj Vidmar]

The site cited by the original poster calls the desired charts Radial
Treemaps
(http://www.neoformix.com/2006/MLPC_USAutoSales2006_JanJun.html),
which is not unreasonable and is in line with computer science / infoviz
world.

Of course, though, this is yet another wheel reinvention with respect to
statistics -- see

R.F.Bordley, Representing trees using microsoft doughnut charts,
The American Statistician, 2002, Vol. 56, No. 2, p. 139-147

for an Excel implementation -- though (as I mentioned in a post to this
group long ago) the paper mentiones
as publicly available a macro for that purpose, which is nowhere and no way
to be found.
Nevertheless, recently, there was a discussion with Excel instructions and
pros and contras and alternatives
on one of the (increasingly proliferating) information visualisation / BI
blogs -- it could/must have been Jon,
and/or Jorge Camons -- anyone can do the search quickly and easily enough
and see for themselves.

Mosaic plots could also be adapted to represent such data (i.e., "stacked
bars of unequal width",
also called Marimekko charts in a similarly unnecessary, if not despicable,
manner as mentioned above).

Regards,

Assist.Prof. Gaj Vidmar, PhD
Institute for Rehabilitation, Republic of Slovenia