Sorting Grouped Bar Charts

[jmonroe918]

I have a grouped bar chart (By Mon/Yr). I would like to display the columns Top 10 from left (highest values) to right (lowest values) which when Ascending is selected in the Sort tab is selected works fine with all years, and when each year is selected.

However when I change the Sort to Descend, all years display correctly (Right to Left) but the individual years selected seem to show the Bottom 10.

How do I get the chart to sort left to right, highest to lowest for all years when they are selected?

Thanks

How

[vinieme12]

try sorting by Y-Value

or

sort by expression >> The chart expression >> descending

[sunny_talwar]

Not sure what you are looking to do?? Why do you have single expression for each year? why not use Year as a dimension? What exactly are you looking to do?

[neelamsaroha157 · Accepted solution]

Check this out. i don't know why you are using different expression for each year.

[jmonroe918]

Neelam:

Based on the feedback received (from all 3 replies) and went to my chart and did exactly what you did in the attached.

I'm not sure why the expressions were created separately (I didn't create the original chart), but now I know better.

Thanks for the help.

Jeff

[jmonroe918]

Sunny:

As always, thanks again for responding.

Jeff