Occasional Visitor
Posts: 1
Registered: ‎03-08-2017

Stacked 100% Column Chart with different values

Hi All,


I'm working on a very simple graph the ideal output would be one  100% stacked bar chart with two bars : One Bar showing me count of the column, the second showing me the sum of it. In the dataset I have 4 stores A,B,C & D and each brand is labeled as Best, Better or Good. In the bar I would be showing the breakdown by these labels for both count and sum. Since I'm unable to select to show both count and sum together, I have created another chart and made everything but the bar invisible in the second graph. This was my temporary solution but it would be great to have both these bars in one chart. Let me know what I can do. Thanks!