Hi Karin, this is already a standard functionality in the system. If you turn the switch underneath the "sort" setting, you are not only able to set specific colors to the answer categories, but you are also able to drag and drop the answer categories to any order of your choice.
Karin
I have an improvement idea for the following:
The sorting possibilities in charts and tables is currently limited. It would be helpful if it is possible to sort field A based on the values of field B. For example: you have this question with answer possibilities Completely agree, Agree, Disagree and Completely disagree. When you currently sort than the order will be Agree, Completely agree, Completely disagree and Disagree. The order should be: Completely agree, Agree, Disagree and Completely disagree.
Field A is also available in the score variant (_score). It would be great if it would be possible to sort field A based on the value of field A_score.