Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create a pie of pie 3D
How can i create a pie of pie in 3D view?
|
#2
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create invoices | New Users to Excel | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
trying to create | Excel Discussion (Misc queries) | |||
Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
How do I create a formula that will multiply a 5% of a value >$150 | Excel Worksheet Functions |