Reference code colours bug
I am using several sets of reference codes to determine the colours for several different stacked bar charts. If two sets of reference codes contains the same code/description, then the colours are applied randomly.
I am using the reference codes in Picture 1 to colour the chart in Picture 2. As you can see, the "Acquiring" portion of the chart should be blue but is coming out yellow. After hunting around, I found that the ENTIRELY SEPARATE reference code in Picture 3 also contains the code/description "Acquiring" with the associated colour being yellow.
Could you please explain how/why this is happening and how to avoid it - currently I am having to manually set the colour of each series across all my charts because I have no idea if/when a similar problem will occur.