Thread
:
Excel doesn't add up Pie Chats correctly
View Single Post
#
2
JulieD
Posts: n/a
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
Reply With Quote