Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
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.
Any ideas how I might do this?
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