Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value (Y) axis crosses between categories and Secondary Value (Y) Axis | Charts and Charting in Excel | |||
Secondary y-axis for certain x-axis categories (not by series) | Charts and Charting in Excel | |||
Sub-categories on the X axis | Charts and Charting in Excel | |||
Sub-Categories for X-axis labels, line on bar chart? | Charts and Charting in Excel | |||
how do I get the x-axis to plot values rather than categories in . | Charts and Charting in Excel |