Column Charts for Pie Slices?

[DRM]

Hi.
What a great forum! Hope someone can help me (went back
about a month and didn't see this question).
My pie chart has 5 slices (# of employees for each of 5
departments). Each slice consists of 2 values (male,
female). I'd like each slice to "point" to its own
stacked column chart that shows how the slice is
distributed across the two values. So the pie chart
itself shows the distribution of employees across
depatments, and the 5 associated stacked column charts
show the relative number of male and female employees for
each dept. Any ideas? Thanks!

 

[Jon Peltier]

You could make your pie chart, then make a bunch of smaller column or
bar charts to break each wedge down by gender, and arrange them so they
look like they go together.

But I think you can show all of this better with a stacked column chart.
Arrange the data like so:

Dept A Dept B Dept C Dept D Dept E
Male
Female

Select the range and make a stacked column chart, with the series in
rows. The height of each stack shows the relative size of each
department, and you can see the relative breakdown of men and women in
each stack.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______