Stacked Bar Chart Issue

Hi all,

I'm having an issue with a stacked bar chart.
I have 22 categories that are allocated for a different amount each month. And only 5 of them are allocated per month.
I tried to create a stacked bar chart to visualize this per month.

As you can see from the data below (and in the attachment), all the categories are ordered alphabetically. So in the stacked bar chart, the data gets order in alphabetical order as well.

What I am trying to do, is order them per size for each month.
So each month i want the biggest one on top and the smallest allocation at the bottom the chart.

31/01/2017 28/02/2017 31/03/2017 30/04/2017 31/05/2017
a 15.00% 18.00% 50.00% 0.00% 0.00%
b 0.00% 0.00% 0.00% 0.00% 0.00%
c 0.00% 0.00% 0.00% 0.00% 0.00%
d 0.00% 0.00% 0.00% 0.00% 0.00%
e 0.00% 0.00% 0.00% 0.00% 0.00%
f 0.00% 11.00% 0.00% 0.00% 0.00%
c 0.00% 6.00% 6.00% 0.00% 18.00%
h 0.00% 0.00% 0.00% 0.00% 0.00%
i 6.00% 0.00% 0.00% 0.00% 0.00%
j 50.00% 50.00% 15.00% 50.00% 0.00%
k 0.00% 0.00% 0.00% 0.00% 0.00%
l 0.00% 0.00% 0.00% 0.00% 0.00%
m 0.00% 15.00% 0.00% 11.00% 6.00%
n 0.00% 0.00% 0.00% 6.00% 0.00%
o 0.00% 0.00% 0.00% 0.00% 0.00%
p 0.00% 0.00% 0.00% 0.00% 0.00%
q 0.00% 0.00% 0.00% 0.00% 15.00%
r 0.00% 0.00% 11.00% 18.00% 50.00%
s 11.00% 0.00% 18.00% 0.00% 0.00%
t 18.00% 0.00% 0.00% 0.00% 0.00%
u 0.00% 0.00% 0.00% 15.00% 11.00%
v 0.00% 0.00% 0.00% 0.00% 0.00%


Could someone please help me with this?

Thank you!