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.
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.