Multilevel pie chart
 

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

Answer: Multilevel pie chart
 

Creating a Multilevel Pie Chart in Excel 2007

1. Enter your data in a table format with two columns: "Completed Nodes" and "Remaining Nodes by Type". Under "Remaining Nodes by Type", you would have sub-columns for each node type (e.g. Node Type A, Node Type B, etc.) and the corresponding number of nodes.
2. Select the data table and go to the Insert tab in the ribbon.
3. Click on the Pie chart icon and select the first pie chart option (a basic pie chart).
4. The pie chart will be inserted into your worksheet. Right-click on the chart and select Select Data.
5. In the "Select Data Source" dialog box, click on the Add button under "Legend Entries (Series)".
6. In the "Edit Series" dialog box, enter a name for the series (e.g. "Remaining Nodes by Type") and select the data range for the series (excluding the column headers).
7. Click OK to close the dialog box. You should now see the second level of the pie chart added to the first level.
8. To format the chart, you can use the Chart Tools tab in the ribbon. You can change the chart type, add data labels, adjust the colors, etc.

Multilevel pie chart
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bahareh" wrote in message
...
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

Multilevel pie chart
 

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

Multilevel pie chart
 

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

Multilevel pie chart
 

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