Can I make a pie chart where the slices are also graphical?

  • Thread starter Thread starter phil
  • Start date Start date
P

phil

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
 
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
Click to expand...

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 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
 
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.
 
Back
Top