Chart Colors with Format Rule

AppSheet AppSheet Q&A
1

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](https://community.appsheet.com/t/pie-chart-colors-applied-to-color-and-switch-expression-result/10061) 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”, “…

1 Like
2

At this time I don’t believe there is any other options

1 Like
3

The colors match the columns order in the view options:

2X_2_2ed2965d23adc919310f2fda14d226d27d7e74ad.png
2X_2_2ed2965d23adc919310f2fda14d226d27d7e74ad.png828×598 26 KB

1st data column get first color, 2nd gets 2nd, 3rd gets 3rd, etc.

4 Likes
4

Hi Mark, this is how its configured now but if a user adds another record, someone would always need to go into AppSheet to update the configuration. Was hoping to be able to assign a color with another field the user had access to.

1 Like
5

Not sure I follow. In the above I’m specifying colors for columns. Adding new records will always follow the same columns/colors. Are you using a Row series chart?

2 Likes
6

Yes apologies March, I have a single column that will contain multiple rows - lets say for example sales reps. Everytime a sales rep is added a color would need to be configured to the sales rep in AppSheet in this row scenario. Is there another way to manage this type of chart?

1 Like
7

No, I suppose not.

1 Like