View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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