Stacked & Grouped Bar chart

[endoflux]

All--

I'm looking for a way to create a chart that I don't see in excel's 'chart picker':

It should be a bar graph with 12 categories on the x-axis (Jan, Feb, etc), and 3 sub-categories for each of the 12 (CD, AFD, EE). Each of these sub-categories will have 6 series (New, In Process, Complete, Hold, Canceled, Not Started).

The link below shows what I've been able to get so far...now I just need to divide each of those on the x axis into 3 sub categories...

http://www.handsoffmn.org/chart.jpg

I guess the part that confuses me is how to get the 3 sub categories on the x axis...is it possible?

 

[VicRauch]

You might want to look at this idea. As you can see, I have put in a blank (4th) subcategory (actually a 3rd in my data) to separate the three subcategories from the next month.
It's going to need a little twiking to make it look like you want, but I think this shows the idea

 

[SkipVought]

Hi,

Your pic does not explain the groupings that you desire.

Where are the CD, AFD, EE groups and the subsequent New, In Process, Complete, Hold, Canceled, Not Started.

How do you want these represented?

By Sub Categories, do you mean Cluster Chart? It is not possible to mix Cluster and Stacked on one chart. You might have to think in terms of either multiple superimposed charts or code generated rectangles that appear like a chart.

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[AndyPope]

Have a look here for a collection of examples of how to create a clustered/stacked chart

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy