Pie Chart percentage
I am working in Excel 2007. I have a simple pie chart.
Two numbers are used: 9,607,932 261,228,187 I am using percentages out to two decimal places in the data labels, but the labels don't match the percentages that were calculated in the Excel spreadsheet. Calculated = 3.68% and 96.32% Displayed labels = 3.55% and 96.45% How can I show the correct percentages in my chart labels? Am I missing something in the label attributes? |
Pie Chart percentage
Figured out my problem. The second number is my total. The percentages are
correct. Oops! "KristaR" wrote: I am working in Excel 2007. I have a simple pie chart. Two numbers are used: 9,607,932 261,228,187 I am using percentages out to two decimal places in the data labels, but the labels don't match the percentages that were calculated in the Excel spreadsheet. Calculated = 3.68% and 96.32% Displayed labels = 3.55% and 96.45% How can I show the correct percentages in my chart labels? Am I missing something in the label attributes? |
All times are GMT +1. The time now is 04:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com