Forum Discussion

neatmachine's avatar
neatmachine
Microsoft Employee
5 years ago

Sorting a Clustered Column Chart by a Specific Legend Value

Hello helpful friends,

 

I've got a clustered column chart that has a legend based on which week (current or previous) the data belongs to. This results in a pretty useful chart that shows data (sorted by some Y value) with each current week bar next to its bar from the previous week. I've got a request to sort this chart by its current week value (not just Y, but Y under this particular legend value). Is this possible? Can anyone point me in the right direction?

 

Thanks!

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support

    Hi neatmachine 

    Can you show your current visual and expected result with some screenshot or pictures (after removing sensitive info)? I don't understand what the visual expected to be like. Dummy data is also appreciated. Thanks.

     

    Regards,
    Jing