ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pie of Pie (https://www.excelbanter.com/excel-discussion-misc-queries/261991-pie-pie.html)

Jeff

Pie of Pie
 
Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's help was not too helpful on this topic.

Luke M[_4_]

Pie of Pie
 
While I might argue that you should never use a pie of pie chart (there are
so many other useful options that don't distort data!!!), this feat is
accomplished by using the Chart Wizard - Chart type, pie of pie. Then, when
you format a series, under the options tab, you can choose how many series
you want to include in the second pie.

--
Best Regards,

Luke M
"Jeff" wrote in message
...
Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's help was not too helpful on this topic.




Billns

Pie of Pie
 
On 4/20/2010 1:13 PM, Jeff wrote:
Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's help was not too helpful on this topic.


This article may help:
http://office.microsoft.com/en-us/ex...179371033.aspx

If not Google for more...

Bill

Jeff

Pie of Pie
 
Thanks, Micky. Worked the first time!

"מיכאל (מיקי) אבידן" wrote:

Check this out:
http://office.microsoft.com/en-us/ex...179371033.aspx
Micky


"Jeff" wrote:

Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's help was not too helpful on this topic.


Bruce Sinclair

Pie of Pie
 
In article , ?B?SmVmZg==?= wrote:
Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's help was not too helpful on this topic.


Please don't do this. :) I suggest you read edward tufte's fine book on the
visual display of data for the resons why. He has a great example of why
this is abomination. :)


Billns

Pie of Pie
 
On 4/20/2010 1:13 PM, Jeff wrote:
Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's help was not too helpful on this topic.


I have to agree with Bruce and Luke. The results are not very pretty...

Bill


All times are GMT +1. The time now is 02:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com