Forum Discussion

fz1's avatar
fz1
Frequent Visitor
2 years ago
Solved

How to do nested sorting in a stacked column chart

Hello,  I am trying to do nested sorting in a stacked column chart and would appreciate any guidance on how to do it. This is my notional data:   This is what my stacked column chart (of num...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi fz1 

     

    You need to create two order tables.

     

     

    Merge each of the two order tables with the original data table.

     

     

    Expand the merged table, keeping the sort column.

     

     

    Click Close&Apply.

     

    Sort the Company and Model columns according to the following actions.

     

     

    Result:

     

    Best Regards,
    Yulia Xu

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi fz1 

 

You need to create two order tables.

 

 

Merge each of the two order tables with the original data table.

 

 

Expand the merged table, keeping the sort column.

 

 

Click Close&Apply.

 

Sort the Company and Model columns according to the following actions.

 

 

Result:

 

Best Regards,
Yulia Xu

 

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