LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Pie Chart Percentage incorrect

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pie Chart labels seem incorrect Alice Graham Charts and Charting in Excel 1 March 16th 07 01:01 PM
Incorrect Data Labels on Column Chart SM Charts and Charting in Excel 0 June 7th 06 04:39 PM
Incorrect date in line chart in Excel. gobonniego Charts and Charting in Excel 0 June 7th 06 01:01 AM
Percentage Incorrect In Pie Chart Gladys Charts and Charting in Excel 1 February 13th 06 06:23 PM
Bar Chart depicting the "percentage of another percentage(less than 100)" TEAM Charts and Charting in Excel 1 October 28th 05 05:06 AM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"