Displaying ranked questions in reports in the same order listed in the question

Can anyone tell me if it is possible for the report (histogram) showing ranked questions to be ordered according to the order of the ranking in the questions i.e. 5-point likert scale for example - very bad, bad, average, good, very good, don’t know. Currently the data is displayed randomly in the report. Thanks

@lornamwslade, the custom report generated by KoboToolbox is limited by many limitations. Maybe you could link your data with Power BI or Excel and then create your desired chart that meets your needs, as they are more powerful for data visualization.

As far as I know the automatic (not adaptable) sort/order is based on the value frequencies.

@Kal_Lam It would by preferable, if the Kobo report follows the order of the choice_list. (But there might be some disadvantage for value lists with more than 5 items, which is the automatic report cut-off.)

Thank you, yes I will have to do that if I cannot modify the Kobo report.

I agree, it would be helpful to have a choice in how the data is displayed in the Kobo report either by the order of the choice_list, or by values. Thanks.