New random color for new group in column chart

[AlexeyRusinov]

Hello everyone,

I have a simple column chart, currently having 5 bars. In the future new groups may appear, so number of bars may increase. 

Currently, by default, some bars share the same color, which is default color I set in "Data Colors" section. 

I want every bar to have different random color, so that if new bars appear, I don't have to set random color for it manually. 

Color saturation is not working for me, columns with same values should still have different colors, colors should be random.

Is it possible to achieve? 

Please help.

[v-chuncz-msft · Accepted solution]

@AlexeyRusinov,

As far as I know, the only option is to take advantage of the Legend field.