3 Replies Latest reply: Mar 29, 2016 1:58 AM by Gysbert Wassenaar RSS

    sorting stacked bar chart with 3 dimensions

    Armin Rauscher

      Hello,

       

      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

       

      Can someone help me to reach this goal?

       

      Thanks, Armin