View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Grouped X-axis Categories

Hi,

Does this help?
http://www.andypope.info/charts/stackside.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Scott" wrote in message
...
I am trying to create a stacked bar chart that has two side by side stacked
bars per year. I would ideally like to have one of the stacked bars
labeled
with "Case 1" on the x-axis and the other labeled as "Case 2". I would
then
like to have the year show up below these axis values to kind of group
them.
i.e. for each year I would like to have the Case 1 and Case 2 values but
want
the year to change below them. Is there a way to do this without doing it
manually? Thanks.

Here is an example of what I would like it to look like:

Case 1 | Case 2 | Case 1 | Case 2 | Case 1 | Case 2 |
2008 | 2009 | 2010
|