Forum Discussion

Jay2022's avatar
Jay2022
Icon for Helper IV rankHelper IV
3 years ago

Sorting Horizontal stacked chart by value largest to smallest

so I have 3 bars by 

store A

store B

store c

 

with % sales stacked from left to right 

 

how do i sort this by largest values 

eg 26%/22%/18% and so 

 

at the moment its all mixed up?

 

Is this even possible ?

4 Replies

  • JoeBarry's avatar
    JoeBarry
    Icon for Solution Sage rankSolution Sage

    Hi Jay2022 

     

    Top right of the visual there are 3 dots that appear when you hover over that area. click on those and choose Sort Axis and choose what you want to sort by and then you can choose either A - Z or Z - A each for lower to higher or reversed.

     

    Thanks

    Joe

     

    If this post helps, then please Accept it as the solution

  • Thanks that just sorts by prduct names eg a 2% b 15% c 42% and so on

    • JoeBarry's avatar
      JoeBarry
      Icon for Solution Sage rankSolution Sage

      You also have the option to sort by the value 

       

  • Thanks doesn't help in this instance think because i have stacked bars for store, a, b and c 

     

    thanks for trying anyway i'll keep looking