ExcelBanter

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

hr

Pie Chart
 
I have created multiple pie charts that are not displaying correct
percentages. For instance I key in 100 in one cell and 50 in the next cell.
I create the graph and ask for percentage, not value. The percentage
displays as 67% and 33%.

Andy Pope

Pie Chart
 
Hi,

It is correct is you are not displaying any precision.

100/(100+50) = 0.66666 = 67%
50/(100+50) = 0.33333 = 33%

What values did you expect to see?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"hr" wrote in message
...
I have created multiple pie charts that are not displaying correct
percentages. For instance I key in 100 in one cell and 50 in the next
cell.
I create the graph and ask for percentage, not value. The percentage
displays as 67% and 33%.




All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com