Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Percentages in a pie chart
I am trying to create a pie chart that shows the percentages of each type of
monthly expenses for a household. I have set up a spreadsheet that contains the category name, the amount of each bill and the percentage that each bill represents of the monthly income. The problem is that when I create the chart, the percentages shown in the pie chart are different than the percentages shown on the spreadsheet. I know that the chart is updating automatically from the numbers on the spreadsheet because when I change any of the info on the spreadsheet the percentages on the chart change also but they still aren't right. I have tried to create the chart by including the percentages that have been figured in the spreadsheet and I have tried to create the chart by not including the percentages and it doesn't seem to have any effect on what the chart come up with in regard to the percentages it shows. Is there some kind of formatting that I'm doing wrong or anything.... I haven't done much with charts but I can usually figure most things out by playing around with it but this one is driving me crazy. Any help would be much appreciated...... |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Percentages in a pie chart
The issue is a result of how Excel creates pie chart percentages i.e. it
forces the percentages to equal exactly 100%. Please refer to the link below for details. http://support.microsoft.com/kb/214033 To get around this, consider downloading John Walkenbach's Chart Tools add-in which is available via the link below. http://j-walk.com/ss/excel/files/charttools.htm Once you have the add-in set up, use the Data Labels feature to apply the data from the spreadsheet directly to the pie chart labels. -- John Mansfield http://cellmatrix.net "Niki" wrote: I am trying to create a pie chart that shows the percentages of each type of monthly expenses for a household. I have set up a spreadsheet that contains the category name, the amount of each bill and the percentage that each bill represents of the monthly income. The problem is that when I create the chart, the percentages shown in the pie chart are different than the percentages shown on the spreadsheet. I know that the chart is updating automatically from the numbers on the spreadsheet because when I change any of the info on the spreadsheet the percentages on the chart change also but they still aren't right. I have tried to create the chart by including the percentages that have been figured in the spreadsheet and I have tried to create the chart by not including the percentages and it doesn't seem to have any effect on what the chart come up with in regard to the percentages it shows. Is there some kind of formatting that I'm doing wrong or anything.... I haven't done much with charts but I can usually figure most things out by playing around with it but this one is driving me crazy. Any help would be much appreciated...... |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Percentages in a pie chart
Try multipling the % by 360.
"Niki" wrote: I am trying to create a pie chart that shows the percentages of each type of monthly expenses for a household. I have set up a spreadsheet that contains the category name, the amount of each bill and the percentage that each bill represents of the monthly income. The problem is that when I create the chart, the percentages shown in the pie chart are different than the percentages shown on the spreadsheet. I know that the chart is updating automatically from the numbers on the spreadsheet because when I change any of the info on the spreadsheet the percentages on the chart change also but they still aren't right. I have tried to create the chart by including the percentages that have been figured in the spreadsheet and I have tried to create the chart by not including the percentages and it doesn't seem to have any effect on what the chart come up with in regard to the percentages it shows. Is there some kind of formatting that I'm doing wrong or anything.... I haven't done much with charts but I can usually figure most things out by playing around with it but this one is driving me crazy. Any help would be much appreciated...... |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Percentages in a pie chart
The data label option for percentages displays the percentage of each wedges
part of the circle. If you have three percentages in the sheet, each 25%, selecting the percentages option will not show 25%, it will show 33 or 34%. If instead, you choose the values option, you will see 25% for each. There are so many better options than pie charts. Use a pareto chart (a column chart with items sorted from high to low), with custom labels if need be. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Niki" wrote in message ... I am trying to create a pie chart that shows the percentages of each type of monthly expenses for a household. I have set up a spreadsheet that contains the category name, the amount of each bill and the percentage that each bill represents of the monthly income. The problem is that when I create the chart, the percentages shown in the pie chart are different than the percentages shown on the spreadsheet. I know that the chart is updating automatically from the numbers on the spreadsheet because when I change any of the info on the spreadsheet the percentages on the chart change also but they still aren't right. I have tried to create the chart by including the percentages that have been figured in the spreadsheet and I have tried to create the chart by not including the percentages and it doesn't seem to have any effect on what the chart come up with in regard to the percentages it shows. Is there some kind of formatting that I'm doing wrong or anything.... I haven't done much with charts but I can usually figure most things out by playing around with it but this one is driving me crazy. Any help would be much appreciated...... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentages in pie chart | Excel Discussion (Misc queries) | |||
stacked bar chart with percentages | Charts and Charting in Excel | |||
percentages in an excel pie chart | Charts and Charting in Excel | |||
pie chart percentages are not right! | Charts and Charting in Excel | |||
Bar Chart with Percentages Added | Charts and Charting in Excel |