Excel doesn't add up Pie Chats correctly
 

Thank you for reading me. I've found a possible problem with Excel 2002 and
would be most grateful if anyone can shed any light on it.

Let's say I want to produce an expanded pie chart showing the incidence of
set data:
2.2 = 30%
4.3 = 20%
5.6 = 23%
6.4 = 27%
= 100%
Highligting the two columns, and requesting an expanded pie chart. Gives
results which don't match. For example the first field 2.2 should occur 30%
but holding the mouse over it tells me that the value 2.2 = 12%

It took me ages to find this group, so would be most grateful if you could
e-mail with any suggestions / explainations:

Many grateful thanks,
~ Peter

Hi Peter

the reason it doesn't appear to work is that excel doesn't recognise your
first column as labels, it thinks this is data to and 2.2 is around 12% of
18.5,
so to create the chart like i think you want, select the second column only
and press F11
then choose chart / type and choose exploded pie chart
then choose chart / source data - go to the series tab, click in category
labels and then highlite the first column of your data
then choose chart / chart options . - data labels and tick category labels
and %
and i think this will give you what you want.

Cheers
JulieD

"Peter Thorn" <Peter wrote in message
...
Thank you for reading me. I've found a possible problem with Excel 2002
and
would be most grateful if anyone can shed any light on it.

Let's say I want to produce an expanded pie chart showing the incidence of
set data:
2.2 = 30%
4.3 = 20%
5.6 = 23%
6.4 = 27%
= 100%
Highligting the two columns, and requesting an expanded pie chart. Gives
results which don't match. For example the first field 2.2 should occur
30%
but holding the mouse over it tells me that the value 2.2 = 12%

It took me ages to find this group, so would be most grateful if you could
e-mail with any suggestions / explainations:

Many grateful thanks,
~ Peter