Help Rearranging Cluster Column Within Catagories

Copper Contributor

Hi,

 

How do I change the bars within the categories of the X-axis from largest to smallest? I do not want to rearrange the entire data set from smallest to largest, just within the groups.

 

For example, they want Dog to be arranged largest to smallest -  Grey, Blue, Orange; in Cat, they want it arranged Blue, Grey, Orange; in Bird, they want it Orange, Blue, Grey; in Lizard, they want it Grey, Blue, Orange. Yellow has to stay exactly where it is in all of the graphs.

 

The scale isn't great in the picture, so sorry.

 

I really appreciate any help you can provide.

 

Andrew145_3-1628744734804.png

 

 

 

 

 

1 Reply

@Andrew145 

Without rearranging data this is not possible in Excel charts. To fulfill this requirement need custom implementation of sorting on subcategory level measure value.