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
