Stacked Bar Chart - Colors by Dimension

[Mav70]

Hi,

I have several stacked bar charts with 2 dimensions - Stage and RAG status. Each chart measures a particular RAG (e.g. effort, schedule etc) - see attached. I need to use consistent colors across the charts whereby a Green RAG is always green, a Red RAG is always red, an Amber RAG is always Amber and an "Unset RAG" is grey. Depending on the dayta there may not always be all 4 RAGs on each chart.

Setting the colors on the Color tab doesn't work due to this last point. Any ideas how this can be achieved?

Thanks in advance,

[jwjackso · Accepted solution]

On the Colors tab, is "Persistent Colors" checked?

[Mav70]

Hi,

Yes, have tried that but to no avail.

[Brett_Bleess · Accepted solution]

Have a look at the following Design Blog post, hopefully that may do the trick for you:

https://community.qlik.com/t5/Qlik-Design-Blog/How-to-custom-color-a-stacked-bar-chart/ba-p/1465653

Regards,
Brett

[Mav70]

Thanks both. Have this sorted now.