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

M

MB

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
 

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