How do I set up multiple values in a pie chart
 

I am trying to divide a pie chart like this;
1st section 75% and 25%
Then divide the 25% section like this;
40% and 60%
Then divide the 40%; 28% and 12%
And divide the 60%; 85% and 15%
And then divide the 60% up

How do I set up multiple values in a pie chart
 

Hi,

First, your example is not consistant - you divide 40% into 12% & 28% in all
other cases you are breaking the number into 40+60 or 20+80 all = 100

In general calculate:

75%
25%*40%
25%*60%*85%
25%*60%*15%

And plot these results. Note I did not finish the 25*40 one since it is not
clear what you want to do

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"George" wrote:

I am trying to divide a pie chart like this;
1st section 75% and 25%
Then divide the 25% section like this;
40% and 60%
Then divide the 40%; 28% and 12%
And divide the 60%; 85% and 15%
And then divide the 60% up

How do I set up multiple values in a pie chart
 

So multiply the fractions. 40% of 25% is 10%, 60% of 25% is 15%. And so
forth.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"George" wrote in message
...
I am trying to divide a pie chart like this;
1st section 75% and 25%
Then divide the 25% section like this;
40% and 60%
Then divide the 40%; 28% and 12%
And divide the 60%; 85% and 15%
And then divide the 60% up