Help Rearranging Cluster Column Within Catagories

%3CLINGO-SUB%20id%3D%22lingo-sub-2638702%22%20slang%3D%22en-US%22%3EHelp%20Rearranging%20Cluster%20Column%20Within%20Catagories%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2638702%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20change%20the%20bars%20within%20the%20categories%20of%20the%20X-axis%20from%20largest%20to%20smallest%3F%20I%20do%20not%20want%20to%20rearrange%20the%20entire%20data%20set%20from%20smallest%20to%20largest%2C%20just%20within%20the%20groups.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20they%20want%20Dog%20to%20be%20arranged%20largest%20to%20smallest%20-%26nbsp%3B%20Grey%2C%20Blue%2C%20Orange%3B%20in%20Cat%2C%20they%20want%20it%20arranged%20Blue%2C%20Grey%2C%20Orange%3B%20in%20Bird%2C%20they%20want%20it%20Orange%2C%20Blue%2C%20Grey%3B%20in%20Lizard%2C%20they%20want%20it%20Grey%2C%20Blue%2C%20Orange.%20Yellow%20has%20to%20stay%20exactly%20where%20it%20is%20in%20all%20of%20the%20graphs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20scale%20isn't%20great%20in%20the%20picture%2C%20so%20sorry.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20appreciate%20any%20help%20you%20can%20provide.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Andrew145_3-1628744734804.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302612i6CCC0DE4401B52E4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Andrew145_3-1628744734804.png%22%20alt%3D%22Andrew145_3-1628744734804.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2638702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2748844%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Rearranging%20Cluster%20Column%20Within%20Catagories%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748844%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1126553%22%20target%3D%22_blank%22%3E%40Andrew145%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20rearranging%20data%20this%20is%20not%20possible%20in%20Excel%20charts.%20To%20fulfill%20this%20requirement%20need%20custom%20implementation%20of%20sorting%20on%20subcategory%20level%20measure%20value.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.