Aug 11 2021 10:10 PM - edited Aug 11 2021 10:12 PM
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.
Sep 14 2021 05:01 AM
Without rearranging data this is not possible in Excel charts. To fulfill this requirement need custom implementation of sorting on subcategory level measure value.