Maintaining colors on a donut viz acording to the position and not the result.

[leo28]

Hi, I want to use donut charts to show platform distribution across different metrics, but they do not maintain colors across all three that I am creating, making it difficult to grab the info on a single look without looking at the legend on all three charts.

Is there a way to assign colors to the series that I am plotting or can they get assigned by the position they have on the source table.

this is how it looks:

but the table is organized this way:

thank you so much for your help.

Leo

[leo28 · Accepted solution]

for some reason the first graph does not show here it is: