Symptoms
After defining chart colors for a field on a table and stacking the columns, the colors are not in the expected order. What determines the order that the colors are displayed in?
Cause
The colors are ordered by the Chart Color "Value" field. See the chart above. In this case the columns stacked by incident.priority, and the color associated with each priority is defined in sys_report_chart_color. The colors will appear, left to right, based on the value.
Solution
Redefine colors that the system uses in reports under Reports > Administration > Color Definition.