Colour of dots on scatter chart by other dimension
I have 2 charts the first one is a simple chart that shows sales opportunity value by the opportunity stage. By activation 'multicoloured' each stage is assigned a colour.
My second chart is a scatter chart showing every opportunity by its age and its value. I would like to colour each dot by referencing the associated opportunity stage so that the colours are consistent.
Override the color in both charts by using the Background Color option of the expression. Use something like Color(FieldIndex('Stage',Stage)) to give each stage its own color. Or load an small table with Stage and color like explained in this blog post: Colors in charts