How do I create a combined 'cluster' and 'stacked' column chart?
 

I am trying to create a combined cluster and stacked column chart. This is
exactly the same need as a previous query i.e.

"I am trying to create a cluster chart for a 5-year period, where the x-axis
is the year and the y-axis represents a sales dollar value. There are two
sets of data for each year (hence a two-column cluster chart). However, the
second of the two columns for each year incorporates two types of sales data,
and thus I need to stack the two data points to show the breakout between the
two types of sales data. The height of this second column should be the
combined value of the two sets of sales data, but I need to stack them so
that I can color them differently in order to view the two separate pieces
that make up the whole.

Is it possible to create a cluster chart where one of the columns is stacked?"

Has anyone found a solution to this?

Much appreciated
MB

How do I create a combined 'cluster' and 'stacked' column chart?
 

Hi,

Links to solutions can be found here.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"MB" wrote in message
...
I am trying to create a combined cluster and stacked column chart. This is
exactly the same need as a previous query i.e.

"I am trying to create a cluster chart for a 5-year period, where the
x-axis
is the year and the y-axis represents a sales dollar value. There are two
sets of data for each year (hence a two-column cluster chart). However,
the
second of the two columns for each year incorporates two types of sales
data,
and thus I need to stack the two data points to show the breakout between
the
two types of sales data. The height of this second column should be the
combined value of the two sets of sales data, but I need to stack them so
that I can color them differently in order to view the two separate pieces
that make up the whole.

Is it possible to create a cluster chart where one of the columns is
stacked?"

Has anyone found a solution to this?

Much appreciated
MB