I have a couple of different bar charts that are used to show our workload schedule. The intent is for the bars to represent a heat map (red > yellow > green) to show associates the expected due date for their work.
I can set the custom colors on the bar chart, but they never seem to stay those colors for very long. They will alway change to various other colors. Some colors seem to hang around, while others will change.
I can't see how this would be expected behavior, because it makes it nearly impossible to communicate to associates via a bar chart if the colors continually change.
Two things of possible note:
- The field that the bars represent is a formula text field
- There are seven potential outcomes of the text field, and not all are present at any given time in the bar chart
Does anyone know how to make the colors stay consistent?