Our software has color coded statuses that it displays in various parts of the program. I am trying to match up those colors in the report on a graph. So, for example, each status will have a bar on the graph and the color that appears should be the same color our program uses.

I can see under Chart Expert -> Color Highlights that if I know what value corresponds with what color I can hard code each one onto the report. My problem is that these statuses are user created, so the values are dynamic. Is they anyway to set the bar color based off of a formula or a database field?