Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Breakdown of data in a bar chart
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a rolling average chart, adding most recent data? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |