Breakdown of data in a bar chart

I have created a bar chart showing 5 major categories. I would like to
display the breakdown or distribution of the sub-categories that make up the
data for the major category. Basically it's:

Category 1: Cat 1.1 + Cat 1.2 + Cat 1.3
Category 2: Cat 2.1 + Cat 2.2 + Cat 2.3 + Cat 2.4 + Cat 2.5
Category 3: Cat 3.1 + Cat 3.2
etc.

I am thinking of this as a "pie chart breakdown of a bar chart". A stacked
bar chart does not work because Cat 1.1 and Cat 2.1 are different
subcategories.

Any help or suggestions would be greatly appreciated.

But you could have lots of different subcategories:

Cat 1.1 Cat 1.2 Cat 1.3 Cat 2.1 Cat 2.2 Cat 2.3 etc....
Category 1 X X X
Category 2 X X X
Category 3

Only put data in cells containing an X above.

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


Steve wrote:

> I have created a bar chart showing 5 major categories. I would like to
> display the breakdown or distribution of the sub-categories that make up the
> data for the major category. Basically it's:
>
> Category 1: Cat 1.1 + Cat 1.2 + Cat 1.3
> Category 2: Cat 2.1 + Cat 2.2 + Cat 2.3 + Cat 2.4 + Cat 2.5
> Category 3: Cat 3.1 + Cat 3.2
> etc.
>
> I am thinking of this as a "pie chart breakdown of a bar chart". A stacked
> bar chart does not work because Cat 1.1 and Cat 2.1 are different
> subcategories.
>
> Any help or suggestions would be greatly appreciated.