Sort Columns in a Two Level X-Axis Graph

[garstc21]

Hi All!

I have made the graph seen below and would like to sort the users within each activity category in descending order by thier value in that category. So far I can only figure out how to sort them alphabetically. Any ideas? 

This may make things more confusing because my colors are very off, but see how the RUN activities are no sorted in descending order? This is what I am looking for. But for every grouping.

[amitchandak]

@garstc21 , Not very clear. But if you use two columns on the axis, You can sort on the axis and use conditional formatting and concatenate a label

Concatenate Label off and conditional formatting : https://youtu.be/QgI0vIGIOOk