Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bubble chart with multiple values per series | Charts and Charting in Excel | |||
Stacked Bar Chart w/multiple values | Charts and Charting in Excel | |||
dymanically generate chart, based on multiple values | Charts and Charting in Excel | |||
Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
Multiple values within one chart | Charts and Charting in Excel |