Chart + table with related colours

Ask us anything How do I?
1

Hello,

I would like to create a visual using a doughnut chart alongside a table, similar to the screenshot below. The idea is to have the border of the table cells match the colors used in the chart.

image
image967×826 60 KB

So far, I have created the doughnut chart and the table using the same data collection and sorted the collection so that both appear in the same order. However, I am struggling to match the border colors of the table cells with the corresponding data colors in the chart.

Would someone have an idea to do this?

Thank you!

2

Could you just set the bottom border to the color of the cell based on the cell’s data?

3

Oh that’s smart thank you. I used the switch formula to do that + a concatenate for the border design.

Thank you !