Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

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

Reply
Senior User
Posts: 1

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

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

 

SAS Employee
Posts: 9

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

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

 

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 124 views
  • 1 like
  • 2 in conversation