Pie of Pie

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

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.
 
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.
 
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.
Click to expand...

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. :)
 
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.
Click to expand...

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

Bill
 
Back
Top