Grouped X-axis Categories
 

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 |

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
|

Grouped X-axis Categories
 

This is exactly what I was looking for Andy! Thanks for your prompt response!

"Andy Pope" wrote:

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
|