Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a Pie Chart that I have created that I am having a problem with. The
chart is rounding numbers incorrectly. One value (out of 16) is 19.13% of the total, yet the pie chart rounds this down to 18%. Another value in the same chart is 18.75% of the total but it is rounded up to 19%. I was questioned about this discrepency and found that if I Format Data Labels with 1 deicmal place, the values do show correctly (19.1% and 18.8%). But of course now I'm being questioned as to why I changed the format. Is there a way to fix my Pie chart so it shows the correctly rounded numbers without a decimal place? Is this 'hidden feature' fixed in Excel 2007? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pie Chart labels seem incorrect | Charts and Charting in Excel | |||
Incorrect Data Labels on Column Chart | Charts and Charting in Excel | |||
Incorrect date in line chart in Excel. | Charts and Charting in Excel | |||
Percentage Incorrect In Pie Chart | Charts and Charting in Excel | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel |