Same color twice in graph

[emmanueld]

Hello community,

Is there a way to avoid this kind of behavior please?

=> I have two distinct values with the same color that appear one after the other. The sort order is Y-value descending.

Thank you

[emmanueld]

I could have an excel file for the mapping but the problem would be the same : at some point if a new value appears there won't be anyone to update the excel file, so several new values will get the same default color.

I was looking for a way to have a new color for each value in an way that would be automatic but I think it's not possible.