How do I create a pie of pie chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following data:
a 66%
b 33%
and
b1 42%
b2 35%
b3 8%
b4 15%

how do I get a pie showing 66% and 33% and a sub pie connected to the 33%
showing the other 4 amounts?

The chart wizard is driving me round the bend! It keeps adding a 7th slice
called "series 1 point other"

aaaargh!!! Help!
 
With the following data in cells A1:B5 --

A B
1 a 66%
2 b1 42%
3 b2 35%
4 b3 8%
5 b4 15%

Enter the following in cells D1:E5 --

a =B1
b1 =(1-$B$1)*B2
b2 =(1-$B$1)*B3
b3 =(1-$B$1)*B4
b4 =(1-$B$1)*B5

Select a cell in the range D1:E5, and use the Chart Wizard to create a
Pie of Pie chart

Select one of the pies, and choose Format>Selected Data Series
Select the Options tab
Set the second plot to contain the last four values
Click OK
 
Back
Top