Combination bar/stacked charts

D

DKS

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stacked Bar Graph 1
Stacked column graph 2
Graphing 20 months of data into 2 lines 3
Hiding 0 values on graph 1
Combine two different column charts 2
Combo chart format- what is the best way to achieve this design? 1
Stacked Chart (per month per year) 1
Combination Line and Bar Graph 1

Top