The site cited by the original poster calls the desired charts Radial
Treemaps
(
http://www.neoformix.com/2006/MLPC_U...6_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
"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"John Mansfield" wrote in
message ...
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/200...e-combination/
--
John Mansfield
cellmatrix.net
"Bahareh" wrote:
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