Re: Column Charts for Pie Slices?

From: Jon Peltier (DOjonNOT_at_SPAMpeltiertechME.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 08:48:42 -0400

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/
_______

DRM wrote:

> 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!