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?
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.