I need to get a chart that shows split by 2 level of categories
Sorry, don't know how to formulate it in words, so I wite it by an example
for instance, that would be sales of sweets - they would be divided
1) by type of sweets (Candies, Chocolate, Ice-cream, others)
2) and by weight 0-100gr, 101-200gr, 201-300gr etc.
so the vertical bars would represent proportional split by one category (by weight in this case)
and each vertical bar is split by propoprtional value of other category (type of sweets in this case)
So in case if one of weight segments has very low sales numbers, it is very narrow, and other that has big sales numbers wide.
I have got this example (so i now it is possible to create this type of chart) and it's type is Area chart, but when I try to create such a chart from Scrach I can't seem to find a way to do this.
Can anyone explain how can I create this type of chart?
Sorry, don't know how to formulate it in words, so I wite it by an example
for instance, that would be sales of sweets - they would be divided
1) by type of sweets (Candies, Chocolate, Ice-cream, others)
2) and by weight 0-100gr, 101-200gr, 201-300gr etc.
so the vertical bars would represent proportional split by one category (by weight in this case)
and each vertical bar is split by propoprtional value of other category (type of sweets in this case)
So in case if one of weight segments has very low sales numbers, it is very narrow, and other that has big sales numbers wide.
I have got this example (so i now it is possible to create this type of chart) and it's type is Area chart, but when I try to create such a chart from Scrach I can't seem to find a way to do this.
Can anyone explain how can I create this type of chart?