My goal is to control the color of each group type in chart and it must be same color in showing types in table
Do you still need help with this? I think you might be able to do this by setting a variable equal to the desired Hex color.
hey @AbbeyHernandez!
how would this work exactly? where sould we set this variable about the hex color?
Hey @tui ![]()
I did some testing. Looks like you can't set colors in a chart with variables, but you can pick a color and hard code it as the relative tag color.
If you look at the image below you'll see the Sales color is set to a dark blue.
Now in the table if you select the column you'd like to work with and click the + sign next to Add Ons, click "Options List". There you can add an option for each tag and set the color to match your chart!
Here the JSON export of the app I made. Hope that helps! Please let me know if you run into any road blocks or have a clarifying question
.
colorTest.json (77.8 KB)
How I can match colors in Pie chart to colors of tags in table
Employee function "Engineering" in table have yellow color and in Pie chart must be yellow too
In other companies we could have other count of Employee functions - so hard coded it is not relevant
Hi @Dmitriy_Fedotov,
You can set the colors of the pie chart using Plotly JSON. Here's an example app,
chart_color_mapping.json (128.8 KB). Scroll to the bottom of the app and look at the data under the Plotly JSON tab.
You'll need to store the column values and their relative desired colors in an object then use that to set the colors on both the table and the chart.
In this example we have an object, roleColorMapping which list the roles and their relative colors.
Then in the chart data input under Plotly JSON we assign the color by returning an array of colors set dynamically by keying into the mapped color from the
roleColorMapping object with the value of the row item (see line 11).Let me know if that helps and if you have questions!
In the near future we’ll have a ton more preset chart types and that you’ll be able to do this in the UI soon! ![]()





