I've created a health score column chart by CSM, the colors are ordered from yellow, red, orange, lime, green instead of being ranked from red to green. I think we need the ability to adjust the ordinal scale in charts.
I would also appreciate this. I have scenarios where the labels are written as things like "1-6 months" ,"6-12 months", "12+ months" and the "12+ months" ends up in the middle instead of the end. Being able to manually order the labels would make my graphs much simpler to read.