| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pie Chart Percentage incorrect | Charts and Charting in Excel | |||
| Percent two percentage in one chart | Excel Discussion (Misc queries) | |||
| Pie Chart to Percentage | Charts and Charting in Excel | |||
| Bar Chart Percentage | Excel Discussion (Misc queries) | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
Linear Mode
