Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination bar/stacked charts
Hi,
I have department wise and month-year wise sales data. I would like to generate a graph that allows me to show in stacked form for each month the data per department. And the same graph allows me to show in bar form data per year. Thus visual look of the chart required is as follows dept1 jan 2007 | dept1 jan 2008 |....... dec 2007 dept 2 jan 2007| dept2 jan 2008 |........dec 2007 : | : |................. : | : |................... | |................... january month 2007-2008-2009 | december month 2007-2009 In order to generate such a graph, how must I group my data, and how can I generate the graph? Many thanks in anticipation of your excellent suggestions. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination bar/stacked charts
Hi,
Jon has information on clustered stacks. http://peltiertech.com/WordPress/clu...column-charts/ Cheers Andy DKS wrote: Hi, I have department wise and month-year wise sales data. I would like to generate a graph that allows me to show in stacked form for each month the data per department. And the same graph allows me to show in bar form data per year. Thus visual look of the chart required is as follows dept1 jan 2007 | dept1 jan 2008 |....... dec 2007 dept 2 jan 2007| dept2 jan 2008 |........dec 2007 : | : |................. : | : |................... | |................... january month 2007-2008-2009 | december month 2007-2009 In order to generate such a graph, how must I group my data, and how can I generate the graph? Many thanks in anticipation of your excellent suggestions. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
Combination Charts - Stacked Bar w/ lines | Charts and Charting in Excel | |||
combination bar and stacked bar graph | Excel Discussion (Misc queries) | |||
Combination Stacked Bar with Single Bar Chart | Charts and Charting in Excel | |||
combination stacked column chart | Charts and Charting in Excel |