How to ordering bars in bar chart with a group column present

bjordan — Thu, 20 Apr 2017 14:40:50 GMT

I have a bar graph that uses both a category (School_Name) and a group (School_Category). If I use just the category (School_Name), I get a graph that look close to what I need, where the school with the most is the tallest bar on the left and things get smaller as you go to the right. The user wants to color code the bars based on the school category. I can get the color coding by adding School_Category to the Group role, but then the sort sequence is changed to alphabetic by school name, and the sort option is no longer available. How do I get the bars to sort in descending Y-Axis order while keeping the color coding benefit of the group column/option. See attached for examples of what I'm seeing.

Thanks

Re: How to ordering bars in bar chart with a group column present

KeithM — Thu, 20 Apr 2017 17:09:59 GMT

I created this SAS Sample that provides a workaround. http://support.sas.com/kb/59/480.html

topic Re: How to ordering bars in bar chart with a group column present in SAS Visual Analytics

How to ordering bars in bar chart with a group column present

Re: How to ordering bars in bar chart with a group column present