Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Excell
 
Posts: n/a
Default Create a pie of pie 3D

How can i create a pie of pie in 3D view?
  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create invoices Missie New Users to Excel 6 January 23rd 05 01:05 PM
create a drop down list with the source from a different workbook Sampath Excel Discussion (Misc queries) 2 January 8th 05 07:57 PM
trying to create Lost in reconcillation Excel Discussion (Misc queries) 2 December 19th 04 01:05 AM
Use Julian Date To Create Serial Number antho10359 Excel Discussion (Misc queries) 4 December 9th 04 01:50 AM
How do I create a formula that will multiply a 5% of a value >$150 babydear12 Excel Worksheet Functions 2 October 29th 04 01:00 AM


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"