Combining a regular bar chart and stacked bar chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have 2 y-axis data series and years for the x-axis. For each year I
have side-by-side bars for the 2 different data series. For one specific
year, I would like to have stacked bars. I want to combine data from the
first half of the year and the second half of the year to create one bar for
each data series, with the 2 portions of the data making up each bar as a
different colors. Is this possible? Please help me ASAP as this is for a
publication at work. Thanks.
 
Sorry, I didn't think it would make a difference, but I should have said I am
currently using a "Line - Column on 2 Axes" graph from the custom types. So I
need the secondary axis for the 3rd data series. I have 3 data series and
just need one year to have stacked columns for the each of the 2 columns at
that year. Is this possible?
 
The columns are all of stacked column type on one axis, just some don't have
any columns stacked on top (i.e., the values are zero). The data is
staggered to provide clustering and spaces between clusters.

- Jon
 
Back
Top