Chart Colors with Format Rule

[Daisy_Ramirez]

Based on the info found here, it looks like we’re unable to control the exact color of a chart column. It appears the system, assigns colors based on the alphabetical order of the data. I have a table I’m displaying for the user where a format rule highlight should correspond to the chart colors for consistency but I can’t find a way to identify the color the system assigned to the data in order to ensure the format highlight rule matches.

Is there another way to manage the colors?

Here is article reference:

Pie chart colors applied to [COLOR] and switch expression result Questions

@tony @morgan @Aleksi I’m having trouble with pie chart colors similar to the following post: [Pie chart colors! Is there a way to tie spec] However, rather than using an ENUM column, I’m using a COLOR column with a single option “Green” that renders as a checkbox in a form. An IF expression changes the color of a STATUS column (box checked = GREEN, box unchecked=RED) and a switch expression is used to create more meaningful labels for the chart legend - SWITCH([DAILY], “Green”, “complete”, “…