Hello all, my goal is to display my data in a bar chart with 2 bars. I have the data in one category, from which I want to use 5 variables.4 of these (A, B, C, D) should be blocks in bar 1. And the 5th (X) should be bar 2. For this I have created a custom category using these 5 variables. In setting up the customized category I created one value group "Bar 1" where i placed the 4 variables (A, B, C, D) for Bar 1, and another value group for "Bar 2" where I placed the 5th variable (X). When I use my custom category in a bar chart, I now have two bars. One with A, B, C, D and one with X. My question is: In Bar 1. Can I customize the order of which A, B, C, D are stacked in the bar? They are now, from bottom to top, placed as A, B, C, D. I see that I can right-click the bar chart and change the order between decending and ascending. This only gives me two display-options: A, B, C, D and D, C, B, A. What if I want to display them as B, D, A, C ? I have tried to edit the custom category and change the order there, but nothing happens.
... View more