View Single Post
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

This is not a standard chart option.

You could mimic this by using 2 chartobjects. Both 3d pies, sized and
positioned to look like a PoP chart. You will not be able to have
connecting lines unless you use drawing objects.
You will also need to create 2 new sets of data. Obviously a subset for
the second pie but also a set for the main pie where the elements in the
second pie are summed and this extra Others slice is then rotated to
align with the other pie. Sounds complicated but is fairly straight
forward of you only have a few to do. If you need further help post back.
Personally I suggest you stay clear of the 3d effect and use the
standard PoP.

Cheers
Andy


Excell wrote:
How can i create a pie of pie in 3D view?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info