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: