ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pie Chart percentage (https://www.excelbanter.com/charts-charting-excel/246040-pie-chart-percentage.html)

KristaR

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?

KristaR

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