| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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%. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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%. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
| Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
| scatter chart insists on plotting as a line chart | New Users to Excel | |||
Linear Mode
