Hi,
Have a look at
http://peltiertech.com/Excel/ChartsH...sterStack.html
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"RJB" wrote in message
...
Here is my data set:
2007 East 2007 West 2006 East 2006 West
Sid a b c
d
Nancy e f g
h
Johnny i j k
L
Salesman n n1 n2 n3
n4
I want to have a stacked chart with Salesmen 1-n on the X-axis.
And a bar for 2007 and a bar for 2006 for each. I can do it for one year,
and I can do it for all years if I combine East and West, but I can't
figure
out how to do both!
So something that looks like this:
|
|
|
|
| b d f h j L
|____ a__c____e__g____i_k
0706 0706 0706
Sid Nancy Johnny