It is found that for Bar Chart, if Group by Categories, and Sort Series, then the bars would be sorted without taking the Category Grouping into account. e.g. if sort series by desc order, then when the series value of a later group is bigger than that of a prevoius group, the bar would be displayed incorrectly
Is there any way to overcome this please?
