0 Replies Latest reply on Nov 14, 2013 7:22 AM by Yee Ling Gröschel


    Yee Ling Gröschel



      I have a stacked bar chart and I am trying to do a nested sorting with a bar chart.


      Refering to the example I have attached, I am trying to sort the "Location" in descending order by No. of prints and then sort the month in descending order.


      Result in a stacked bar chart:

      1) Mar - green, red, orange, blue

      2) Feb - blue, green, orange, red

      3) Jan - orange, green, blue, red


      In the workbook, the "Wanted Sorting Result - Descending Order" illustrates the order I am trying to do in a stacked bar chart.


      Any hints?


      Many thanks and kind regards,
      Yee Ling