View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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