![]() |
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%. |
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