Combining a regular bar chart and stacked bar chart

M

Marshall

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.
 
M

Marshall

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?
 
J

Jon Peltier

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
 

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

Top