Forum Discussion

Andrew145's avatar
Andrew145
Copper Contributor
Aug 12, 2021

Help Rearranging Cluster Column Within Catagories

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.

 

 

 

 

 

 

Charting
excel

1 Reply

  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    Sep 14, 2021

    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.

Resources