I have a problem to sort the bar segments within a stacked bar chart.
Attached you can see my bar chart and a table for the explanation.
What i would reach is that within each year the bars are sorted according the total of the group (in my example CNG, SSC, TSC, ACSV because the totals are 514/292/146/88) and within each group the sorting should be the single count value. This means within CNG i would like to have first the 2, 1, 3, 4 because of the values like 283/ 147/ 81/ 3
Sorry for the confusion, for the bar chart i have combined group and the type that i can generate stacked bars. But the sorting of this combined bars should be according the 3 dimensions as explained above.