How do I combine stacked and clustered chart types?

K

Kate

I have data broken out by month (x-axis) and I want to provide quantity &
value columns for each month (using primary & secondary axis). Then I need
each column (quantity & value) broken out by region. I if I use the stacked
column chart, the quantity & value columns lay on top of each other. I need
them side by side like the clustered column chart. But the clustered column
chart won't allow me to show the region breakdown of each column.
 

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

Similar Threads

Can Excel produce a clustered and stacked column chart? 2
Clusted stacked column chart - "Value (Y) axis crosses betweencategories" greyed out problem 0
Clustered-Stacked-Column Combo Chart With Lines 2
Multiple stacked clustered bars 1
Needed: Chart that combines clustered column and stacked column types 3
Excel 2003 - Combination chart: Stacked Column + Stacked Column 3
Problem with Excel 2007 clustered column chart on log scale 1
Combining 2 different types of bar graph 1

Top