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.
Many thanks and kind regards,Yee Ling
Retrieving data ...