Combining a regular bar chart and stacked bar chart
 

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.

Combining a regular bar chart and stacked bar chart
 

The first link on this page gives an example of the data arrangement you
need to achieve this visual effect:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Marshall" wrote in message
...
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.

Combining a regular bar chart and stacked bar chart
 

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?

"Jon Peltier" wrote:

The first link on this page gives an example of the data arrangement you
need to achieve this visual effect:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Marshall" wrote in message
...
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.

Combining a regular bar chart and stacked bar chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Marshall" wrote in message
...
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?

"Jon Peltier" wrote:

The first link on this page gives an example of the data arrangement you
need to achieve this visual effect:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Marshall" wrote in message
...
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.