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

    sorting

    Yee Ling Gröschel

      Hiya,

       

      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