View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
RJB RJB is offline
external usenet poster
 
Posts: 86
Default Multiple Stacked Bars

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