I want a pie chart where each slice, say personnel group, is also divided,
by say type of orders. Is this possible?
For example I would have the 'Pie Eaters' with total 50 orders (their
slice), 45 for pies (a portion of the slice), and 5 for fruit (a smaller
portion of the slice). 'Healthy Eaters' with 40 orders, 28 for fruit, 10
for yoghurt and 2 for pie. The 'Dieters' with 10 orders, all for Health
Drinks. The pie would have 3 slices. The Pie Eaters slice, half the pie,
would have 2 parts. The healthy eaters slice, 40% of the pie, would also
have 3 parts, 2 the same colour as pie eaters and the dieters slice would
just have one colour and be very thin. Only 10% of the pie.

TIA

phil

On Mar 27, 10:31 am, phil wrote:
I want a pie chart where each slice, say personnel group, is also divided,
by say type of orders. Is this possible?
For example I would have the 'Pie Eaters' with total 50 orders (their
slice), 45 for pies (a portion of the slice), and 5 for fruit (a smaller
portion of the slice). 'Healthy Eaters' with 40 orders, 28 for fruit, 10
for yoghurt and 2 for pie. The 'Dieters' with 10 orders, all for Health
Drinks. The pie would have 3 slices. The Pie Eaters slice, half the pie,
would have 2 parts. The healthy eaters slice, 40% of the pie, would also
have 3 parts, 2 the same colour as pie eaters and the dieters slice would
just have one colour and be very thin. Only 10% of the pie.

TIA

phil

You could accomplish this with a pivotchart. Do this by selecting the
data and adding a pivotchart. Drag the two data labels (personnel
group and order) to the categories area and then drag the count column
to the chart. Then you could give all of the similar parent categories
a related color with a different shade/tint for the sub-categories.
Alternatively you might consider using a horizontal bar chart for
displaying these values.

Hi,

If you really must use a pie then maybe this tricks will help.
http://www.andypope.info/charts/pies.htm

Cheers
Andy

phil wrote:
I want a pie chart where each slice, say personnel group, is also divided,
by say type of orders. Is this possible?
For example I would have the 'Pie Eaters' with total 50 orders (their
slice), 45 for pies (a portion of the slice), and 5 for fruit (a smaller
portion of the slice). 'Healthy Eaters' with 40 orders, 28 for fruit, 10
for yoghurt and 2 for pie. The 'Dieters' with 10 orders, all for Health
Drinks. The pie would have 3 slices. The Pie Eaters slice, half the pie,
would have 2 parts. The healthy eaters slice, 40% of the pie, would also
have 3 parts, 2 the same colour as pie eaters and the dieters slice would
just have one colour and be very thin. Only 10% of the pie.

TIA

phil

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks Josh, but the data comes from a pivot chart which already gives me a
bar chart, which I think is more helpful anyway, but the boss likes pie, fat
b******. The problem was with filling

"Josh heep" wrote:

You could accomplish this with a pivotchart. Do this by selecting the
data and adding a pivotchart. Drag the two data labels (personnel
group and order) to the categories area and then drag the count column
to the chart. Then you could give all of the similar parent categories
a related color with a different shade/tint for the sub-categories.
Alternatively you might consider using a horizontal bar chart for
displaying these values.

Thanks, worked well enough. If the whole pie slice could be just one group
of personnel and that single slice divided up it would be better but this
will still blind them with science.

"Andy Pope" wrote:

Hi,

If you really must use a pie then maybe this tricks will help.
http://www.andypope.info/charts/pies.htm

Cheers
Andy

phil wrote:
I want a pie chart where each slice, say personnel group, is also divided,
by say type of orders. Is this possible?
For example I would have the 'Pie Eaters' with total 50 orders (their
slice), 45 for pies (a portion of the slice), and 5 for fruit (a smaller
portion of the slice). 'Healthy Eaters' with 40 orders, 28 for fruit, 10
for yoghurt and 2 for pie. The 'Dieters' with 10 orders, all for Health
Drinks. The pie would have 3 slices. The Pie Eaters slice, half the pie,
would have 2 parts. The healthy eaters slice, 40% of the pie, would also
have 3 parts, 2 the same colour as pie eaters and the dieters slice would
just have one colour and be very thin. Only 10% of the pie.

TIA

phil

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info