Sort clustered column chart by value

[Shivakrishna441]

Hi Team,

I need help to sort legend in clusted column chart by value.

I added year in X-axis, profit in Y-axis and ship mode in legend, so i want the bars(ship mode) to sort by profit in desc order.

Thanks in advance.

Regards,

Shiva

[Shivakrishna441]

Thanks for your reply @v-yadongf-msft 

but i am trying to sort the legend(ship mode) by value(profit in my case) but not by ship mode.

Your solution will sort the bar chart based on ship mode in alphabetical order.

[v-yadongf-msft]

Hi @Shivakrishna441 ,

Please follow the steps shown in the figure below:

If you still have any questions, please contact us in time.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.