Pie charts with wrong percentages...

[Angelica]

Sometimes it's the simple things which cause the most frustration:

I have a pie chart with 4 categories, and the numbers in each category 2, 35, 95 and 12 respectively; however, when asked to show percentage labels, it displays 1, 24, *67* and 8. That third number should be 95/144 = 66%. If I ask it to display a decimal place it shows the correct number of 66.0%, but I could do with having it without the decimal for a report. Any ideas how to override what seems to be an insistence on making it all add up to 100%?

Thank'ee...

 

[RalphA]

Can you use a trick? If so, here is how I did it:

In A1:A4, I entered your values 2, 35, 95 and 12
In B1, I enterd the formula, =A1/A$5, and copied down to B4
I highlighted B1:B4 and invoked the Chart Wizard.
In the choice of "Value" or "Percent", I chose "Value, and got what you want.