In my production line we collect quality issues. As I know the product, I know all possible quality issues (i.e. Surface quality, Printing not correct).
When I create a Bar Chart to show the quality issues counted in the last shift, only the recent issues show up (i.e. Surface quality).
I can not assign a custom color / label to a possible data value, that is not part of the query result.
When customising colors or labels for a chart, allow me to also set custom colours that are not part of the query result.