Thread: Pie of pie - second pie percentages

Originally Posted by Trick

Ive just noticed for the first time today that when creating a pie of pie chart, the second pie (when split by position) shows the percentage of the "other" segment and not the percentage of the whole of that segment...

i`ll try and explain:

I have the data sorted by position, and the last 5 values represent
the "other" segment in the first main pie, and are shown in the second.

Total of other is say 1,000, and represents 10% of the total of the main pie.
The second pie is split into 5, and i would expect them to show me what percentage of the 10% they represent...eg if one item was 200, that would be 20%, but it is showing the total percent of the whole total of 10,000 eg. 2%.

clear as mud?

can it be shown to be the former?

Hi,

I thought the object of 'pie of pie' was to further represent a portion of the original pie. To achieve what you are asking would be a simple pie on the relavant numbers.

hth
---

Originally Posted by Trick

Sorry but i dont agree.

If you are performing a further analysis of the pie, in value terms it works fine. But as a percentage it doesnt.

Say the main pies represented sales by territory, and the segment i am further analysing is split into customers.
I would like to say:

"of the 40m (20%) that represents the european territory, 50% is made up by x, 25% by y, and 25% by z"

It only really works for value.

you wouldnt say, that the 20% european is made of of 10% x, 5% y, 5% z. It doesnt mean anything - in fact could be misleading.

If you want a half of the 40m to show as 50% you would use a Pie chart.

A Pie-of-pie represents a portion of the original in a new Pie shape, but it is still a portion of the original.

If you disagree with the way MS treat the figures in a Pie-of-pie then you need to get Microsoft to amend their software..

---