is it possible to restrict values in the legend only to those that appear in the bar chart? Not all grades are represented in the chart, but all grades appear in the legend. See below.
ALSO, i'm wondering if there is some way I can assign a "sort value" (I just made up sort value) to each grade so that Pre-K and K appear before grade 1 and 12+ appear after grade 12. I'm thinking something like Pre-K=-1, K=0 and 12+ = 13 - do you see what I mean.
![stack bar chart grade on caseload kids.jpg](/legacyfs/online/192706_stack bar chart grade on caseload kids.jpg)