Stacked Columns with different series in each column

Joined
Oct 18, 2012
Messages
1
Reaction score
0
Hi, grateful for any advice on this problem.

I want to create a stacked column chart, but each of the columns has different series.

So, as an example:

Column 1 would show total sales of smartphones split by Apple, Samsung, Motorola, Nokia

Column 2 would show total sales of bicycles, split by Trek, Giant, Specialized

Column 3 would show total sales of cameras, split by Canon, Nikon, Olympus

An unusual example, but the key points are that there is one data set (sales) split into multiple categories (which I want as individual columns) then within each column a stack of brands. The brands are not necessarily common to the different categories.

I may be missing something simple here!

Thanks in advance.
 

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