3d Pie in Excel 2007

M

Meebers

I have a sample series of 4,1,1 total of 6 in which I made a 3d pie chart.
The largest section (4)is showing 67%, the 2nd section (1) is showing 17%
while the 3rd section (1) is showing 16%. I know there is rounding here,
but in actual %, showing 1 decimal place the results are 66.7, 16.7 and
16.7. The percentages shown on the chart are from choosing percentage
rather than value. It seems as if Excel is rounding up on 2 of the slices
and rounding down on the 3rd slice so as not to go over 100%. Analyzing the
chart, one has to ask: why are two equal shares not showing the same
percentage.? Is this a bug or am I not configured correctly?
 
S

Shane Devenshire

Hi,

I am able to duplicate your problem and it certainly seems like a bug. If
you change the format of the data labels to Number or just about anything
other than General there seems to be no problem.
 
M

Meebers

I agree...another oddity? is that you can edit the 16% and change it to 17%
right on the pie chart itself. This I have done on my presentation that
includes 4 other pie charts, some need help, others did not. I fixed them
all to keep the "suits" happy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top