I have a data legend that, as expected, includes an explanation for all of the items on my chart that are color-coded:
However, the only items I want included in the legend are the “Needs Improvement” and everything to the right of that. Also I’d like to change the order of items in the legend.
Searching through the forum, I didn’t find a discussion of this issue.
Is the only way to fix this to create a copy of the chart, remove the offending “color states”, hide the new chart behind the old one and show the color legend for the new chart?