Sorting question about Stacked column chart

How can I sort order ? Higher percentage to the top ? And still keep the sequence of Site no. in order which is Site 1-5 And the legend of answer is still in order which is Answer 1.1, 1.2, 1.3, 1....