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.