How can I stop Excel from changing the colors of my chart ?

I was dealing with his issue for quite some time (I'm on MS 365 Excel) - especially the series in my stacked bar charts would change the colour every time I would add another column and sort the value by the last data set added.

I have tried everything I managed to google, but nothing worked.

But then, I had a discussion and error/trial session with a colleague and voilà, I think we cracked it.

So, what was done --> legend was formatted (I know, it sounds insane, but it works in MS 365)

In the chart which you don't want to change any series colours, double-click on the coloured shape next to the series name and *format legend entry* --> in the fill colour, even if the colour is the same as you want it to be, just confirm it selecting it once again from the palette.
This way it works for me just the way I need - no series colour changes anymore, and I can sort the date up and down and all stays the same.

I hope it works for some of you at least too.

Let me pls know.